how to parse json using groovy

Question

I want to parse JSON data which is coming in like:

{
   "212315952136472": {
      "id": "212315952136472",
      "name": "Ready",
      "picture": "http://profile.ak.fbcdn.net/hprofile-ak-snc4/195762_212315952136472_4343686_s.jpg",
      "link": "http://www.hityashit.com/movie/ready",
      "likes": 5,
      "category": "Movie",
      "description": "Check out the reviews of Ready on  http://www.hityashit.com/movie/ready"
   }
}

The code I am using is:

JSONElement userJson = JSON.parse(jsonResponse)
userJson.data.each {
    Urls = it.link
}

But I am not able to get anything assigned to Urls. Any suggestions?

schnatterer · Accepted Answer · 2017-01-06 16:24:25Z

86

Have you tried using JsonSlurper?

Example usage:

def slurper = new JsonSlurper()
def result = slurper.parseText('{"person":{"name":"Guillaume","age":33,"pets":["dog","cat"]}}')

assert result.person.name == "Guillaume"
assert result.person.age == 33
assert result.person.pets.size() == 2
assert result.person.pets[0] == "dog"
assert result.person.pets[1] == "cat"

edited Jan 6, 2017 at 16:24

schnatterer

7,9797 gold badges67 silver badges85 bronze badges

answered Jul 14, 2011 at 8:24

Dónal

188k177 gold badges590 silver badges851 bronze badges

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

4 Comments

mindthief Over a year ago

This is for Groovy 1.8 and later only.

The Unknown Dev Over a year ago

Awesome! You may need to import groovy.json.JsonSlurper

Nicolas Raoul Over a year ago

This does not answer the question, as the question has a dynamic id (like 212315952136472) as part of the path. Could you please update your example to use the question's data? Thanks!

M. Justin Over a year ago

@NicolasRaoul

def result = slurper.parseText(jsonResponse); assert result['212315952136472'].link == 'http://www.example.com/movie/ready'

Burt Beckwith · Accepted Answer · 2011-07-14 03:31:23Z

64

That response is a Map, with a single element with key '212315952136472'. There's no 'data' key in the Map. If you want to loop through all entries, use something like this:

JSONObject userJson = JSON.parse(jsonResponse)
userJson.each { id, data -> println data.link }

If you know it's a single-element Map then you can directly access the link:

def data = userJson.values().iterator().next()
String link = data.link

And if you knew the id (e.g. if you used it to make the request) then you can access the value more concisely:

String id = '212315952136472'
...
String link = userJson[id].link

answered Jul 14, 2011 at 3:31

Burt Beckwith

75.8k5 gold badges145 silver badges157 bronze badges

2 Comments

HumanInDisguise Over a year ago

Burt, what am I supposed to import to make the first example code block work? I figured out i need import org.codehaus.groovy.grails.web.json.JSONObject but then it fails stating "No such property: JSON"

HumanInDisguise Over a year ago

Got it - from here. It's import grails.converters.JSON

Andrii Abramov · Accepted Answer · 2021-08-03 20:30:08Z

6

You can convert JSON to the desired type in Groovy using as operator:

import groovy.json.JsonSlurper

String json = '''
{
  "name": "John",  
  "age": 20
}
'''

def person = new JsonSlurper().parseText(json) as Person 

with(person) {
    assert name == 'John'
    assert age == 20
}

edited Aug 3, 2021 at 20:30

answered Mar 11, 2017 at 15:07

Andrii Abramov

10.9k12 gold badges81 silver badges107 bronze badges

1 Comment

Nikolai Ehrhardt Nov 25 at 6:25

will this work, with fields in class, that are also classes?

brainelectronics · Accepted Answer · 2021-03-02 08:29:20Z

The thing with this unique number is a bit tricky.

If you know this value, easy

stage('Test Groovy JSON parsing') {
    steps {
        script {
            def userJson = readJSON file: 'myJsonFile.json'

            def keyList = userJson['212315952136472'].keySet()
            echo "${keyList}"   // ['id', 'name', 'picture', 'link', 'likes', 'category', 'description']
            
            echo "${userJson['212315952136472'].name}"  // Ready
            echo "${userJson['212315952136472'].link}"  // http://www.hityashit.com/movie/ready
        }
    }
}

If you don't know this number, you could walk through the JSON

userJson.each { key, value ->
    echo "Walked through key $key and value $value"
}

check also the documentation at Jenkins Read JSON from File

Andrii Abramov · Accepted Answer · 2021-03-02 16:12:52Z

0

def jsonFile = new File('File Path');
JsonSlurper jsonSlurper = new JsonSlurper();

def parseJson = jsonSlurper.parse(jsonFile)
String json = JsonOutput.toJson(parseJson)

def prettyJson = JsonOutput.prettyPrint(json)
println(prettyJson)

edited Mar 2, 2021 at 16:12

Andrii Abramov

10.9k12 gold badges81 silver badges107 bronze badges

answered Aug 18, 2020 at 9:02

Sunil Kanaujia

1

Collectives™ on Stack Overflow

how to parse json using groovy

5 Answers 5

4 Comments

2 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related