Extracting an array from a JSON object

Question

I have a JSON Object of the following and I need to parse the path strings inside the web array into an new JSON array.

"taxonomy": {
    "source": {
        "master": {
            "_id": "5000",
            "path": "/Appliances/Refrigerators/French Door Bottom Freezers"
        },
        "web": [
            {
                "_id": "6686",
                "path": "/Appliances/Refrigerators/French Door Bottom Freezers"
            },
            {
                "_id": "7686",
                "path": "/Appliances/Refrigerators/Bottom Freezers"
            }
        ],

    },

},

I have written till this but I'm not sure how to get all the path inside the web array.

                JSONObject jsonTaxonomy= _blob.optJSONObject("taxonomy");
            if(jsonTaxonomy!=null)
            {
                if(!jsonTaxonomy.isNull("source"))
                {
                    JSONObject jsonTaxonomySource= jsonTaxonomy.optJSONObject("source");
                    if(!jsonTaxonomySource.isNull("web"))
                    {
                        JSONArray jsonTaxonomySourceWeb= jsonTaxonomySource.optJSONArray("web");
                        if(jsonTaxonomySourceWeb!=null && jsonTaxonomySourceWeb.length()>0)
                        {
                            //Got inside the array
                        }
                    }
                }
            }

if(jsonTaxonomy!=null){ if(!jsonTaxonomy.isNull("source")){ }} can be replaced with if(jsonTaxonomy!=null && !jsonTaxonomy.isNull("source")){ } — Menno
– Menno, Commented Apr 29, 2013 at 10:12

Menno · Accepted Answer · 2013-04-29 10:14:14Z

1

Without providing you with a full answer, I'm convinced you'll be able to find your answer by debugging this method and stopping it at the most inner if(). You'll be able to of what jsonTaxonomySearsWeb consists and thus how to get its values.

answered Apr 29, 2013 at 10:14

Menno

12.8k14 gold badges59 silver badges92 bronze badges

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

2 Comments

John Over a year ago

Will using jsonTaxonomySearsWeb.getJSONObject(i).getString("path") and adding them to an array will work???

Menno Over a year ago

I'm no expert on JSONObject, but if this is part of a loop and i is provided by it, this probably will work.

Rahul · Accepted Answer · 2013-04-29 10:18:27Z

0

Modify your code to something like this:-

JSONObject jsonTaxonomy= _blob.optJSONObject("taxonomy");
if(jsonTaxonomy!=null)
{
        JSONObject jsonTaxonomySource = jsonTaxonomy.optJSONObject("source");
        if(jsonTaxonomySource!=null)
        {
            JSONArray jsonTaxonomySearsWeb= jsonTaxonomySource.optJSONArray("web");
            if(jsonTaxonomySearsWeb!=null)
            {
                // Traverse through your JSONArray and get each Object & extract path from it.
            }
        }
}

answered Apr 29, 2013 at 10:18

Rahul

45.2k11 gold badges89 silver badges108 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:28:09Z

0

I am bit unclear about the question. But As per my understanding you want to parse the JSON if you want to do that in java then you can use GSON jar from google...you can also check simple example here Gson handle object or array

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Apr 29, 2013 at 10:32

Kishor Raskar

1165 bronze badges

Comments

Make it Simple · Accepted Answer · 2013-04-29 10:58:30Z

Try like this...

      groups = json.getJSONArray(TAG_GROUP);
      System.out.println("Result Success+++"+groups);
      for (int i = 0; i < groups.length(); i++) {
      JSONObject c = groups.getJSONObject(i);
      String source = c.getString(TAG_SOURCE);
      System.out.println("Checking ::"+source);
      String lname = c.getString(TAG_PATH);
      HashMap<String, String> map = new HashMap<String, String>();
      map.put(TAG_SOURCE, source);
      map.put(TAG_PATH,path);
      weblist.add(map);       //weblist is your arraylist for both values
      webpathlist.add(path);   //webpathlist is your arraylist for path
       }
      List<String> newList = new ArrayList<String>();
      newList.addAll(weblist);

Collectives™ on Stack Overflow

Extracting an array from a JSON object

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related