Forum Discussion

donaldngo's avatar
donaldngo
Occasional Contributor
14 years ago

How do i get JSON values from a response in Groovy

Hi I figured out how to grab NodeValue from XML responses in Groovy using: def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context ) def holder = groovyUtils.getXmlHolder ("create a ...
  • nmrao's avatar
    nmrao
    9 years ago

    Here is the later part of the script:

     

    It was not working because, items is a Json Array.

     

    json.items.eachWithIndex{ item, index ->
  log.info "Item #: ${index}"
  log.info "Item resource Id: ${tem.resourceId}"
  log.info "Item name : ${item.name}"
  log.info "Item resource type : ${item.resourceType}"
  log.info "Item status : ${item.status}"
    }
Holly_Greger's avatar
Holly_Greger
Contributor
12 years ago
This set up worked for me

****json

{
"odata.metadata": odataCallLocation/@Element",
"EmployeeNumber": "000000101",
"nameFirst": "Soap",
"nameLast": "UI",
}


****groovy script
import com.eviware.soapui.support.XmlHolder
import groovy.json.JsonSlurper

def response = context.expand( '${TestStepName#Response}' ).toString()
log.info(response)

def slurper = new JsonSlurper()
def json = slurper.parseText response

log.info(json.EmployeeNumber)
assert json.nameFirst == "Soap"
assert json.nameLast == "UI"
  • WillC's avatar
    WillC
    Occasional Contributor
    9 years ago

    This thread got me almost there:smileyvery-happy:

     

    I can parse the first level JSON correctly (thank you).  The second level JSON, however, I am not getting counted as I had hoped I would.  Any ideas on how to get the selected count to work? 

     

    I)  JSON File

     

    {
    "totalResults": 7,
    "limit": 100,
    "offset": 0,
    "items": [
    {
    "resourceId": "33100000",
    "status": "active",
    "parentResourceId": "33000001",
    "resourceType": "BK",
    "name": "North",
    "language": "en",
    "timeZoneDiff": -102,
    "timeZone": "Eastern",
    "dateFormat": "mm/dd/yy",
    "timeFormat": "24-hour",
    "inventories": {"links": [ {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33100000/inventories"
    }]},
    "users": {"links": [ {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33100000/users"
    }]},
    "workZones": {"links": [ {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33100000/workZones"
    }]},
    "workSkills": {"links": [ {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33100000/workSkills"
    }]},
    "links": [
    {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33100000"
    },
    {
    "rel": "describedby",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/metadata-catalog/resources"
    }
    ]
    },
    {
    "resourceId": "33200000",
    "status": "active",
    "parentResourceId": "33100000",
    "resourceType": "PR",
    "name": "BERTUZZI, Todd \t",
    "email": "33103@sunrise.demo",
    "phone": "555003310300",
    "language": "en",
    "timeZoneDiff": -102,
    "timeZone": "Eastern",
    "dateFormat": "mm/dd/yy",
    "timeFormat": "24-hour",
    "inventories": {"links": [ {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33200000/inventories"
    }]},
    "users": {"links": [ {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33200000/users"
    }]},
    "workZones": {"links": [ {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33200000/workZones"
    }]},
    "workSkills": {"links": [ {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33200000/workSkills"
    }]},
    "links": [
    {
    "rel": "canonical",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/resources/33200000"
    },
    {
    "rel": "describedby",
    "href": "http://demo-ofsc.etadirect.com/rest/ofscCore/v1/metadata-catalog/resources"
    }
    ]
    },
    {
    "resourceId": "33400000",
    "status": "active",
    "parentResourceId": "33100000",
    "resourceType": "PR",
    "name": "FIDDLER, Vernon",
    "email": "771002@sunrise.demo",
    "phone": "5555771002",
    "language": "en",
    "timeZoneDiff": -102,
    "timeZone": "Easte

     

    II)  Working Groovy Script to "get" totalResults

     

    import com.eviware.soapui.support.XmlHolder
    import groovy.json.*

     

    //define the location of the JSON file
    def response = context.expand( '${get_descendants#Response}' ).toString()

    //define "json" which will be the name of my variable
    def json = new JsonSlurper().parseText (response)

     

    //grab that json file result I want
    log.info json.totalResults

     

    III)  Non-Working Groovy Script to "get" resourceId

    package json

    import com.eviware.soapui.support.XmlHolder
    import groovy.json.*

    //define the location of the JSON file
    def response = context.expand( '${get_descendants#Response}' ).toString()
    //log.info(response)

    //define "json" which will be the name of my variable
    def json = new JsonSlurper().parseText (response)

    //grab that json file result I want
    log.info json[1].items.resourceId
    log.info json[1].items.name
    log.info json[1].items.resourceType
    log.info json[1].items.status

     

     

     

     

    Anyone see what is wrong here with the count?

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

      Here is the later part of the script:

       

      It was not working because, items is a Json Array.

       

      json.items.eachWithIndex{ item, index ->
  log.info "Item #: ${index}"
  log.info "Item resource Id: ${tem.resourceId}"
  log.info "Item name : ${item.name}"
  log.info "Item resource type : ${item.resourceType}"
  log.info "Item status : ${item.status}"
      }
      • WillC's avatar
        WillC
        Occasional Contributor
        9 years ago

        Thank you Rao.  That makes perfect sense.  This withEachIndex is exactly what I was looking for.   I suspect this will help others as well.  I am still throwing an error after many editing attempts.  I've done some searching...not sure what is missing with a find or subsequent step.  Thank you, again.

         

         

        I)  Current JSON Parser

         

        package json

        import com.eviware.soapui.support.XmlHolder
        import groovy.json.*


        //define the location of the JSON file
        def response = context.expand( '${get_descendants#Response}' ).toString()
        //log.info(response)

        //define "json" which will be the name of my variable
        def json = new JsonSlurper().parseText (response)

         

        json.items.eachWithIndex
        {
        item, index ->
        log.inf "totalResults: ${index}"
        log.inf "Item resourceId: ${item.resourceId}"
        log.info "Item name: ${item.name}"
        log.info "Item resource type: ${item.resourceType}"
        log.info "Item status: ${item.status}"
        }

         

         

         

        II)  Error Message thrown (if I comment out totalResults line same error occurs for subsequent lines):

        groovy.lang.MissingMethodException:

        No signature of method: org.apache.log4j.Logger.inf() is applicable for argument types: (org.codehaus.groovy.runtime.GStringImpl) values: [totalResults: 0]

        Possible solutions: info(java.lang.Object), find(), any(), info(java.lang.Object, java.lang.Throwable), is(java.lang.Object), find(groovy.lang.Closure)

    • WillC's avatar
      WillC
      Occasional Contributor
      9 years ago