CODEWITHSUNDEEP
jsongroovy
user2743905
user2743905

Reputation: 13

Getting node from Json Response

I have the following Json response:

 {
    "0P0000G5ZQ":    [
    {
    "Title": "PIMCO Unconstrained Bond Inst",
    "ResourceId": "587723",
    "PublicationTime": "2013-03-07 14:13:00 -0600",
    "Type": "Research",
    "Href": null,
    "VideoThumbnail": null,
    },
    {
    "Title": "Nontraditional Bond 101",
    "ResourceId": "609234",
    "PublicationTime": "2013-08-27 06:00:00 -0500",
    "AuthorName": "Josh Charney",
    "Type": "News"
    "VideoThumbnail": null,
    },
    {
    "Title": "Investors on the Move as Rates Rise",
    "ResourceId": "607677",
    "PublicationTime": "2013-08-16 06:00:00 -0500",
    "AuthorName": "Christine Benz",
    "Type": "Video",
    "SubType": "MSTARVDVD",
    "VideoThumbnail":
    "http://im.mstar.com/im/videocenter/130814_flows_largethumb.jpg",
    }
    ],
    "0P0000PZCB": [],
    "0P00002PYR":    [
    {
    "Title": "FPA New Income",
    "ResourceId": "578826",
    "PublicationTime": "2012-12-26 00:00:00 -0600",
    "AuthorName": "Sarah Bush",
    "Type": "Research",
    "Href": null,
    "VideoThumbnail": null,
    },
    {
    "Title": "FPA New Income, Inc. 2nd Quarter 2013 Conference Call",
    "ResourceId": "BWIPREM_20130719005736",
    "PublicationTime": "2013-07-19 12:32:00 -0500",
    "Source": "Business Wire",
    "Type": "News",
    "SubType": "BWIPREMBWIPREM",
    "VideoThumbnail": null,
    "AuthorThumbnail": null
    }

    ]
    }

I need to print the following nodes from the response ex:"0P0000G5ZQ", "0P0000PZCB", "0P00002PYR" etc and then within each of these nodes I need to assert if the "Title" node is present. The response nodes:"0P0000G5ZQ", "0P0000PZCB", "0P00002PYR" keep on changing depending on the service I am running so I need to always obtain it from the response and not hardcode it. I have to do this in a script assertion in SoapUI.

I have tried to use Json Slurper to get the nodes:"0P0000G5ZQ", "0P0000PZCB", "0P00002PYR" etc as follows:

import com.eviware.soapui.support.XmlHolder
import org.apache.commons.lang.StringUtils
import groovy.json.JsonSlurper 

def holder = new XmlHolder(messageExchange.responseContentAsXml)
def response = messageExchange.response.responseContent
log.info response

def slurper = new JsonSlurper()
def json = slurper.parseText(response)
log.info json.each

but this returns the following INFO:null.

Can anyone provide me a sample code to do this? Thanks.

Upvotes: 1

Views: 4729

Answers (1)

dmahapatro
dmahapatro

Reputation: 50245

def slurp = new groovy.json.JsonSlurper().parseText(jsonStr)
slurp.each{key, val ->
    val.each{
        assert "Title" in it.keySet()
    }
}

where jsonStr represents the above json response in string. (enclosed in '''yourJson''')

Upvotes: 2

Related Questions