Forum Discussion

krispokkuluri's avatar
krispokkuluri
Occasional Contributor
3 years ago

How to query circular json to get desired values which are present deep in sub nodes using groovy ?

Hi , Given is a below json object which basically grows based on the data provided in the ui in a circular json way . I am trying to fetch the latest grant details based on the grantdetailId in the ...
Data-Driven Testing
Function Tests
REST
Scripting
KarelHusa's avatar
KarelHusa
Champion Level 3
3 years ago

Hi krispokkuluri ,

you can try to analyze the JSON with JSONPath, e.g.:

 

import com.jayway.jsonpath.JsonPath

def json = new File("C:\\MyPath\\MyFile.json").text

def maxGrantDetailId = JsonPath.read(json, '$..GrantDetailId.max()')
def grantInfo = JsonPath.read(json, "\$..*[?(@.GrantDetailId == ${maxGrantDetailId})]")

assert grantInfo.Quantity[0] == 10

You can check your JSONPath at https://jsonpath.herokuapp.com/ and then apply it inGroovy.

 

Another option could be to utilize the JSON DataSource test step.

 

Best regards,

Karel