Unable to print list of all nodes including child nodes of a Json response using groovy script

Question

Unable to print all node values and also child node values of a JSON response using groovy script in a Soap UI basic version&nbsp;Below is my response{&nbsp;&nbsp; "lookupResponse": {"branches":&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "longitudeForMap": "-87.541405",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "latitudeForMap": "37.976581",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "foundWithinRadius": true,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "branch": [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "branchNumber": "123",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "location": "Balt-NE, IN",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "addressLine1": "test RD",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "addressLine2": "",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "city": "Baltimore",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "state": "IN",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "zip": "47715",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "branchManager": "tester, DAN",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "branchEmail": "test0435@gmail.com",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "phoneNumber": "(123) 479 - 6895",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "mloId": "98521",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "longitude": "-87.492300",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "latitude": "37.993700",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "distance": "2.920000",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "speaksSpanish": false,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "faxNumber": "(123) 473 - 5349",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }]&nbsp;&nbsp; }},&nbsp;&nbsp; "referenceNumber": "12345678",&nbsp;&nbsp; "status": "SUCCESS"}&nbsp;Below is my Groovy code:import groovy.json.*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; def response = context.expand( '${'+strRequestName+'#Response}' )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; def jsonResponse_Act = new JsonSlurper().parseText(response)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log.info "node lesngth is "+ jsonResponse_Act.size()&nbsp; for(int nodeid=0 ; nodeid&lt;int_nodelength;nodeid++)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //Getting error at this statement&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log.info jsonResponse_Act[nodeid]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }Tried this also&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; def nodes=jsonResponse_Act.lookupResponse&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log.info "size "+ nodes.size()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; log.info "value&nbsp; "+ nodes[0]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

nmrao · Answer

What are you trying to achieve as just printing does help any way?

ashwin05 · Answer

I wanted to capture all the actual node and compare it with expected response nodes. I cannot compare the whole response as most of the node values would change every time, so I would want to check if all the expected nodes are available or not.

To achieve this I thought of comparing with list of actual nodes names and expected.

nmrao · Answer

If values gets varying, then what specific values do you need to compare?

ashwin05 · Answer

Hi Rao,&nbsp;&nbsp;As per my requirement I need to capture all node values individually &nbsp;&amp; store into an Excel without passing the node names.&nbsp;Apart from this I also need to compare few nodes like branch number, status and branch email etc to compared with expected.&nbsp;&nbsp;&nbsp;

nmrao · Answer

Not sure why to store hierarchical data (json in your case) and put it in flat format? How do you accommodate json arrays? IMO, it does not make sense to put in excel.
&nbsp;
In case it is needed for later use, just persist the entire response into a file and give file reference in the excel if it is mandatory so you would not lose context where the file and what was the response&nbsp; then.
&nbsp;
It is very much possible to compare the specific keys of the json.

Forum Discussion

Unable to print list of all nodes including child nodes of a Json response using groovy script

6 Replies

Related Content

Unable to see the full response

Unable to recognize a button in LoadNinja

Unable to read response of one rest test step

Unable to write response in Excel using Datasink

Unable to log into almcomplete

Recent Discussions

SoapUI OSS apidocs are outdated in April 2024

log4j1.x vulnerability

How to upload a file via SOAP, as an attachment using python zeep

Soapui 5.7.1 dependency : thoughtworks:xstream:jar:1.4.20

How to configure Swagger in Paas to use it in Oracle APEX instance.