Retrieving null and non null string value from JSON String

Question

I have a JSON String that I am parsing, and I want to retrieve the value of the field "pr_num". I am getting this error:

JSONObject["pr_num"] is not a JSONArray.

My code is below:

JSONObject obj = new JSONObject(jsonString);

JSONArray data = obj.getJSONArray("pr_num");
JSONObject obj1= data.getJSONObject(0);
System.out.println("JSON CONTENTS ARE"+obj1.getString("pr_num"));

I want to get values for pr_num field which are 690052 and null.

jsonString is mention below

[{
    "executed_by": "vishnuc",
    "testplan_id": 17372,
    "pr_num": "690052"
},
{
    "executed_by": "kkavitha",
    "testplan_id": 17372,
    "pr_num": null

}]

What don't you understand about JSONObject["pr_num"] is not a JSONArray? — Sotirios Delimanolis
– Sotirios Delimanolis, Commented Jan 16, 2015 at 19:27
So how can i retrieve multiple instances of pr_num from this string? — Ammad
– Ammad, Commented Jan 16, 2015 at 19:30
JSONObject obj = new JSONObject(json); is incompatible with the given input. — njzk2
– njzk2, Commented Jan 16, 2015 at 19:32
json is String which is equal to [{ "executed_by": "vishnuc", "testplan_id": 17372, "pr_num": "690052", }, { "executed_by": "kkavitha", "testplan_id": 17372, "pr_num": null, }] ---- The same one i have already posted above. — Ammad
– Ammad, Commented Jan 16, 2015 at 19:36
Also, I checked my jsonString with jsonlint.com and it is valid string. — Ammad
– Ammad, Commented Jan 16, 2015 at 19:50

Ramindu De Silva · Accepted Answer · 2015-01-16 19:57:29Z

1

your jsonString is a json formatted array So first you have to get it to a json array (not to an json object)

JSONArray obj = new JSONArray(jsonString);

Now you can iterate through the obj array

for(int i=0;i<obj.length();i++){
 System.out.println("content one: " + obj.getJSONObject(i).getString("pr_num"));
}

Hope this helps.

answered Jan 16, 2015 at 19:57

Ramindu De Silva

31 gold badge4 silver badges15 bronze badges

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

2 Comments

Ammad Over a year ago

Thanks, I am able to retrieve value. one issue is if the value of field pr_num is null i am getting this error, JSONObject["pr_num"] not a string. if i put it under try, catch block it is working fine. Any other graceful way for handling null values for pr_num field?

Ramindu De Silva Over a year ago

You are welcome. Check it like the following link, stackoverflow.com/questions/18226288/…

Collectives™ on Stack Overflow

Retrieving null and non null string value from JSON String

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related