Forum Discussion

SuperSingh's avatar
SuperSingh
Contributor
7 years ago

Extracting child node from JSON Response

I have Metadata in my response that contains nodes & child nodes. I am looking at way to extract child node & its value using groovy but not able to find.   Below is the sample metadata response. ...
  • PaulMS's avatar
    PaulMS
    7 years ago

    Script assertion with jsonslurper or jsonpath.

    See http://goessner.net/articles/JsonPath/

     

    import com.eviware.soapui.support.XmlHolder
def holder = new XmlHolder(context.Response)
def Metadata = holder["//*:MetaData"]
//log.info Metadata

import static com.jayway.jsonpath.JsonPath.parse
log.info parse(Metadata).read('$.[?(@.Type==ItemList)].OptionValues.Item 1[0]')
  • PaulMS's avatar
    PaulMS
    7 years ago

    That sounds like a job for JsonSlurper

    http://docs.groovy-lang.org/latest/html/documentation/#_processing_json

     

    If the name Item 1 and value are not constant how would you identify the expected result for assertions? Is it the first name in OptionValues? This code could help

     

    import com.eviware.soapui.support.XmlHolder
def holder = new XmlHolder(context.Response)
def Metadata = holder["//*:MetaData"]
//log.info Metadata

import groovy.json.JsonSlurper
def json = new JsonSlurper().parseText(Metadata)
def map = json.OptionValues[2]
log.info map.entrySet()
log.info map.entrySet()[0]
log.info map.keySet()[0]
PaulMS's avatar
PaulMS
Super Contributor
7 years ago

Script assertion with jsonslurper or jsonpath.

See http://goessner.net/articles/JsonPath/

 

import com.eviware.soapui.support.XmlHolder
def holder = new XmlHolder(context.Response)
def Metadata = holder["//*:MetaData"]
//log.info Metadata

import static com.jayway.jsonpath.JsonPath.parse
log.info parse(Metadata).read('$.[?(@.Type==ItemList)].OptionValues.Item 1[0]')
  • SuperSingh's avatar
    SuperSingh
    Contributor
    7 years ago

    Bang On ! Thank You So Much PaulMS !

    Ran your query and I get what I needed. Your query is so precise & to the point without much hussle :D

    Really Appreciate it.

     

    Best,

    Predator .

  • SuperSingh's avatar
    SuperSingh
    Contributor
    7 years ago

    PaulMS

    Quick Question : You gave the query to pick  the value of the node .How do I get the node itself ?

    E.g. The query returns the value of "Item 1" . But How do I extract "Item 1" , "Stock 2" .?

     

    Thanks in Advance !

     

    Best,

    Predator

    • PaulMS's avatar
      PaulMS
      Super Contributor
      7 years ago

      Do you want to return all OptionValues?

       

      JSONPath '$.[?(@.Type==ItemList)].OptionValues.[0]' result is 

      {"Item 1":"-$10","Item 4":"-$40","Total Items":"-$150","Stock 2":"-$20","Row 6":"-$50","Element 1":"-$30"}

      • HKosova's avatar
        HKosova
        SmartBear Alumni (Retired)
        7 years ago
        PaulMS wrote:

        Do you want to return all OptionValues?

         

        JSONPath '$.[?(@.Type==ItemList)].OptionValues.[0]' result is 

        {"Item 1":"-$10","Item 4":"-$40","Total Items":"-$150","Stock 2":"-$20","Row 6":"-$50","Element 1":"-$30"}

        Alternatively, you can use this JSONPath query:

        $..OptionValues[?(@['Item 1'])][0]

        which  means "give me the OptionValues instance that contains the 'Item 1' property.