how to iterate through json objects in java

Question

I am trying to iterate through my json file and get required details here is my json

{
"000": {
    "component": "c",
    "determinantType": "dt",
    "determinant": "d",
    "header": "h",
    "determinantvalue": "null"
},
"001": {
    "component": "t",
    "determinantType": "i",
    "determinant":"ld",
    "header": "D",
    "determinantvalue": "null"
},
"002": {
    "component": "x",
    "determinantType": "id",
    "determinant": "pld",
    "header": "P",
    "determinantValue": "null"
}}

my java code

FileReader file = new FileReader("test.json");
Object obj = parser.parse(file);
System.out.println(obj);
JSONObject jsonObject = (JSONObject) obj;            
JSONArray msg = (JSONArray) jsonObject.get(key);          
Iterator<String> iterator = msg.iterator();         
while (iterator.hasNext()) {
System.out.println(iterator.next());            
String component = (String) jsonObject.get("component");           
System.out.println("component: " + component);

As you can see in the code I am importing my json file and trying to get next elements and printing components out of it , I should also print header,determinant and determinant value as well Thank you

Are you getting an error? What isn't working about this code? — Erik
– Erik, Commented Dec 31, 2014 at 11:02
You don't have any json arrays as far as I can see - and we don't know what key is. — Jon Skeet
– Jon Skeet, Commented Dec 31, 2014 at 11:03
JSONArray msg = (JSONArray) jsonObject.get(key); "Here i am trying to get all the keys i.e.,'000','001','002'" so that i can use it to iterate , but i am not able to get the keys — user3724559
– user3724559, Commented Dec 31, 2014 at 11:05
@user3724559 There is no JSONArray in your file. Only one object which have multiple objects with multiple properties. — Alexis C.
– Alexis C., Commented Dec 31, 2014 at 11:05
@user3724559: I'm saying you shouldn't use JSONArray because there aren't any arrays in your JSON. That's not the same as saying you can't iterate to get all the elements - see my answer. — Jon Skeet
– Jon Skeet, Commented Dec 31, 2014 at 11:09

Jon Skeet · Accepted Answer · 2014-12-31 12:04:02Z

8

You don't have an array - you have properties with names of "000" etc. An array would look like this:

"array": [ {
    "foo": "bar1",
    "baz": "qux1"
  }, {
    "foo": "bar2",
    "baz": "qux2"
  }
]

Note the [ ... ] - that's what indicates a JSON array.

You can iterate through the properties of a JSONObject using keys():

// Unfortunately keys() just returns a raw Iterator...
Iterator keys = jsonObject.keys();
while (keys.hasNext()) {
    Object key = keys.next();
    JSONObject value = jsonObject.getJSONObject((String) key);
    String component = value.getString("component");
    System.out.println(component);
}

Or:

@SuppressWarnings("unchecked")
Iterator<String> keys = (Iterator<String>) jsonObject.keys();
while (keys.hasNext()) {
    String key = keys.next();
    JSONObject value = jsonObject.getJSONObject(key);
    String component = value.getString("component");
    System.out.println(component);
}

edited Dec 31, 2014 at 12:04

answered Dec 31, 2014 at 11:08

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

6 Comments

user3724559 Over a year ago

Thank you , i will make my json file an json array and try iterating

Jon Skeet Over a year ago

@user3724559: Well if you can change the format of the file, that would be ideal. But if not, my answer should show how you can iterate anyway...

user3724559 Over a year ago

I used keyset and iterated but it is unordered , is there anyway I can sort it ? As you can see my JSON i have given it as 000,001,002 so that i can order my json

Jon Skeet Over a year ago

@user3724559: Well you could create a List<String> from the keys and then call Collections.sort before fetching them...

user3724559 Over a year ago

We can not convert set to list

|

Dhaval · Accepted Answer · 2014-12-31 11:07:50Z

0

try this...

FileReader file = new FileReader("test.json");
Object obj = parser.parse(file);
System.out.println(obj);
JSONObject jsonObject = (JSONObject) obj;            

Iterator<String> iterator = jsonObject .iterator();  

for(Iterator iterator = jsonObject.keySet().iterator(); iterator.hasNext();) {
    String key = (String) iterator.next();
    System.out.println(jsonObject.get(key));
}

answered Dec 31, 2014 at 11:07

Dhaval

2,3791 gold badge15 silver badges16 bronze badges

3 Comments

Jon Skeet Over a year ago

There are no JSON arrays in the JSON - so the cast will fail.

user3724559 Over a year ago

@dhaval I have tried this it wont solve the problem , it gets only the key and value will be null

Jon Skeet Over a year ago

Now you're trying to call iterator() on JSONObject, which doesn't have such a method...

stealthjong · Accepted Answer · 2014-12-31 11:09:49Z

0

There's not a JSONArray, only a few JSONObjects. Iterate the keys of the main JSONObject with JSONObject.keys().

public static final String COMPONENT = "component";
public static final String DT = "determinantType";
public static final String D = "determinant": "d";
public static final String HEADER = "header";
public static final String DV = "determinantvalue";

JSONObject jso = getItFromSomewhere();
for (Object key : jso.keys()) {
    JSONObject subset = jso.getJSONObject(key);
    String d = subset.getString(D);
    String header = subset.getString(HEADER);
    String dv = subset.getString(DV);
    System.out.println(key + " " + header + " " + d + " " + dv);
}

answered Dec 31, 2014 at 11:09

stealthjong

11.1k14 gold badges50 silver badges86 bronze badges

Collectives™ on Stack Overflow

how to iterate through json objects in java

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related