json multiple json data parsing in java

Question

I have a json input like this

[ {
    "Company":"BEG",
    "Account":"1001",
    "Deptid":"",
    "Location":"",
    "Transaction Date":"2014-07-15",
    "Description":"Invoice",
    "Debit":0.0,
    "Credit":13.46,
    "Invoice Nbr":"1682"
    },
    {
    "Company":"BEG2",
    "Account":"1002",
    "Deptid":"23",
    "Location":"NY",
    "Transaction Date":"2014-07-15",
    "Description":"Invoice",
    "Debit":0.0,
    "Credit":13.45,
    "Invoice Nbr":"1682432"
    },
    ....
    ....
    },
    {
    "Company":"BEG99",
    "Account":"1099",
    "Deptid":"",
    "Location":"",
    "Transaction Date":"2014-07-15",
    "Description":"Invoice",
    "Debit":0.0,
    "Credit":13.46,
    "Invoice Nbr":"168243299"
    }]

I am using json simple jar to parse the json. my code is:

public String appendData(String str) throws IOException, ParseException{
        System.out.println("========Inside appendData======"+str);
        JSONParser jsonParser = new JSONParser();
        JSONObject jsonObject = (JSONObject) jsonParser.parse(new StringReader(str));
        double debit = (double) Double.parseDouble(jsonObject.get("Debit").toString());
}

Above code works fine, If i send single lock of data and without [ and ] bracket. Above json is a valid json according to JSONLint

Question:

1) How do I parse above json having multiple data?

I need to extract all input data from json and update to my file with manipulation. i.e. my business requirement — AKB
– AKB, Commented Aug 15, 2014 at 19:43
Go to json.org and learn the JSON syntax -- it only takes 5-10 minutes. The outer [] indicates a JSON "array", yet you're apparently trying to parse it as an "object". If you understood the syntax you wouldn't make this error. — Hot Licks
– Hot Licks, Commented Aug 15, 2014 at 20:34

user3487063 · Accepted Answer · 2014-08-15 19:37:55Z

2

Something like below for your scenario, if you want to use json-simple:

JSONParser jsonParser = new JSONParser();
                Object obj =  jsonParser.parse(new StringReader(str));
            if (obj instanceof JSONObject) {
                JSONObject jo = (JSONObject) obj;
                 System.out.println(jo.get("Debit").toString());
            } else {
                JSONArray ja = (JSONArray) obj;
                for(int i=0;i<ja.size();i++){
                    JSONObject   jsonObject = (JSONObject)ja.get(i);
                    System.out.println(jsonObject.get("Debit").toString());
                }
            }

answered Aug 15, 2014 at 19:37

user3487063

3,7121 gold badge19 silver badges25 bronze badges

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

Comments

Miguel Prz · Accepted Answer · 2014-08-15 19:23:03Z

1

The GSON library is very easy for this kind of tasks

answered Aug 15, 2014 at 19:23

Miguel Prz

13.8k32 silver badges42 bronze badges

Comments

Charles Smartt · Accepted Answer · 2014-08-15 19:21:41Z

0

https://code.google.com/p/json-simple/wiki/DecodingExamples

You'll see that to process your array instead of JSONObject you need to us JSONArray. The link has a full example.

I typically use Jackson for my JSON parsing, it is pretty good.

answered Aug 15, 2014 at 19:21

Charles Smartt

3492 silver badges8 bronze badges

Collectives™ on Stack Overflow

json multiple json data parsing in java

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related