Parsing Json in Groovy

Question

I have a following json string:

[ { id: '123', name: 'bla bla', type: 'Source', isLeaf: true },
  { id: '3425', name: 'test test', type: 'Reference', isLeaf: false },
  { id: '12678', name: 'tags', type: 'Source', isLeaf: false },
]

I am trying to parse this using JsonSlurper but getting error:

groovy.json.JsonException: Lexing failed on line: 1, column: 5, while reading 'i', no possible valid JSON value or punctuation could be recognized.

How do I parse it and access the id:'3425'?

tim_yates · Accepted Answer · 2013-04-25 13:45:28Z

6

Your Json is invalid, you need to use double quote to delimit strings and you also need to put quotes around the keys in your Json like so:

[ { "id": "123", "name": "bla bla", "type": "Source", "isLeaf": true },
  { "id": "3425", "name": "test test", "type": "Reference", "isLeaf": false },
  { "id": "12678", "name": "tags", "type": "Source", "isLeaf": false },
]

You can then do:

def ids = new groovy.json.JsonSlurper().parseText( json ).id
assert ids[ 1 ] == '3425'

answered Apr 25, 2013 at 13:45

tim_yates

172k29 gold badges359 silver badges354 bronze badges

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

3 Comments

asp_NewBee Over a year ago

first I thought so, but jsonviewer.stack.hu tells you that the Json is a valid one. Anyway thank you for the response.

tim_yates Over a year ago

I suspect jsonviewer.stack.hu is wrong. jsonlint.com en.wikipedia.org/wiki/JSON#Data_types.2C_syntax_and_example

Nathan Hughes Over a year ago

@asp_NewBee: if the jsonviewer app says it is valid then it's wrong. the spec (json.org) is pretty clear.

Collectives™ on Stack Overflow

Parsing Json in Groovy

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related