Store json array keys data in separate arrayLists

Question

I have this kind of json data returning from url as shown in Image1 Image2 Image3 Basically there are dates inside data and then within these dates there are further 5 different things i.e. session_from, session_to, rate, bookingFound and promotion. What i want is that i want to store all these dates data in separate arraylist.

For example:

sessionfrom0 contains data for 09-09-2018 and all its objects

sessionfrom1 contains data for 10-09-2018 and all its objects

sessionfrom2 contains data for 11-09-2018 and all its objects

I have tried with following piece of code but its not working correctly

JSONObject jsonObject = new JSONObject(response);
JSONObject dataObj = jsonObject.getJSONObject("data");
Iterator<String> iter = dataObj.keys();

    sessionsfrom0 = new ArrayList<String>();
    sessionsfrom1 = new ArrayList<String>();
    sessionsfrom2 = new ArrayList<String>();
        while (iter.hasNext()) {
            key = iter.next();
            JSONArray datesArray = dataObj.getJSONArray(key);

            for (int i = 0; i < datesArray.length(); i++) {
                 JSONObject datesObject0 = datesArray.getJSONObject(i);
                 JSONObject datesObject1 = datesArray.getJSONObject(i);
                 JSONObject datesObject2 = datesArray.getJSONObject(i);

                 sessionsfrom0.add(datesObject0.getString("session_from") + " - " +datesObject0.getString("session_to");
                 sessionsfrom1.add(datesObject1.getString("session_from") + " - " +datesObject1.getString("session_to");
                 sessionsfrom2.add(datesObject2.getString("session_from") + " - " +datesObject2.getString("session_to");
                  } }

This code not working correctly, as you can see that date 09-09-2018 contains further array of size 4 and and in those array there are further 5 items inside each jjson object so i want to store all this in first arraylist i.e. sessionfrom0 and then go to next date and pick all its arrays and json objects and store data in sessionfrom1 arraylist and so on.

Tenten Ponce · Accepted Answer · 2018-09-09 14:48:16Z

1

Try this:

JSONObject jsonObject = new JSONObject(response);
JSONObject dataObj = jsonObject.getJSONObject("data");
Iterator<String> iter = dataObj.keys();

sessionsfrom0 = new ArrayList<String>();
sessionsfrom1 = new ArrayList<String>();
sessionsfrom2 = new ArrayList<String>();
    while (iter.hasNext()) {
        String key = iter.next();
        JSONArray datesArray = dataObj.getJSONArray(key);

        switch (key) {
           case "2018-09-09":
              fillSessions(datesArray, sessionsfrom0);
              break;

           case "2018-10-09":
              fillSessions(datesArray, sessionsfrom1);
              break;
           ....so on....
        }
    }

You can create a function instead of rewriting the for loop logic on each case:

void fillSessions(JSONArray jsonArray, List<String> sessionList) {
   for (int i = 0; i < jsonArray.length(); i++) {
      JSONObject datesObject = jsonArray.getJSONObject(i);

      sessionList.add(datesObject.getString("session_from") + " - " +datesObject0.getString("session_to");
   }
}

edited Sep 9, 2018 at 14:48

answered Sep 9, 2018 at 14:45

Tenten Ponce

2,5261 gold badge15 silver badges42 bronze badges

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

2 Comments

Aarks Over a year ago

I have been stuck on this from few hours. You are genious. Works like a charm. Thankyou so much :)

Tenten Ponce Over a year ago

No problem, happy to help :)

prashant17 · Accepted Answer · 2018-09-09 15:05:30Z

1

You can do this by using HashMap

JSONObject jsonObject = new JSONObject(response);
    JSONObject dataObj = jsonObject.getJSONObject("data");
    Iterator<String> iter = dataObj.keys();

    HashMap<String, ArrayList<String>> map = new HashMap<>();

    while (iter.hasNext()) {
        key = iter.next();

        JSONArray datesArray = dataObj.getJSONArray(key);
        ArrayList<String> list = new ArrayList<>();

        for (int i = 0; i < datesArray.length(); i++) {
            JSONObject datesObject0 = datesArray.getJSONObject(i);

            list.add(datesObject0.getString("session_from") + " - " + datesObject0.getString("session_to");
        }
        map.put(key, list);
        }

edited Sep 9, 2018 at 15:05

answered Sep 9, 2018 at 14:59

prashant17

1,5503 gold badges15 silver badges24 bronze badges

1 Comment

Aarks Over a year ago

Thankyou @prashant17. I have got the answer. Although this is correct too so upvote for this too :)

Mersad Esalati · Accepted Answer · 2018-09-09 15:12:28Z

1

Try this:

JSONObject jsonObject = new JSONObject(response);
JSONObject dataObj = jsonObject.getJSONObject("data");
Iterator<String> iter = dataObj.keys();

Map<String, ArrayList<String>> map = new TreeMap<>();
while (iter.hasNext()) {
    String key = iter.next();
    JSONArray datesArray = dataObj.getJSONArray(key);
    ArrayList<String> tmp = new ArrayList<>();
    for (int i = 0; i < jsonArray.length(); i++) {
        JSONObject datesObject = jsonArray.getJSONObject(i);
        tmp.add(datesObject.getString("session_from") + " - "+datesObject.getString("session_to"));
    }
    map.put(key, tmp);
}

Probably you don't have all keys inside data so using switch case is not sensitive.

answered Sep 9, 2018 at 15:12

Mersad Esalati

212 bronze badges

Collectives™ on Stack Overflow

Store json array keys data in separate arrayLists

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related