read json data in java

Question

I'm in a situation where I have to read the json data and insert it into Sqlite table. But the json data in this format :

{
    "result": "success",
    "data": {
        "userId": "873",
        "volume": "0.5",
        "schoolId": "0",
        "schoolName": "",
        "preferredLanguageId": "1",
        "fname": "robin",
        "lname": "singh",
        "email": "[email protected]",
        "password": "password1111",
        "isParent": "0",
        "countryId": "254",
        "stateId": "143",
        "state": "",
        "city": "san diego",
        "coins": "0",
        "zip": "",
        "players": []
    }
}

JSONObject json = new JSONObject(jsonString);
String uname=json.getString("fname");

But I'm not able to get the first name in the string uname.

Try JSONArray list = (JSONArray) jsonObject.get("data"); to get collection of all properties nested within the data property. — rebeliagamer
– rebeliagamer, Commented Jul 31, 2013 at 13:15

jabclab · Accepted Answer · 2013-07-31 13:10:22Z

5

String uname=json.getString("fname");

Is not working because the fname property is nested within the data property. Therefore you need to do something like the following:

String uname = json.getJSONObject("data").getString("fname");

answered Jul 31, 2013 at 13:10

jabclab

15.1k5 gold badges58 silver badges51 bronze badges

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

Comments

Mike Thomsen · Accepted Answer · 2013-07-31 13:11:56Z

1

String uname = json.getJSONObject("data").getString("fname");

answered Jul 31, 2013 at 13:11

Mike Thomsen

37.7k11 gold badges63 silver badges86 bronze badges

Comments

Narendra Pathai · Accepted Answer · 2013-07-31 13:11:35Z

0

You have to first get the data property and then get the fname property. fname is inside the data property.

answered Jul 31, 2013 at 13:11

Narendra Pathai

42.1k18 gold badges88 silver badges122 bronze badges

Comments

Zycro · Accepted Answer · 2013-07-31 13:12:23Z

0

You need to read "data" as a JSON object and then "fname" as a string.

There are many JSON viewers online, this is one of my favorite:

http://jsonviewer.stack.hu/

String uname = json.getJSONObject("data").getString("fname");

answered Jul 31, 2013 at 13:12

Zycro

819 bronze badges

Comments

j2ko · Accepted Answer · 2017-03-03 13:20:18Z

0

First you have to get data object from your JSON string. Here is an example:

JSONObject json = new JSONObject(jsonString);
JSONObject data = json.getJSONObject("data");
String uname = data.getString("fname");

Take a look at complete example here. Also here is a web based tool for creating/editing JSON.

edited Mar 3, 2017 at 13:20

j2ko

2,5671 gold badge20 silver badges30 bronze badges

answered Mar 3, 2017 at 12:45

lalitbhagtani

4595 silver badges6 bronze badges

1 Comment

lalitbhagtani Over a year ago

Thanks for your suggestion :)

Collectives™ on Stack Overflow

read json data in java

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related