Parse a JSON object with the value as JSON string array

Question

I am trying to parse a JSON string which is of the following format

{"edgeNodeRegistrationStatus": ["{\"CONFIRMED\":\"TRUE\"}"]}

I have written a code to parse it.

import groovy.json.JsonOutput
import groovy.json.JsonSlurper

def jsonSlurper = new JsonSlurper()

def object = jsonSlurper.parseText('{"edgeNodeRegistrationStatus": ["{\"CONFIRMED\":\"TRUE\"}"]}')

println(object["edgeNodeRegistrationStatus"][0])

I expect the code to print {"CONFIRMED":"TRUE"}. But its throwing an error

Caught: groovy.json.JsonException: expecting a ',' or a ']',  but got 
the current character of  'C' with an int value of 67  on array index of 1 


The current character read is 'C' with an int value of 67
expecting a ',' or a ']',  but got 
the current character of  'C' with an int value of 67  on array index of 1 

line number 1
index number 35
{"edgeNodeRegistrationStatus": ["{"CONFIRMED":"TRUE"}"]}
...................................^
groovy.json.JsonException: expecting a ',' or a ']',  but got 
the current character of  'C' with an int value of 67  on array index of 1 


The current character read is 'C' with an int value of 67
expecting a ',' or a ']',  but got 
the current character of  'C' with an int value of 67  on array index of 1 

line number 1
index number 35
{"edgeNodeRegistrationStatus": ["{"CONFIRMED":"TRUE"}"]}
...................................^
    at jdoodle.run(jdoodle.groovy:4)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Command exited with non-zero status 1

Assuming you really want JSON inside JSON, you are better off using the already imported JsonOutput to get problems like that out of the way quickly: JsonOutput.toJson([edgeNodeRegistrationStatus: [JsonOutput.toJson([CONFIRMED: true])]]) — cfrick
– cfrick, Commented May 28, 2019 at 14:15
@cfrick I am getting the JSON object in the format {"edgeNodeRegistrationStatus": ["{\"CONFIRMED\":\"TRUE\"}"]}. I need to get the status of the CONFIRMED attribute. How can I achieve that? — Rana
– Rana, Commented May 28, 2019 at 14:22

cfrick · Accepted Answer · 2019-05-28 14:23:02Z

2

Using \" inside a ''-String will give you just " inside the string itself (same as in a ""-String). But you want to quote the \" for the JSON (not groovy). So you need to use \\" instead.

Unless you really want to have that string for testing, you are better off just generating the JSON you expect there in your code. So you don't have to battle that. E.g.

JsonOutput.toJson([edgeNodeRegistrationStatus: [JsonOutput.toJson([CONFIRMED: "TRUE"])]])

answered May 28, 2019 at 14:23

cfrick

37.3k7 gold badges61 silver badges76 bronze badges

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

Comments

tim_yates · Accepted Answer · 2019-05-28 18:30:42Z

1

Or, you can use a different String delimiter, thusly:

def text = $/{"edgeNodeRegistrationStatus": ["{\"CONFIRMED\":\"TRUE\"}"]}/$

def object = jsonSlurper.parseText(text)

println object.edgeNodeRegistrationStatus[0]

answered May 28, 2019 at 18:30

tim_yates

172k29 gold badges359 silver badges354 bronze badges

Collectives™ on Stack Overflow

Parse a JSON object with the value as JSON string array

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related