Get value out JSON Object containing JSON arrays

Question

How can I get the value of "distance" out of the following JSON object with java?

{
  "destination_addresses" : [ "New York City, New York, Verenigde Staten" ],
  "origin_addresses" : [ "Washington D.C., District of Columbia, Verenigde Staten" ],
  "rows" : [
    {
       "elements" : [
          {
             "distance" : {
                "text" : "225 mijl",
                "value" : 361714
             },
             "duration" : {
                "text" : "3 uur 51 min.",
                "value" : 13877
             },
             "status" : "OK"
          }
       ]
    }
 ],
 "status" : "OK"
}

I tried: json.getJSONArray("rows").getJSONObject(0).getJSONObject("distance").toString();

But I always get org.json.JSONException: JSONObject["distance"] not found.

You need to use Jackson or Gson in order to deserialise a json. — Bilal BBB
– Bilal BBB, Commented Jun 10, 2016 at 19:33
You are missing a getJSONObject("elements").getJSONObject(0) before .getJSONObject("distance") — ssice
– ssice, Commented Jun 10, 2016 at 21:17

Max Leske · Accepted Answer · 2016-06-11 08:03:12Z

2

I think you are missing the second array "elements", you find array "row" so get object 0, in object 0 you need to find the "elements" array then take the object 0 again, so you can get the "distance" object.

Try this:

json.getJSONArray("rows").getJSONObject(0).getJSONArray("elements").getJSONObject(0).getJSONObject("distance").toString();

Again, I think. I hope this helped you.

edited Jun 11, 2016 at 8:03

Max Leske

5,1356 gold badges46 silver badges57 bronze badges

answered Jun 10, 2016 at 19:53

Rafael Passarela

1567 bronze badges

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

1 Comment

Pieter De Rop Over a year ago

It certainly helped me ! Thanks !

Community · Accepted Answer · 2017-05-23 12:16:00Z

0

Use java-json.jar

Convert JSON String to object and fetch the element.

You can refer this.

Try this:

package Sample;

import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

public class TestMain 
{

    public static void main(String[] args) throws JSONException
    {
        String s="{  \"destination_addresses\" : [ \"New York City, New York, Verenigde Staten\" ],  \"origin_addresses\" : [ \"Washington D.C., District of Columbia, Verenigde Staten\" ],  \"rows\" : [    {       \"elements\" : [          {             \"distance\" : {                \"text\" : \"225 mijl\",                \"value\" : 361714             },             \"duration\" : {                \"text\" : \"3 uur 51 min.\",                \"value\" : 13877             },             \"status\" : \"OK\"          }       ]    } ], \"status\" : \"OK\"} ";

        JSONObject jsonObj = new JSONObject(s);

        JSONArray array= (JSONArray) jsonObj.get("rows");

        JSONObject jsonObj2 =(JSONObject) array.get(0);

        JSONArray array2= (JSONArray)jsonObj2.get("elements");

        JSONObject jsonObj3 =(JSONObject) array2.get(0);

        System.out.println(jsonObj3.get("distance"));

    }
}

OUTPUT:

{"text":"225 mijl","value":361714}

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Jun 10, 2016 at 19:50

PVR

9159 silver badges19 bronze badges

2 Comments

PVR Over a year ago

@PieterDeRop You might want to accept the answer if it helped to solve your question.

Pieter De Rop Over a year ago

I can only accept one answer and I don't have enough reputation point yet to say your answer is usefull.

Collectives™ on Stack Overflow

Get value out JSON Object containing JSON arrays

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related