Add JSON object into existing JSON array using java

Question

Here this is my JSON which I have as a string "additionalThirdParty"

{
    "header": null,
    "object": {
        "ASSETS": {
            "productDetails": [{
                "productId": "PT_230",
                "productThirdPartyDetails": [{
                    "thirdPartyId": "TH12",
                    "Location": "France",
                    "addtionalInfo": []
                }]
            }]
        }
    }
}

Now my requirement is to add an extra JSON object inside "productThirdPartyDetails" array.

The new JSON object will be

{
    "thirdPartyId": "TH11",
    "Location": "Belgium",
    "addtionalInfo": []
}

So the final object should be like

{
    "header": null,
    "object": {
        "ASSETS": {
            "productDetails": [{
                "productId": "PT_230",
                "productThirdPartyDetails": [{
                        "thirdPartyId": "TH12",
                        "Location": "France",
                        "addtionalInfo": []
                    },
                    {
                        "thirdPartyId": "TH11",
                        "Location": "Belgium",
                        "addtionalInfo": []
                    }
                ]
            }]
        }
    }
}

I'm trying to add as follows.

converting this string to JSON as

    JSONObject obj = new JSONObject(additionalThirdParty);

    Iterator<?> keys = obj.keys();

    while (keys.hasNext()) {
        JSONObject assetsObj = obj.getJSONObject("ASSETS");
        Iterator<?> assetKeys = assetsObj.keys();
        while (assetKeys.hasNext()) {
            JSONArray productDetails = assetsObj.getJSONArray("productDetails");
            logger.info("productDetails=" + productDetails);
        }
    }

It throws me that org.json.JSONException: JSONObject["ASSETS"] not found.

Any ideas on how to add a new object into that array

Assets object lies inside object so in order to get Assets, you have to first get object JSONObject. — Nishesh Pratap Singh
– Nishesh Pratap Singh, Commented Nov 21, 2017 at 12:18
the productDetails array have only one element? or you want to add the new element for the productId "productId": "PT_230" — ajc
– ajc, Commented Nov 21, 2017 at 13:06
@ajc, product will be one, but it will have multiple third parties. — Yakhoob
– Yakhoob, Commented Nov 21, 2017 at 15:03
Ok, so you just need to focus on understanding how to iterate over a JSONObject. Understand difference between JSONObject, JSONArray and how to read keys and values. Nishesh's answer covers it. — ajc
– ajc, Commented Nov 21, 2017 at 15:52
@ajc, definetely I will try Nishesh solution and update tomorrow morning as Im at home now. — Yakhoob
– Yakhoob, Commented Nov 21, 2017 at 16:04

Nishesh Pratap Singh · Accepted Answer · 2017-11-21 12:27:53Z

1

In order to achieve what you want, you have to properly reach out to productThirdPartyDetails as shown below, then you have to identify the way of getting JSONObject that needs to be added, I have hardcoded that part it's better to get that object through a method.

JSONObject obj = new JSONObject(additionalThirdParty);


        JSONObject objtobeadded =  new JSONObject();
        objtobeadded.put("thirdPartyId", "TH11");
        objtobeadded.put("Location", "Belgium");
        objtobeadded.put("addtionalInfo", new JSONArray());

        JSONObject assetsObj = obj.getJSONObject("object").getJSONObject("ASSETS");

        JSONArray prodDetailsArr = assetsObj.getJSONArray("productDetails");

        for(int i=0;i<prodDetailsArr.length();i++){            
            JSONArray arr = prodDetailsArr.getJSONObject(i).getJSONArray("productThirdPartyDetails");
            arr.put(objtobeadded);
        }
        System.out.println(obj.toString());

answered Nov 21, 2017 at 12:27

Nishesh Pratap Singh

2,1912 gold badges15 silver badges21 bronze badges

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

1 Comment

Yakhoob Over a year ago

Nishesh, let me check and get back to u

Shakhawat Hossain · Accepted Answer · 2017-11-21 13:19:26Z

1

JSONObject assetsObj = obj.getJSONObject("ASSETS"); here the ASSETS is in under object,

So you should write obj.getJSONObject("object").getJSONObject("ASSETS"); to get the ASSETS object.

answered Nov 21, 2017 at 13:19

Shakhawat Hossain

7285 silver badges12 bronze badges

Collectives™ on Stack Overflow

Add JSON object into existing JSON array using java

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related