How to access JSONArray in a JSONObject using Java?

Question

I am having a problem in accessing the JSONArray ("pages") while reading a json file in Java using the json-simple-1.1.1.jar

My json file is around 32MB of size and the format is as below:

{
    "id": "0912898213",
    "pages": [
        {
            "pageUrl": "http://www.example0.com",
            "results": [
                {
                    "number": "1"
                },
                {
                    "number": "2"
                }
            ]
        },
        {
            "pageUrl": "http://www.example1.com",
            "results": [
                {
                    "number": "3"
                },
                {
                    "number": "4"
                }
            ]
        }
    ]
}

Whereas, the Java code to access this json file is as below:

JSONParser parser=new JSONParser();
JSONObject pagesObject = (JSONObject) parser.parse(new     FileReader(PATH_JSON_DataExtractor));        
JSONArray jsonArray= (JSONArray) pagesObject.get("pages");

for(int i=0; i<jsonArray.size(); i++){}

PROBLEM: The jsonArray is null all the time. Although, the json format is correct and it should work as expected! The above Java code works with the given sample json (also above) but the Java code doesn't work with the 32MB json file. The location of the json file is also correct and the format is also correct, but still I am getting this access issue!

Where I am going wrong to access the json file? I have been looking around on similar questions, and I have followed the exact instructions to access the json file. But I am just lost in getting it right, therefore, looking for suggestions to make this code work. Thank you very much for your time!

Meaby creating a class that represents the JSON object simplifies it to you. parse has a method that get the string and the Class of the object represented. Are you sure its opening the file? Meaby the problem is parsing the content and not opening the file. — aSoler
– aSoler, Commented Aug 24, 2015 at 11:24
No, it's not even reading the "id" element, it returns me null for that as well! — Amir
– Amir, Commented Aug 24, 2015 at 11:29
Ok. Why not try to read the file and store it in a String, normal way, and then parse? — aSoler
– aSoler, Commented Aug 24, 2015 at 11:30
Yes, I understand, but I've even multiplied the number of items in your JSON up to 35Mb, and it still works fine. I still suspect the file is not correctly located or updated. Have you tried to modify it (i.e. change id='000') and check if the pagesObject is aware of that modification? — Little Santi
– Little Santi, Commented Aug 24, 2015 at 12:08

sag · Accepted Answer · 2015-08-24 11:48:35Z

3

With the below code it is working perfect for me. Can you check whether the specified file location is correct? Also try reading id like pagesObject.get("id")

package json.simple;

import java.io.FileReader;

import org.json.simple.JSONArray;
import org.json.simple.JSONObject;
import org.json.simple.parser.JSONParser;

public class ReadJSON {
    public static void main(String[] args) throws Exception {
        JSONParser parser = new JSONParser();
        JSONObject pagesObject = (JSONObject) parser.parse(new FileReader("/home/user/tmp/test.json"));
        System.out.println(pagesObject.get("id"));
        System.out.println(pagesObject.get("pages").getClass().getName());
        JSONArray jsonArray= (JSONArray) pagesObject.get("pages");

        for(int i=0; i<jsonArray.size(); i++){
            System.out.println(jsonArray.get(i));
        }
    }
}

And here is the content of my test.json. Exactly same as yours

{
    "id": "0912898213",
    "pages": [
        {
            "pageUrl": "http://www.example0.com",
            "results": [
                {
                    "number": "1"
                },
                {
                    "number": "2"
                }
            ]
        },
        {
            "pageUrl": "http://www.example1.com",
            "results": [
                {
                    "number": "3"
                },
                {
                    "number": "4"
                }
            ]
        }
    ]
}

And here is my dependency in maven

<dependency>
    <groupId>com.googlecode.json-simple</groupId>
    <artifactId>json-simple</artifactId>
    <version>1.1.1</version>
</dependency>

answered Aug 24, 2015 at 11:48

sag

5,4718 gold badges60 silver badges95 bronze badges

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

5 Comments

Amir Over a year ago

Thanks for the answer. Yea I already checked this as well and it works with this test file, but with the 32MB file it is not working. I believe it is because of the size of the file! How do I deal with it?

Amir Over a year ago

And my project is a simple Java project, its not a Maven project!

sag Over a year ago

I just tried with 36 MB file and it worked with the same above sample code. Is there any java heap size issue?

Amir Over a year ago

I am not sure about that, it just gives me a NullPointerException at the for loop!

sag Over a year ago

Can you just double check your json. json-simple does not throw error for few json issues. Like, missing comma (,) between array values

Amir · Accepted Answer · 2015-08-24 12:54:45Z

1

Finally its working now, but I still do not know the actual cause of the problem. I partitioned the file into two separate json files, and executed the code on both of them and it worked. Now I just have to merge them and its done! Not a good solution but couldn't find another way!

answered Aug 24, 2015 at 12:54

Amir

6835 gold badges14 silver badges39 bronze badges

Comments

NaveenG · Accepted Answer · 2015-08-24 11:49:37Z

0

Use this:-

JSONArray jsonArray= (JSONArray) pagesObject.getJSONArray("pages");

edited Aug 24, 2015 at 11:49

answered Aug 24, 2015 at 11:47

NaveenG

2923 silver badges11 bronze badges

2 Comments

Amir Over a year ago

Yea I tried this already, I am getting this error "The method getJSONArray(String) is undefined for the type JSONObject"

thecoshman Over a year ago

@NaveenG just giving a line of code in this nature does not help with understanding of the problem. It is better to explain what is wrong in the question.

Collectives™ on Stack Overflow

How to access JSONArray in a JSONObject using Java?

3 Answers 3

5 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related