Using Groovy JsonSlurper to parse an array of objects

Question

Groovy here. I am parsing a file that contains a list of all the countries:

{
    "countries": [
      {
        "id": "1",
        "sortname": "AF",
        "name": "Afghanistan"
      },
      {
         "id": "2",
         "sortname": "AL",
         "name": "Albania"
      },
      ...
    ]
}

I am trying to read each country into a parseable object that I can then process in my code:

String countriesJson = new File(classLoader.getResource('countries.json').getFile()).text
def countries = new JsonSlurper().parseText(countriesJson)

countries.each { country ->
    String sortname = country.sortname
    String name = country.name

    // do something with all this info and then move on to the next country
}

When I run this code I get MissingPropertyExceptions:

Exception in thread "main" groovy.lang.MissingPropertyException: No such property: sortname for class: java.util.LinkedHashMap$Entry
        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.unwrap(ScriptBytecodeAdapter.java:53)
        at org.codehaus.groovy.runtime.callsite.GetEffectivePojoPropertySite.getProperty(GetEffectivePojoPropertySite.java:66)
        at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callGetProperty(AbstractCallSite.java:296)
        ...rest of stacktrace omitted for brevity

What can I do to fix this so that I can parse the array JSON objects into my sortname and name variables?

tim_yates · Accepted Answer · 2018-03-23 08:02:26Z

2

Assuming you have your json wrapped in { ... } so it's valid (unlike in the question), you need to get the countries object first.

so:

countries.countries.each { country ->
    String sortname = country.sortname
    String name = country.name

    // do something with all this info and then move on to the next country
}

Maybe rename the variable countries to something less confusing?

answered Mar 23, 2018 at 8:02

tim_yates

172k29 gold badges359 silver badges354 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

smeeb Over a year ago

Sorry that was a copy-n-paste bug on my end, please see the updated JSON. Does that change your answer at all?

tim_yates Over a year ago

Cool :-) No, you just need to grab the countries field from the parsed json. Having the variable called countries threw me for a moment... Maybe consider changing the variable name to parsed or something?

Collectives™ on Stack Overflow

Using Groovy JsonSlurper to parse an array of objects

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related