Parsing Nested JSON in java without know structure of JSON?

Question

I am Trying to parse nested JSON, But i don't know the format of JSON...I want all the Keys and Values of JSON.

Example:

{
    "txnSpecificData1": "11",
    "txnSpecificData2": "21",
    "merchantData": {
        "merchantSpecificData1": "111",
        "merchantSpecificData2": "222",
        "merchantSpecificData3": {
            "data1": "1",
            "data2": "2"
        }
    }
}

Now I want all Keys and their Values...I tried JSONParser but it is not giving all keys. Please some one guide me to do this.

I need value based on key.. Let's say If i give key as "merchantSpecificData2" it should return me value.

O/P should be MAP with all Key and Values:

OutPut Map : : : {txnSpecificData1=11, txnSpecificData1=22, merchantSpecificData1=111, merchantSpecificData2=222,data1=1,data2=2}

Your question is ill-formed. What result should asking for "a" from {"a": 1, "b": {"a": 2}} give? — Eric
– Eric, Commented Oct 29, 2015 at 6:28
@Eric I want all key with values store in a map. txnSpecificData1:11 txnSpecificData2:21 merchantSpecificData1:111 merchantSpecificData2:222 like wise — user2888996
– user2888996, Commented Oct 29, 2015 at 6:30
You've just ignored my question and restated yours even less clearly. Notice how in the "map" I gave above, the key "a" appears twice. Which value do you want, and why? — Eric
– Eric, Commented Oct 29, 2015 at 6:46
@Eric..In my case there is no duplicate keys..why are you asking me this? — user2888996
– user2888996, Commented Oct 29, 2015 at 6:50
You specifically said that you "don't know the keys". So how do you know they're all unique? — Eric
– Eric, Commented Oct 29, 2015 at 13:34

boardtc · Accepted Answer · 2019-01-17 16:45:31Z

3

A iterative solution to store all keys and respective value into a map. Note, all exception scenarios are not handled.

public static void main(String[] args) throws Exception{
    JSONObject jo = new JSONObject(your_json_String_here);
    Map<String, String> map = new HashMap<String, String>(); 
    new Test().iterateJson(jo, map);
    System.out.println(map);
}
public void iterateJson(JSONObject jo, Map map) {
    for(Object o : jo.keySet()){
        if(jo.get(o.toString()) instanceof JSONObject) 
            iterateJson(jo.getJSONObject(o.toString()), map);
        else
            map.put(o.toString(), jo.get(o.toString()));
    }
}

edited Jan 17, 2019 at 16:45

boardtc

1,5581 gold badge18 silver badges26 bronze badges

answered Oct 29, 2015 at 6:22

Naveen Ramawat

1,4431 gold badge15 silver badges27 bronze badges

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

3 Comments

user2888996 Over a year ago

It's not suitable for my case

Naveen Ramawat Over a year ago

This example prints all the values of available keys in your JSON string as you requested. It is expected a bit modification if your requirement are little different, Please elaborate more where you stuck

Naveen Ramawat Over a year ago

I modified the code a bit, now it is populating a Map of all key value pairs and you can get value of any key using that map

Ankur Singhal · Accepted Answer · 2015-10-29 06:53:24Z

2

Please refer this

Sample Code

public static void main(String[] args) throws JSONException {
        String json = "{\"txnSpecificData1\": \"11\",\"txnSpecificData2\": \"21\",\"merchantData\": {\"merchantSpecificData1\": \"111\",\"merchantSpecificData2\": \"222\",\"merchantSpecificData3\": {\"data1\": \"1\",\"data2\": \"2\"}}}";

        JSONObject jsonObject = new JSONObject(json);
        JSONObject merchantData = (JSONObject) jsonObject.get("merchantData");
        System.out.println(merchantData.get("merchantSpecificData2"));
    }

Output

Jar

Maven

Refer hew for more details.

edited Oct 29, 2015 at 6:53

answered Oct 29, 2015 at 6:06

Ankur Singhal

26.1k17 gold badges92 silver badges129 bronze badges

8 Comments

user2888996 Over a year ago

...I have done this..but as i said i don't know the format..I mean instead of "merchantData" it can be anything

Ankur Singhal Over a year ago

@user2888996 maybe using Regex looks weird but might solve

user2888996 Over a year ago

Okay...lF i use this only..then how can i find value for key "txnSpecificData1"

Ankur Singhal Over a year ago

jsonObject.get("txnSpecificData1");, also you can always iterate recursivley the jsonObject, check for instance if it is array or object

user2888996 Over a year ago

@ ankur-singhal...I want all the keys to be stored in Map with their respective values..and i don't know any of the key also level of nesting

|

Dev Blanked · Accepted Answer · 2015-10-29 06:01:55Z

0

You can use http://json-lib.sourceforge.net/apidocs/net/sf/json/package-summary.html for parsing the JSON. Using JSONSerializer you can get a JSONObject parsing your string. Then methods available in JSONObject will give you all keys and values. Value can be simple like String/Long/Boolean or complex like another JSONObject/JSONArray.

answered Oct 29, 2015 at 6:01

Dev Blanked

8,9153 gold badges28 silver badges33 bronze badges

1 Comment

user2888996 Over a year ago

..This library i am not using also i am not getting how can i implement.

user2888996 · Accepted Answer · 2015-10-30 04:21:30Z

0

Here is the solution..

private static HashMap print(final JsonNode node) throws IOException {
        HashMap map = new HashMap();
        Iterator<Map.Entry<String, JsonNode>> fieldsIterator = node.getFields();

        while (fieldsIterator.hasNext()) {
            Map.Entry<String, JsonNode> field = fieldsIterator.next();
            final String key = field.getKey();

            final JsonNode value = field.getValue();
            if (value.isContainerNode()) {
                print(value);
            } else {
                map.put(key, value);
            }
        }
        return map;
    }

answered Oct 30, 2015 at 4:21

user2888996

4278 silver badges21 bronze badges

Collectives™ on Stack Overflow

Parsing Nested JSON in java without know structure of JSON?

4 Answers 4

3 Comments

8 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

8 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related