Forum Discussion

Jseban's avatar
Jseban
Occasional Contributor
8 years ago

JSONSLURPER - How to check optional array available in response and save value in property?

Hi,   Below is a sample JSON response.   { "uri": "VehiclesandGadgets", "Types": { "Vehicle": [{ "label": "Click to expand", "value": { "Cars": [{ "label": "Click to expand", "value": { ...
  • nmrao's avatar
    nmrao
    8 years ago

    Jseban,

     

    Ok, thank you for the details and patience.

     

    You can use below :

    //Pass json string to below parseText method
def jsonRes = new groovy.json.JsonSlurper().parseText(json)
//Get the make 
def makes = jsonRes.Types?.Vehicle?.value?.Cars?.value?.Properties?.Make
//Assign actual data, otherwise assign NA
def result = makes ? makes.flatten()[0] : 'NA'

log.info result

//You can proceed using result variable do the stuff you needed to do.

     

    Also you can quickly try it online demo

nmrao's avatar
nmrao
Champion Level 3
Sure, the values can be extracted. But can't be stored into property as this is complex object and property can hold simple string.

It would be helpful if you could tell how you are going to use that data? assertion of values or comparing with someother data?
Jseban's avatar
Jseban
Occasional Contributor
8 years ago

What I am trying to do is 

 

if (condition to check if property array is present in the response)
context.testCase.testSteps["Properties"].setPropertyValue("Make", jsonSlurper.Types.Vehicle[0].value.Cars[0].value.Properties[0].Make)


else
context.testCase.testSteps["Properties"].setPropertyValue("Make", "NA")

  • nmrao's avatar
    nmrao
    Champion Level 3
    8 years ago
    You put the code to earlier statement.

    What I was asking was that how this value going to be used? Otherwise no need to store in the property, right?
    • Jseban's avatar
      Jseban
      Occasional Contributor
      8 years ago

      This value will be used later in another script to compare with another variable from an input excel, but only if it is not 'NA'

       

      If i do a condition check like "if(jsonSlurper.Types.Vehicle[0].value.Cars[0].value.Properties[0])", I am getting the null object found error. 

      • nmrao's avatar
        nmrao
        Champion Level 3
        8 years ago

        Jseban,

         

        Ok, thank you for the details and patience.

         

        You can use below :

        //Pass json string to below parseText method
def jsonRes = new groovy.json.JsonSlurper().parseText(json)
//Get the make 
def makes = jsonRes.Types?.Vehicle?.value?.Cars?.value?.Properties?.Make
//Assign actual data, otherwise assign NA
def result = makes ? makes.flatten()[0] : 'NA'

log.info result

//You can proceed using result variable do the stuff you needed to do.

         

        Also you can quickly try it online demo