sumeetb
Occasional Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: How to generate multiple data from json response in data source
I can but i am not able to set the property variable named as "id" with multiple rows. Please see below script. import net.sf.* import net.sf.json.* import net.sf.json.groovy.* def response = context.expand('${Get Summary#Response}' ) def jsonSlurper = new JsonSlurper().parseText(response) for(String id:jsonSlurper.summary.test.id){ result["id"]=id } The result i get is property variable "id" is getting set with last value only (with this only 6780837264054677)2.2KViews0likes1CommentRe: How to generate multiple data from json response in data source
I wanted to use those extracted ids into another REST request by adding datasource loop. That's why wanted to generate those in data source and use them in another REST request. I am not sure how i can set data source rows with extracted ids using groovy script of data source. Could you please help?2.2KViews0likes3CommentsRe: How to generate multiple data from json response in data source
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.2.2KViews0likes6CommentsHow 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 if i am removing '[0]' ($.summary.test.id) then its not generating any rows. How do i generate all rows from Json response matching with id.?2.3KViews0likes9Comments