How to parse this nested JSON array in android

Question

I have to parse the below nested Json array's data into my application. I am confused how to get the values out of it.

  {
            "prodCat_list": [
                {
                    "prods": [
                        {
                            "cat_id": "9",
                            "position": "1",
                            "sku": "wwww345"

                        },
                        {
                            "cat_id": "9",
                            "position": "2",
                            "sku": "coof23"

                        },
                        {
                            "cat_id": "9",
                            "position": "3",
                            "sku": "dde45"

                        },
                        {
                            "cat_id": "9",
                            "position": "4",
                            "sku": "5555"

                        }
             ]
                },
{
                    "prods": [
                        {
                            "cat_id": "9",
                            "position": "1",
                            "sku": "wwww345"

                        },
                        {
                            "cat_id": "9",
                            "position": "2",
                            "sku": "coof23"

                        },
                        {
                            "cat_id": "9",
                            "position": "3",
                            "sku": "dde45"

                        },
                        {
                            "cat_id": "9",
                            "position": "4",
                            "sku": "5555"

                        }
             ]
                },
            ]
        }

Can anyone please guide me how to get the inside values from that.

I have tried this

JSONParser parser = new JSONParser();
        JSONObject items = parser.getJSONFromUrl(productInfoUrl);
        try {
            JSONArray itemsDetails = items.getJSONArray("prodCat_list");
            if(itemsDetails.length()>0){

                for (int i = 0; i < itemsDetails.length(); i++) {
                    JSONArray productWithCategories = itemsDetails.getJSONArray(i);
                    JSONObject object = productWithCategories.getJSONObject(i);

                    Product productInfo = new Product( object.getString("sku"), object.getInt("cat_id"), object.getInt("position"));
                    ProductDbHandler productDbHandler = new ProductDbHandler(context);
                    productDbHandler.addProducts(productInfo);
                }
            }
            else 
                System.out.println("No product to add");
        } catch (JSONException e) {
            e.printStackTrace();
        }
    }

Btw, that json is not valid. The last item in the inner object ends with a comma: "sku": "5555", — Enrichman
– Enrichman, Commented Jul 16, 2013 at 9:45
@Enrichman i have added the tried code. Also i have removed that comma — Helping_Hand
– Helping_Hand, Commented Jul 16, 2013 at 9:47
Still not valid. You have a comma at the end of your object. use jsonlint.com to check your json. And check in the logcat for any errors. — Enrichman
– Enrichman, Commented Jul 16, 2013 at 10:17
There is another comma(,) (3rd line from last) in your json, remove it and try again.. — Vamshi
– Vamshi, Commented Jul 16, 2013 at 10:18

hardartcore · Accepted Answer · 2013-07-16 09:52:13Z

24

Here is how I think your JSON Parser should look like (there can be some typo mistakes,I didn't test this code on editor : )) :

JSONObject mainObj = new JSONOBject(myString);
if(mainObj != null){
    JSONArray list = mainObj.getJSONArray("prodCat_list");
    if(list != null){
        for(int i = 0; i < list.length();i++){
            JSONObject elem = list.getJSONObject(i);
            if(elem != null){
                JSONArray prods = elem.getJSONArray("prods");
                if(prods != null){
                    for(int j = 0; j < prods.length();j++){
                        JSONObject innerElem = prods.getJSONObject(j);
                        if(innerElem != null){
                            int cat_id = innerELem.getInt("cat_id");
                            int pos = innerElem.getInt("position");
                            String sku = innerElem.getString("sku");
                        }
                    }
                }
            }
        }
    }
}

answered Jul 16, 2013 at 9:52

hardartcore

17.1k12 gold badges78 silver badges102 bronze badges

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

5 Comments

Mahesh Over a year ago

stackoverflow.com/questions/21525993/…

mike20132013 Over a year ago

Nice one.. it helped me too ..thanks for the answer .. :)..I had a question though..is this the best way to parse nested arrays/objects ?

hardartcore Over a year ago

It depends a lot of your JSON string, but in my opinion, this is the best solution which I know.

Neoqq Over a year ago

You can automatically parse it with Gson library from Google. See my answer below stackoverflow.com/a/37585670/3387187

pa1pal Over a year ago

