Parsing JSON with mutiple JSON Arrays

Question

I am having trouble parsing JSON when there is multiple arrays. This is an example of the JSON:

{
   "topics":[
      {
         "posts":[
            {
               "date":"01/01/01 01:01",
               "user":"Example",
               "subject":"Example Topic #1",
               "contents":"Hello!"
            },
            {
               "date":"01/01/01 01:01",
               "user":"Example",
               "subject":"Example Reply #1",
               "contents":"Hello!"
            },
            {
               "date":"01/01/01 01:01",
               "user":"Example",
               "subject":"Example Reply #2",
               "contents":"Hello!"
            }
         ]
      },
      {
         "posts":[
            {
               "date":"01/01/01 01:01",
               "user":"Example",
               "subject":"Example Topic #2",
               "contents":"Hello!"
            },
            {
               "date":"01/01/01 01:01",
               "user":"Example",
               "subject":"Example Reply #1",
               "contents":"Hello!"
            },
            {
               "date":"01/01/01 01:01",
               "user":"Example",
               "subject":"Example Reply #2",
               "contents":"Hello!"
            }
         ]
      }
   ]
}

In each of the posts array the first one is the main topic itself and then the rest are replies, the amount of replies is varied and this is just an example.

What I am looking to do is take the user, subject and contents from the main post, the replies I want to ignore.

What I have tried so far after looking at some tutorials is:

try {
    JSONArray threads = jo.getJSONArray(THREADS_TAG); // jo is a JSONObject parameter.

    for (int i = 0; i < threads.length(); i++) {
        JSONObject c = threads.getJSONObject(i);
        JSONObject post = c.getJSONObject(POSTS_TAG);

        Log.i(TAG, "Name: " + post.getString(NAME_TAG));
    }
    } catch (JSONException e) {
        Log.e(TAG, "Exception:");
        e.printStackTrace();
}

But I am having problems with this and I am getting an exception:

at posts of type org.json.JSONArray cannot be converted to JSONObject

you need to getJSONObject(0) to obtain the first object of the array — njzk2
– njzk2, Commented Dec 26, 2012 at 17:16

Antrromet · Accepted Answer · 2012-12-26 17:29:30Z

3

You can do something like this

try {
    JSONArray threads = jo.getJSONArray("topics");

    for (int i = 0; i < threads.length(); i++) {
        JSONArray posts = threads.getJSONObject(0).getJSONArray("posts");
        user[i]=posts.getJSONObject(0).getString("user");
        subject[i]=posts.getJSONObject(0).getString("subject");
        contents[i]=posts.getJSONObject(0).getString("contents");
    }
    } catch (JSONException e) {
        Log.e(TAG, "Exception:");
        e.printStackTrace();
}

edited Dec 26, 2012 at 17:29

answered Dec 26, 2012 at 17:13

Antrromet

15.4k11 gold badges65 silver badges78 bronze badges

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

2 Comments

wow Over a year ago

For the part, threads.getJSONArray("posts"), getJSONArray() will only take an integer as the parameter.

Antrromet Over a year ago

@DanielB I am sorry, my mistake. Please see the updated answer.

ρяσѕρєя K · Accepted Answer · 2012-12-26 17:38:41Z

Change for JsonArray parsing as:

  for (int i = 0; i < threads.length(); i++) {

        JSONObject cjsontopic = threads.getJSONObject(i);
        JSONArray jsonarrayposts=cjsontopic.getJSONArray("posts");

        for (int j = 0; j < jsonarrayposts.length(); j++) {
                JSONObject cjsontopic = jsonarrayposts.getJSONObject(j);
        String strpost = cjsontopic.getString(POSTS_TAG);

        String struser = cjsontopic.getString("user");
        String strsubject = cjsontopic.getString("subject");
        String strcontents = cjsontopic.getString("contents");
        //... get other elemets
        Log.i(TAG, "Name: " +strpost);
     }

   }

currently you are trying to get String in JsonObject your Json format is just like JsonObject-->JsonArray-->JsonObject-->JsonArray-->JsonObject-->getString

Collectives™ on Stack Overflow

Parsing JSON with mutiple JSON Arrays

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related