org.json.simple.JSONArray cannot be cast to org.json.simple.JSONObject

Question

I'm trying to parse below json file:

{"units":[{"id":42,               
   "title":"Hello World",          
    "position":1,
    "v_id":9,
    "sites":[[{"id":316,
      "article":42,
      "clip":133904
        }],
       {"length":5}]

   }, ..]}

This is what I have tried:

Object obj = null;
JSONParser parser = new JSONParser();
Object unitsObj = parser.parse(new FileReader("file.json");
JSONObject unitsJson = (JSONObject) unitsObj;

JSONArray units = (JSONArray) unitsJson.get("units");
Iterator<String> unitsIterator = units.iterator();
while(unitsIterator.hasNext()){         
    Object uJson = unitsIterator.next();
    JSONObject uj = (JSONObject) uJson;
    obj =  parser.parse(uj.get("sites").toString());
    JSONArray jsonSites = (JSONArray)  obj;

    for(int i=0;i<jsonSites.size();i++){
     JSONObject site = (JSONObject)jsonSites.get(i); // Exception happens here.
     System.out.println(site.get("article");
    }
}

The code is not working when I try to parse the inner json array, so I get:

Exception in thread "main" java.lang.ClassCastException: org.json.simple.JSONArray cannot be cast to org.json.simple.JSONObject

The exception is pointing to this line:

JSONObject site = (JSONObject)jsonSites.get(i);

Any help? tnx.

In sites there seems to be an array in an array, note the double square brackets. — qqilihq
– qqilihq, Commented Aug 26, 2013 at 8:50

Danon · Accepted Answer · 2021-03-10 11:42:18Z

32

I've found a working code:

JSONParser parser = new JSONParser();
Object obj  = parser.parse(content);
JSONArray array = new JSONArray();
array.add(obj);

If you don't need the array (like the author), you can simply use

JSONParser parser = new JSONParser();
Object obj  = parser.parse(content);

edited Mar 10, 2021 at 11:42

answered Oct 31, 2014 at 14:57

Danon

3,00731 silver badges42 bronze badges

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

1 Comment

AvinashK Over a year ago

Although this is exact opposite to what the question asked, it solved my problem i.e. convert JSONObject to JSONArray...So +1 from my side

Sabir Khan · Accepted Answer · 2019-02-19 06:18:45Z

8

The first element of the sites array is an array, as you can see indenting the JSON:

{"units":[{"id":42,               
    ...
    "sites":
    [
      [
        {
          "id":316,
          "article":42,
          "clip":133904
        }
      ],
      {"length":5}
    ]
    ...
}

Therefore you need to treat its value accordingly; probably you could do something like:

JSONObject site = (JSONObject)(((JSONArray)jsonSites.get(i)).get(0));

edited Feb 19, 2019 at 6:18

Sabir Khan

10.2k7 gold badges51 silver badges105 bronze badges

answered Aug 26, 2013 at 8:50

cyberz

9241 gold badge8 silver badges17 bronze badges

2 Comments

tokhi Over a year ago

I still get the same exception: JSONObject cannot be cast to JSONArray

Nora Over a year ago

Thank you, your answer helps me to know the problem then I solved it by creating a nested loop while j<site.length() to get site.get(j).toString()

Onur A. · Accepted Answer · 2013-08-26 08:53:31Z

2

JSONObject site=jsonSites.getJSONObject(i) should work out

answered Aug 26, 2013 at 8:53

Onur A.

3,0273 gold badges24 silver badges37 bronze badges

3 Comments

tokhi Over a year ago

there is no getJSONObject method for JSONArray

tokhi Over a year ago

I'm using this: org.json.simple.JSON

Onur A. Over a year ago

so why don't try the one i introduced?

arn-arn · Accepted Answer · 2016-02-24 20:37:08Z

2

this worked:

System.out.println("resultList.toString() " + resultList);
            org.json.JSONObject obj = new JSONObject(resultList);
            org.json.JSONArray jsonArray = obj.getJSONArray(someField);

            for(int i=0;i<jsonArray.length();i++){
                System.out.println("array is " + jsonArray.get(i));

            }

answered Feb 24, 2016 at 20:37

arn-arn

1,3971 gold badge21 silver badges32 bronze badges

Comments

Ars · Accepted Answer · 2015-09-18 12:11:26Z

1

JSONObject obj=(JSONObject)JSONValue.parse(content); 
JSONArray arr=(JSONArray)obj.get("units"); 
System.out.println(arr.get(1));  //this will print {"id":42,...sities ..}

@cyberz is right but explain it reverse

edited Sep 18, 2015 at 12:11

answered Sep 18, 2015 at 3:24

Ars

1065 bronze badges

Comments

LoveToCode · Accepted Answer · 2016-05-31 06:51:18Z

1

You can first read the whole content of file into a String.

FileInputStream fileInputStream = null;
String data="";
StringBuffer stringBuffer = new StringBuffer("");
try{
    fileInputStream=new FileInputStream(filename);
    int i;
    while((i=fileInputStream.read())!=-1)
    {
        stringBuffer.append((char)i);
    }
    data = stringBuffer.toString();
}
catch(Exception e){
        LoggerUtil.printStackTrace(e);
}
finally{
    if(fileInputStream!=null){  
        fileInputStream.close();
    }
}

Now You will have the whole content into String ( data variable ).

JSONParser parser = new JSONParser();
org.json.simple.JSONArray jsonArray= (org.json.simple.JSONArray) parser.parse(data);

After that you can use jsonArray as you want.

edited May 31, 2016 at 6:51

answered Mar 31, 2016 at 11:54

LoveToCode

3062 silver badges18 bronze badges

Comments

Imran · Accepted Answer · 2019-08-08 16:54:01Z

1

If you want to re-filter the json data you can use following method. Given example is getting all document data from couchdb.

{
    Gson gson = new Gson();
    String resultJson = restTemplate.getForObject(url+"_all_docs?include_docs=true", String.class);
    JSONObject object =  (JSONObject) new JSONParser().parse(resultJson);
    JSONArray rowdata = (JSONArray) object.get("rows");   
    List<Object>list=new ArrayList<Object>();   
    for(int i=0;i<rowdata.size();i++) {
        JSONObject index = (JSONObject) rowdata.get(i);
        JSONObject data = (JSONObject) index.get("doc");
        list.add(data);      
    }
    // convert your list to json
    String devicelist = gson.toJson(list);
    return devicelist;
}

edited Aug 8, 2019 at 16:54

Imran

6,3354 gold badges28 silver badges57 bronze badges

answered Aug 8, 2019 at 12:28

prasad

111 bronze badge

Comments

rimonmostafiz · Accepted Answer · 2019-08-22 08:05:19Z

1

JSONObject site = (JSONObject)jsonSites.get(i); // Exception happens here.

The return type of jsonSites.get(i) is JSONArray not JSONObject. Because sites have two '[', two means there are two arrays here.

edited Aug 22, 2019 at 8:05

rimonmostafiz

1,4611 gold badge17 silver badges33 bronze badges

answered Aug 22, 2019 at 7:14

Stacie

111 bronze badge

Comments

Krishna D · Accepted Answer · 2014-12-10 10:22:48Z

0

use your jsonsimpleobject direclty like below

JSONObject unitsObj = parser.parse(new FileReader("file.json");

answered Dec 10, 2014 at 10:22

Krishna D

231 silver badge6 bronze badges

Comments

double-beep · Accepted Answer · 2019-04-02 13:49:42Z

0

JSONObject baseReq
LinkedHashMap insert = (LinkedHashMap) baseReq.get("insert");
LinkedHashMap delete = (LinkedHashMap) baseReq.get("delete");

edited Apr 2, 2019 at 13:49

double-beep

5,67019 gold badges43 silver badges50 bronze badges

answered Apr 2, 2019 at 13:48

ritesh yadav

11 bronze badge

2 Comments

Zibellino Over a year ago

Explain it please!

user3937548 Over a year ago

I have same code, that convert to LinkedHashMap., but suddenly its stop to work and return by get("...") scala.some.Map. do you know what can be the problem?

Collectives™ on Stack Overflow

org.json.simple.JSONArray cannot be cast to org.json.simple.JSONObject

10 Answers 10

1 Comment

2 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

1 Comment

2 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related