Paring json string in java with javax.json

Question

My ajax passed a json array that looks like this:

 {"formData":[{"cusID":"2"},{"empID":"1"}],"invoice":578416969}

I am trying to get the data using javax.json library.

JSONObject jsonObj = new JSONObject(jasonString);

I am able to grab the value of invoice:

Integer invoiceNum = (Integer) jsonObj.get("invoice");

But I am unable to grab the value of cusID and empID, by doing the following:

Integer cusId = Integer.parseInt((String) jsonObj.get("cusID"));
Integer empId = Integer.parseInt((String) jsonObj.get("empID"));

Error message:org.json.JSONException: JSONObject["cusID"] not found.

What did I do wrong? I am open to suggestions,if you have a better way of handling this json data, I am willing to use it.

Whats the error message or result?? FYI, I am suspecting that this may have to do with how your casting your variables... — ryekayo
– ryekayo, Commented Oct 12, 2015 at 18:49

alcfeoh · Accepted Answer · 2015-10-12 19:05:54Z

1

cusID is actually an attribute of the first object in the array formData:

jsonObj.getJsonArray("formData").getJsonObject(0).get("cusID");

should do the trick.

edited Oct 12, 2015 at 19:05

answered Oct 12, 2015 at 18:52

alcfeoh

2,2871 gold badge20 silver badges35 bronze badges

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

4 Comments

AnatolyS Over a year ago

formData is a array of objects

alcfeoh Over a year ago

Just edited my answer. Did not test it but this should work.

OPK Over a year ago

worked now. Thanks. You are missing a ; in your code btw.

alcfeoh Over a year ago

Just added it to make it perfect. Thanks.

AnatolyS · Accepted Answer · 2015-10-12 18:52:42Z

0

First you have to get formData as an array, after that get the first element and get custId, after that get the second element and get empID.

answered Oct 12, 2015 at 18:52

AnatolyS

4,33720 silver badges29 bronze badges

Comments

suhyunjeon · Accepted Answer · 2015-10-14 15:42:41Z

0

You can using Gson() library. (com.google.gson.Gson) It makes you simple.

 JsonArray formData = jsonElement.getAsJsonObject().get("formData").getAsJsonArray();
 Integer cusId = formData.get(0).getAsJsonObject().get("cusID").getAsInt();
 Integer empId = formData.get(1).getAsJsonObject().get("empID").getAsInt();

answered Oct 14, 2015 at 15:42

suhyunjeon

1611 silver badge9 bronze badges

Collectives™ on Stack Overflow

Paring json string in java with javax.json

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related