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, Jun 10 '16 at 19:33
You are missing a `getJSONObject("elements").getJSONObject(0)` before `.getJSONObject("distance")` — ssice, Jun 10 '16 at 21:17

score 2 · Accepted Answer · edited Jun 11 '16 at 08:03

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 '16 at 08:03

Max Leske

5,007
6
42
54

answered Jun 10 '16 at 19:53

Rafael Passarela

156
7

It certainly helped me ! Thanks ! – Pieter De Rop Jun 11 '16 at 07:29

score 0 · Answer 2 · edited May 23 '17 at 12:16

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}

@PieterDeRop You might want to accept the answer if it helped to solve your question. — PVR, Jun 11 '16 at 09:12
I can only accept one answer and I don't have enough reputation point yet to say your answer is usefull. — Pieter De Rop, Jun 13 '16 at 12:35

Get value out JSON Object containing JSON arrays

2 Answers2