Difficult to identify json data

Question

I have json data as mentioned below.

{  
"data":[  
  {  
     "Products":{  
        "id":"86",
        "pname":"mi4",
        "pcat":"9",
        "subcat":"8",
        "seccat":"0",
        "oproduct":"1",
        "pdetails":"Good phone",
        "pprice":"10000",
        "pdiscount":"10",
        "qty":"1",
        "qtytype":"GM",
        "dcharge":"40",
        "pimage":null,
        "sname":"Easydeal",
        "sid":"1100",
        "size":"",
        "pincode":""
     }
  }
 ]
}

I can identify array as getJSONArray("datas"). But I want to get pname and sname values.

Possible duplicate of [How to parse JSON in Java](http://stackoverflow.com/questions/2591098/how-to-parse-json-in-java) — rohitanand, Feb 09 '17 at 08:29
Possible duplicate of [How to parse JSON in Android](http://stackoverflow.com/questions/9605913/how-to-parse-json-in-android) — OneCricketeer, Feb 09 '17 at 08:29
Note: `{ data: [ { Products: {}` is pointless. Your JSON should really only be `[ {"id": 86, "pname": "m14", ... }, ... ]` That is, unless you have more data there. — OneCricketeer, Feb 09 '17 at 08:41

Nayan Srivastava · Accepted Answer · 2017-02-09T08:40:27.423

2

Just reach the object

JSONObject resp=new JSONObject("response");
JSONArray data=resp.getJSONArray("data");

now if you want to get object at a particular index(say '0')

JSONObject objAt0=data.getJSONObject(0);
JSONObject products=objAt0.getJSONObject("products");
String pName=products.getString("pname");

you can similarly traverse the array

for(int i=0;i<data.lenght();i++){
    JSONObject objAtI=data.getJSONObject(i);
    JSONObject products=objAtI.getJSONObject("products");
    String pName=products.getString("pname");
}

edited Feb 09 '17 at 08:40

answered Feb 09 '17 at 08:28

Nayan Srivastava

3,655
3
27
49

Close, but you still need to get `"Products"` – OneCricketeer Feb 09 '17 at 08:33

score 1 · Answer 2 · edited Feb 09 '17 at 08:34

1

To get the to the key "Products" you should do:

JSONObject productsObject = YOUROBJECTNAME.getJSONArray("data").getJSONObject(0).getJSONObject("Products");

Then to get the values in productsObject you should do:

productsObject.getString("id");
productsObject.getString("pdetails");

And so on.

edited Feb 09 '17 at 08:34

OneCricketeer

179,855
19
132
245

answered Feb 09 '17 at 08:28

MichaelStoddart

5,571
4
27
49

tahsinRupam · Answer 3 · 2017-02-09T08:41:58.273

1

Try out the following code:

JSONObject object = new JSONObject(result);
JSONArray array = object.getJSONArray("data");
JSONObject object1 = array.getJSONObject(0);
JSONObject products = object1.getJSONObject("Products");
int id = object1.getInt("id");
String pname = object1.getString("pname");

edited Feb 09 '17 at 08:41

answered Feb 09 '17 at 08:30

tahsinRupam

6,325
1
18
34

score 0 · Answer 4 · answered Feb 09 '17 at 08:41

This is how you get pname and sname:

        JSONObject jsonObject = new JSONObject();
        JSONArray jsonArray;
        try {
            jsonArray = jsonObject.getJSONArray("data");
            for(int counter = 0; counter <jsonArray.length(); counter++){
                JSONObject jsonObject1 = jsonArray.getJSONObject(counter);
                JSONObject products = jsonObject1.getJSONObject("Products");
                String pname = products.getString("pname");
                String sname = products.getString("sname");
            }
        } catch (JSONException e) {
            e.printStackTrace();
        }

PS: Poor JSON structure :)

Difficult to identify json data

4 Answers4