How to parsing multi dimensional json data array in android studio.?

Question

i have problem to parse my json data,

this is my json data :

{"data":
[
    {"ean": "222222","itemname": "","location": "001010202,001010201","po":[
            {"ponumber": 1,"qty": 22
            },
            {"ponumber": 2,"qty": 33
            }
        ]
    },
    {
        "ean": "11112222",
        "itemname": "เหงือก",
        "location": "001010601",
        "po": [
            {
                "ponumber": 1,
                "qty": 7
            }
        ]
    },
    {
        "ean": "22223333",
        "itemname": "Crystal Water",
        "location": "001010410,001010401",
        "po": [
            {
                "ponumber": 3,
                "qty": 13
            }
        ]
    }
]}

i want to show the output like : thank you

this is my java code to parsing json data and show to listview :

 void parseJsonData(String jsonString) throws JSONException {
    String data = "";
    String data2 = null;
    List<String> list = new ArrayList<>();
    JSONObject json = new JSONObject(jsonString);
    JSONArray arrayData = json.getJSONArray("data");
   for (int i = 0; i < arrayData.length(); i++) {
        JSONObject jsonDataArray = arrayData.getJSONObject(i);
        String ean = jsonDataArray.getString("ean");
        String itemname = jsonDataArray.getString("itemname");
        String locations = jsonDataArray.getString("location");
        data =  "\n EAN                 = " + ean +
                "\n Item Name     = " + itemname +"\n";
        JSONArray arrayPO = jsonDataArray.getJSONArray("po");
        for (int j = 0; j < arrayPO.length(); j++ ) {
            JSONObject jsonPO = arrayPO.getJSONObject(j);
            ponumb = jsonPO.getString("ponumber");
            qty = jsonPO.getString("qty");
            //int numb = i + 1;
            data2 = "\n      PO Number   : " + ponumb +
                    "\n      Quantity        : " + qty + "\n";
            list.add(data+data2);
            System.err.println(data+data2);
        }
    }
    ArrayAdapter<String> LVarray;
    LVarray = new ArrayAdapter<String>(ListActivity.this, android.R.layout.simple_list_item_1, list);
    listView.setAdapter(LVarray);
}

this is screen shot the output:

your json content is not valid , you can check json validation in this linke : http://json.parser.online.fr/ — Amin Rahkan, Nov 06 '17 at 05:15

KeLiuyue · Accepted Answer · 2017-11-07T03:23:00.560

0

1.You can use StringBuilder to save the data2(po List).

2.In the inner for loop ,you can use append method to add it in it .

3.Get the length of StringBuilder .Then remove the saved data2.

4.Then you can save again .

Edit

public void parseJsonData(String jsonString) throws JSONException {
    String data = "";
    StringBuilder data2 = new StringBuilder();
    List<String> list = new ArrayList<>();
    JSONObject json = new JSONObject(jsonString);
    JSONArray arrayData = json.getJSONArray("data");
    for (int i = 0; i < arrayData.length(); i++) {
        JSONObject jsonDataArray = arrayData.getJSONObject(i);
        String ean = jsonDataArray.getString("ean");
        String itemname = jsonDataArray.getString("itemname");
        String locations = jsonDataArray.getString("location");
        data = "\n EAN                 = " + ean +
                "\n Item Name     = " + itemname + "\n";
        JSONArray arrayPO = jsonDataArray.getJSONArray("po");
        for (int j = 0; j < arrayPO.length(); j++) {
            JSONObject jsonPO = arrayPO.getJSONObject(j);
            ponumb = jsonPO.getString("ponumber");
            qty = jsonPO.getString("qty");
            //int numb = i + 1;
            data2.append("\n      PO Number       : " + ponumb +
                    "\n      Quantity        : " + qty + "\n");
            list.add(data + data2);
        }
        System.err.println(data + data2);
        int sb_length = data2.length();
        data2.delete(0, sb_length);
    }
}

edited Nov 07 '17 at 03:23

answered Nov 06 '17 at 05:21

KeLiuyue

8,149
4
25
42