@hardartcore I did the same. As per the question I have 10 prods array and each having five elements. I am checking a condition on the innerElem and setText to a inflated View according to that. The problem is that all the 10 arrays are running at the same time and 10 views inflated on the screen. I want them to run one by one.

Abhishek Shukla · Accepted Answer · 2013-07-16 09:45:17Z

1

You can use the GSon library. It parses the json into various objects that you can access. A dummy Code is here:

` GSon gSon  = new GSon();
  ProdCatList prodCatList = gSon.fromJson(---inputStreamReader of your JSon data---,ProdCatList.class);`

answered Jul 16, 2013 at 9:45

Abhishek Shukla

1,2428 silver badges11 bronze badges

Comments

intrepidkarthi · Accepted Answer · 2013-07-16 09:47:19Z

1

Try this!

//Write your own implementation of json parser
JSONParser jParser = new JSONParser();
JSONArray prod_cat = new JSONArray();
JSONArray products = new JSONArray();
JSONObject json = jParser.getJSONFromUrl("your source");
prod_cat = json.getJSONArray("prodCat_list");
for (int i = 0; i < prod_cat.length(); i++) {
        JSONObject object = prod_cat.getJSONObject(i);
        products = object.getJSONArray("products");
}

answered Jul 16, 2013 at 9:47

intrepidkarthi

3,1028 gold badges44 silver badges75 bronze badges

Comments

srain · Accepted Answer · 2013-07-16 12:31:04Z

1

try to use

org.json.simple.JSONValue

code:

import org.json.simple.JSONValue;
String content = "{...}";
JSONValue.parse(content);

edited Jul 16, 2013 at 12:31

answered Jul 16, 2013 at 9:45

srain

9,1426 gold badges32 silver badges43 bronze badges

Comments

divya chikkam · Accepted Answer · 2015-05-05 10:33:58Z

0

JSONObject reader = new JSONObject(results);

            JSONArray VendorProductsList = reader.getJSONArray("VendorProductsList");
            for (int i = 0; i < VendorProductsList.length(); i++) {
                ebay=new Ebay();
                JSONObject elem = VendorProductsList.getJSONObject(i);
                JSONArray Products = elem.getJSONArray("Products");

                for (int j = 0; j < Products.length(); j++) {
                    JSONObject innerElem = Products.getJSONObject(j);
                   //JSONObject ProductName=Products.getJSONObject(j);
                  ebay.setProductName(innerElem.getString("ProductName"));
                    gallery_array.add(ebay);

answered May 5, 2015 at 10:33

divya chikkam

1

Comments

Neoqq · Accepted Answer · 2016-06-02 08:11:58Z

Simply you can automatically parse it with Gson:

JSONParser parser = new JSONParser();
JSONObject items = parser.getJSONFromUrl(productInfoUrl);
Gson gson = new GsonBuilder().create();
ProdCatResponse prodCatResponse = gson.fromJson(items.toString(), ProdCatResponse.class);

But actually you can parse the JSON response in string form. You don't need to get the response in JSONObject and use toString().

JSONParser parser = new JSONParser();
String items = parser.getFromUrl(productInfoUrl);
Gson gson = new GsonBuilder().create();
ProdCatResponse prodCatResponse = gson.fromJson(items, ProdCatResponse.class);

More info about Gson: https://guides.codepath.com/android/Leveraging-the-Gson-Library

This is the model class sample, you can generate it with http://www.jsonschema2pojo.org.

ProdCatResponse.java

public class ProdCatResponse {

    private List <Prod> prods = new ArrayList <Prod> ();

    public List <Prod> getProds() {
        return prods;
    }

    public void setProds(List < Prod > prods) {
        this.prods = prods;
    }

}

Prod.java

public class Prod {

    private String catId;
    private String position;
    private String sku;

    public String getCatId() {
        return catId;
    }

    public void setCatId(String catId) {
        this.catId = catId;
    }

    public String getPosition() {
        return position;
    }

    public void setPosition(String position) {
        this.position = position;
    }

    public String getSku() {
        return sku;
    }

    public void setSku(String sku) {
        this.sku = sku;
    }

}

Collectives™ on Stack Overflow

How to parse this nested JSON array in android

6 Answers 6

5 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

5 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related