Forum Discussion

donaldngo's avatar
donaldngo
Occasional Contributor
15 years ago
Solved

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
    10 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}"
    }
nmrao's avatar
nmrao
Community Hero
10 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
10 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
    10 years ago

    Problem resolved.   Typo only.  Below is the working indexed code for future reference:

     

    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.info "totalResults: ${index}"
    log.info "Item resourceId: ${item.resourceId}"
    log.info "Item name: ${item.name}"
    log.info "Item resource type: ${item.resourceType}"
    log.info "Item status: ${item.status}"
    }

    • nmrao's avatar
      nmrao
      Community Hero
      10 years ago
      Good catch. Thank you for fixing typo for your self. By the fixed typo.