thank you for answering @KeLiuyue ,but the output only show first ponumber and qty,.. – geri putra Nov 07 '17 at 01:29
Could you show your resonse ? – KeLiuyue Nov 07 '17 at 01:35
check my update post @KeLiuyue – geri putra Nov 07 '17 at 02:08
What do you want ? – KeLiuyue Nov 07 '17 at 02:13
i want second ponumber add into first ean, and only show one ean, – geri putra Nov 07 '17 at 02:20
ex : ean : 222222 | itemname : | ponumber :1 qty :22 | ponumber :2 qty :33 – geri putra Nov 07 '17 at 02:22
Change the `list.add(data+data2); System.err.println(data+data2);` outside of the inner for loop – KeLiuyue Nov 07 '17 at 02:22
ean :22223333 | itemname : crystal water | ponumber: 3 qty:13 – geri putra Nov 07 '17 at 02:23
oke, thank youy.. i want to try – geri putra Nov 07 '17 at 02:23
if list.add(data+data2); System.err.println(data+data2); outside of the inner for loop, the output only show last item of list @KeLiuyue – geri putra Nov 07 '17 at 02:38
You can check again .I use `StringBuilder` .It worked in my code .@geriputra – KeLiuyue Nov 07 '17 at 03:10
oke,thank you so much.. it work @KeyLiuyue .. – geri putra Nov 07 '17 at 03:22
oke, thank you @KeLiuyue – geri putra Nov 07 '17 at 03:34

score 0 · Answer 2 · answered Nov 06 '17 at 05:26

this also can help

try {
                        //Get root array
    JSONArray data_array = jsonObject.getJSONArray("data");

                        for (int i=0;i<data_array.length();i++){
                            JSONObject jsonObject1 = array.getJSONObject(i);
                            String ean = jsonObject1.optString("ean");
                            String itemname = jsonObject1.optString("itemname");
                            String location = jsonObject1.optString("location");


                            JSONArray child_Array = jsonObject1.getJSONArray("po");
                            for (int j=0;j<childArray.length();j++){
                                JSONObject childJosnObject = array.getJSONObject(i);
                                String ponumber = jsonObject1.optString("ponumber");
                                String qty = jsonObject1.optString("qty");
                            }
                        }

                    } catch (JSONException e) {
                        e.printStackTrace();
                    }

score 0 · Answer 3 · answered Nov 06 '17 at 05:31

You have to try like this, it will help you

JsonParseModel jsonParseModel = new Gson().fromJson(jsonString,JsonParseModel.class);



public class JsonParseModel {

private ArrayList<DataClass> data;

public ArrayList<DataClass> getData() {
    return data;
}

public void setData(ArrayList<DataClass> data) {
    this.data = data;
}

public class DataClass{

        private String ean,itemname,location;

        private ArrayList<PoData> po;

        public String getEan() {
            return ean;
        }

        public void setEan(String ean) {
            this.ean = ean;
        }

        public String getItemname() {
            return itemname;
        }

        public void setItemname(String itemname) {
            this.itemname = itemname;
        }

        public String getLocation() {
            return location;
        }

        public void setLocation(String location) {
            this.location = location;
        }

        public ArrayList<PoData> getPo() {
            return po;
        }

        public void setPo(ArrayList<PoData> po) {
            this.po = po;
        }

        public class PoData{
            private int ponumber,qty;

            public int getPonumber() {
                return ponumber;
            }

            public void setPonumber(int ponumber) {
                this.ponumber = ponumber;
            }

            public int getQty() {
                return qty;
            }

            public void setQty(int qty) {
                this.qty = qty;
            }
        }
    }
}

komal akhani · Answer 4 · 2017-11-09T06:08:39.447

    private void parseJsondata(String response) {
                try {
                    // response
                    JSONObject jsonObject = new JSONObject(response);
                    // get data from JSONArray
                    JSONArray data = jsonObject.getJSONArray("data");
                    // for loop to your JSONArray's Strings
                    for (int i = 0; i < data.length(); i++) {
                        //  get JSONObject from i
                        JSONObject jo = data.getJSONObject(i);
                        // get string
                        String ean = jo.getString("ean");
                        String itemname = jo.getString("itemname");
                        String location = jo.getString("location");
                        JSONArray jA = jo.getJSONArray("po");
                        for (int j = 0; j < jA.length(); j++) {
                            //  get JSONObject by jO
                            JSONObject jO = jA.getJSONObject(i);
                            // get string
                            String ponumber = jO.getString("ponumber");
                            String qty = jO.getString("qty");
                        }

                    }
                    //Log response
                    Log.e("response:", response);
                } catch (JSONException e) {
                    e.printStackTrace();
                }
            }

thank you for your answering, but the output only show first json data, — geri putra, Nov 06 '17 at 06:53

How to parsing multi dimensional json data array in android studio.?

4 Answers4