JSONObject["sum"] not found while parsing JSON in Java

Question

I have a problem. I wrote the JSON parsing code, but it gives me an error. I don't understand what the problem is. String result is JSON.I need to output the amount value from sum. Returns an error: "JSONObject["sum"] not found."

JSONObject json = new JSONObject(result);
JSONObject bpi = json.getJSONObject("sum");
String uuu = bpi.getString ("amount");
System.out.println(uuu);

{
    "data": [
        {
            "txnId": 20071336083,
            "personId": 1,
            "date": "2020-10-21T20:10:56+03:00",
            "errorCode": 0,
            "error": null,
            "status": "SUCCESS",
            "type": "IN",
            "statusText": "Success",
            "trmTxnId": "403300256",
            "account": "xxx",
            "sum": {
                "amount": 10,
                "currency": 643
            }
        }
    ]
}

first retrieve the data node (array) and then try retrieving the sum node on data[0] — Balaji Krishnan
– Balaji Krishnan, Commented Oct 22, 2020 at 17:47

gtiwari333 · Accepted Answer · 2020-10-22 17:54:05Z

2

Your sum element is deep below the structure. But your code is expecting it to be under the root object. Your code is assuming the json is in structure:

{
    "sum": {
        "amount": 10,
        "currency": 643    
    }
}

But your json data is in following structure:

{ //ROOT JSONObject
  "data": [ // JSONArray
    { //JSONObject - first element of array index 0
      "account": "xxx",
      "sum": { //JSONObject
        "amount": 10,  //value
        "currency": 643
      }
    }
  ]
}

So, you need to read it properly:

        JSONObject json = new JSONObject(result);
        JSONArray data = json.getJSONArray("data");
        JSONObject el = (JSONObject) data.get(0);
        JSONObject sum = el.getJSONObject("sum");
        String uuu = sum.getString("amount");
        System.out.println(uuu);

answered Oct 22, 2020 at 17:54

gtiwari333

25.3k15 gold badges78 silver badges106 bronze badges

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

7 Comments

MakarMS Over a year ago

Hi! Thank you for the very detailed explanation. But your code returned: JSONObject["amount"] not a string.

gtiwari333 Over a year ago

can you post your JSON data that you are using?

gtiwari333 Over a year ago

The one that you posted on the question is not valid json

MakarMS Over a year ago

Oh, I was stupid. The amount key has an int value, not a string. Thank you very much for your help. Hello from Russia.

gtiwari333 Over a year ago

Great. Can you post a valid json to the question for the future reference? Hello from Nepal

|

Collectives™ on Stack Overflow

JSONObject["sum"] not found while parsing JSON in Java

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related