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?

score 83 · Answer 1 · edited Jan 06 '17 at 16:24

83

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 06 '17 at 16:24

schnatterer

7,525
7
61
80

answered Jul 14 '11 at 08:24

Dónal

185,044
174
569
824

3

This is for Groovy 1.8 and later only. – mindthief May 17 '12 at 22:14
8

Awesome! You may need to `import groovy.json.JsonSlurper` – The Unknown Dev Feb 05 '15 at 14:53
1

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! – Nicolas Raoul Sep 28 '16 at 11:19

score 61 · Accepted Answer · answered Jul 14 '11 at 03:31

61

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 '11 at 03:31

Burt Beckwith

75,342
5
143
156

1

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 Jun 04 '15 at 09:34
1

Got it - [from here](http://stackoverflow.com/a/2673558/2067690). It's `import grails.converters.JSON` – HumanInDisguise Jun 04 '15 at 09:39

Andrii Abramov · Answer 3 · 2021-08-03T20:30:08.980

7

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 03 '21 at 20:30

answered Mar 11 '17 at 15:07

Andrii Abramov

10,019
9
74
96

score 0 · Answer 4 · edited Mar 02 '21 at 16:12

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 02 '21 at 16:12

Andrii Abramov

10,019
9
74
96

answered Aug 18 '20 at 09:02

Sunil Kanaujia

1

score 0 · Answer 5 · answered Mar 02 '21 at 08:29

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

how to parse json using groovy

5 Answers5

Linked