How to parse JSON array from file?

Question

I have JSON from file.

{  
  "from_excel":[  
    {  
      "solution":"Fisrt",
      "num":"1"
    },
    {  
      "solution":"Second",
      "num":"2"
    },
    {  
      "solution":"third",
      "num":"3"
    },
    {  
      "solution":"fourth",
      "num":"4"
    },
    {  
      "solution":"fifth",
      "num":"5"
    }
  ]
}

and want to parse list of Solution and Num.

Used lib org.json.simple.*

Try this one

        Object obj = parser.parse(new FileReader("E:\\json.txt"));

        JSONObject jsonObject = (JSONObject) obj;

        out.println(jsonObject.get("from_excel"));

        JSONObject obj_new = (JSONObject) jsonObject.get("from_excel");

        JSONArray solution = (JSONArray) obj_new.get("solution");

        Iterator iterator = solution.iterator();
        while (iterator.hasNext()) {
            out.println(iterator.next());
        }

What am I doing wrong?

If try to write

JSONObject solutions = (JSONArray) jsonObject.get("from_excel");

If try to write

JSONArray array = obj.getJSONArray("from_excel");

get error

Kasun Siyambalapitiya · Accepted Answer · 2016-12-20 10:48:00Z

3

working solution

JSONParser parser = new JSONParser();
JSONObject jsonObject;
try {

    jsonObject = (JSONObject) parser.parse(new FileReader("E:\\json.txt"));

    out.println("<br>"+jsonObject);


    JSONArray from_excel = (JSONArray)jsonObject.get("from_excel");
    // for row output 1
    for(Object o: from_excel){
        out.println("<br>"+o);
    }
    // for row output 2
    Iterator iterator = from_excel.iterator();
    while (iterator.hasNext()) {
        out.println("<br>"+iterator.next());
    }
    // for item output 3
    for (int i = 0; i < from_excel.size(); i++) {

        JSONObject jsonObjectRow = (JSONObject) from_excel.get(i);
        String num = (String) jsonObjectRow.get("num");
        String solution = (String) jsonObjectRow.get("solution");
        out.println("<br>num="+num+"; solution="+solution);
    }
} catch (Exception e) {
    out.println("Error: "+e);
}

edited Dec 20, 2016 at 10:48

Kasun Siyambalapitiya

4,4739 gold badges43 silver badges60 bronze badges

answered Sep 25, 2016 at 21:02

Nikolay Baranenko

1,7038 gold badges37 silver badges65 bronze badges

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

Comments

Neeraj · Accepted Answer · 2016-09-26 11:06:07Z

2

There is no "solution" array in the JSON. "from_excel" is the array. So your code should look like this :

Object obj = parser.parse(new FileReader("E:\\json.txt"));

    JSONObject jsonObject = (JSONObject) obj;

    out.println(jsonObject.get("from_excel"));

    JSONArray solutions = (JSONArray) jsonObject.get("from_excel");

    Iterator iterator = solutions.iterator();
    while (iterator.hasNext()) {
        out.println(iterator.next());
    }

edited Sep 26, 2016 at 11:06

answered Sep 25, 2016 at 17:14

Neeraj

2,5972 gold badges28 silver badges42 bronze badges

1 Comment

Nikolay Baranenko Over a year ago

Its solution must working on lib "org.json.simple.*"? I try and get error with Incompatible types

SpringLearner · Accepted Answer · 2016-09-25 17:12:25Z

0

from_excel is JSON array not an object. So you should achieve it is array.

JSONObject jsonObject = (JSONObject) obj;
JSONArray array = obj.getJSONArray("from_excel");

then iterate the array and get each jsonobject. Something like the below

for(int i = 0 ; i < array.length() ; i++){
    array.getJSONObject(i).getString("solution");
}

answered Sep 25, 2016 at 17:12

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

1 Comment

Nikolay Baranenko Over a year ago

Its solution must working on lib "org.json.simple.*"? I try and get error about Cannot resolve method (add picture with error in body of question)

Collectives™ on Stack Overflow

How to parse JSON array from file?

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related