Forum Discussion

sumeetb's avatar
sumeetb
Occasional Contributor
9 years ago

How to generate multiple data from json response in data source

I have data source as test step and i am trying to extract multiple ids returned in json response. I am using this Row path "$.summary.test[0].id[0]", then it generate 1 row with correct data , but i...
sumeetb's avatar
sumeetb
Occasional Contributor
9 years ago

Please see json response below.

 

{
"summary": [{
"id": "26590924327313990",
"name": "Summary-1",
"state": "ACTIVE",
"runTimestamp": 1473138585467,
"scheduledTimestamp": 1473138585507,
"createdTimestamp": 1473138585507,
"test": [{
"id": "15473842955298105",
"name": "test-1",
"createdTimestamp": 1473138585467,
"runTimestamp": 1473138585467,
"status": {
"Pass": 10,
"Fail": 20
}
}]
},
{
"id": "30493603067815445",
"name": "Summary-2",
"state": "ACTIVE",
"runTimestamp": 1473138254517,
"scheduledTimestamp": 1473138254520,
"createdTimestamp": 1473138254520,
"test": [{
"id": "6780837264054677",
"name": "Test -2 ",
"createdTimestamp": 1473138254517,
"runTimestamp": 1473138254517,
"status": {
"Pass": 1,
"Fail": 2
}
}]
}]
}

 

I need to extract all ids of summary.test.id 

i checked with summary.test still not able to get values. its returning zero rows.

nmrao's avatar
nmrao
Community Hero
9 years ago

Here is the groovy script:

 

import groovy.json.JsonSlurper
​def response = '''{     "summary":[  
      {  
         "id":"26590924327313990",
         "name":"Summary-1",
         "state":"ACTIVE",
         "runTimestamp":1473138585467,
         "scheduledTimestamp":1473138585507,
         "createdTimestamp":1473138585507,
         "test":[  
            {  
               "id":"15473842955298105",
               "name":"test-1",
               "createdTimestamp":1473138585467,
               "runTimestamp":1473138585467,
               "status":{  
                  "Pass":10,
                  "Fail":20
               }
            }
         ]
      },
      {  
         "id":"30493603067815445",
         "name":"Summary-2",
         "state":"ACTIVE",
         "runTimestamp":1473138254517,
         "scheduledTimestamp":1473138254520,
         "createdTimestamp":1473138254520,
         "test":[  
            {  
               "id":"6780837264054677",
               "name":"Test -2 ",
               "createdTimestamp":1473138254517,
               "runTimestamp":1473138254517,
               "status":{  
                  "Pass":1,
                  "Fail":2
               }
            }
         ]
      }
   ]

}'''
def summary = new JsonSlurper().parseText(response).summary
def expectedIds = [15473842955298105, 6780837264054677]
def actualIds = []
summary.each { summaryItem ->
   summaryItem.test.each { testItem -> 
      actualIds << testItem.id 
   }
}
log.info actualIds
assert actualIds.sort() == expectedIds.sort(), "Test Ids are not matching"
​