How to parse nested JSON from Map<String, Object>

Question

I am using the below to map a json response to a Map

 Map<String, Object> apiResponse = restTemplate.postForObject("https://maps.googleapis.com/maps/api/geocode/json?address="+defaultLocation+"&key="+API_KEY, httpEntity, Map.class, Collections.EMPTY_MAP);

I can use the below to output the entire JSON to a string

    String jsonResponse = apiResponse.get("results").toString();

However, what I want to get is a nested value which is results->geometry->location

I have tried a number of solution with JSONArrays, JSONObjects, Substring but can't get them to work.

Response JSON:

{
   "results" : [
      {
         "address_components" : [
            {
               "long_name" : "Auckland",
               "short_name" : "Auckland",
               "types" : [ "locality", "political" ]
            },
            {
               "long_name" : "Auckland",
               "short_name" : "Auckland",
               "types" : [ "administrative_area_level_2", "political" ]
            },
            {
               "long_name" : "Auckland",
               "short_name" : "Auckland",
               "types" : [ "administrative_area_level_1", "political" ]
            },
            {
               "long_name" : "New Zealand",
               "short_name" : "NZ",
               "types" : [ "country", "political" ]
            }
         ],
         "formatted_address" : "Auckland, New Zealand",
         "geometry" : {
            "bounds" : {
               "northeast" : {
                  "lat" : -36.660571,
                  "lng" : 175.287137
               },
               "southwest" : {
                  "lat" : -37.065475,
                  "lng" : 174.4438016
               }
            },
            "location" : {
               "lat" : -36.8484597,
               "lng" : 174.7633315
            },
            "location_type" : "APPROXIMATE",
            "viewport" : {
               "northeast" : {
                  "lat" : -36.660571,
                  "lng" : 175.287137
               },
               "southwest" : {
                  "lat" : -37.065475,
                  "lng" : 174.4438016
               }
            }
         },
         "place_id" : "ChIJ--acWvtHDW0RF5miQ2HvAAU",
         "types" : [ "locality", "political" ]
      },
      {
         "address_components" : [
            {
               "long_name" : "Auckland",
               "short_name" : "Auckland",
               "types" : [ "political", "sublocality", "sublocality_level_1" ]
            },
            {
               "long_name" : "Auckland",
               "short_name" : "Auckland",
               "types" : [ "locality", "political" ]
            },
            {
               "long_name" : "Auckland",
               "short_name" : "Auckland",
               "types" : [ "administrative_area_level_2", "political" ]
            },
            {
               "long_name" : "Auckland",
               "short_name" : "Auckland",
               "types" : [ "administrative_area_level_1", "political" ]
            },
            {
               "long_name" : "New Zealand",
               "short_name" : "NZ",
               "types" : [ "country", "political" ]
            },
            {
               "long_name" : "1010",
               "short_name" : "1010",
               "types" : [ "postal_code" ]
            }
         ],
         "formatted_address" : "Auckland, 1010, New Zealand",
         "geometry" : {
            "bounds" : {
               "northeast" : {
                  "lat" : -36.8364659,
                  "lng" : 174.7838398
               },
               "southwest" : {
                  "lat" : -36.8621041,
                  "lng" : 174.7503805
               }
            },
            "location" : {
               "lat" : -36.8484597,
               "lng" : 174.7633315
            },
            "location_type" : "APPROXIMATE",
            "viewport" : {
               "northeast" : {
                  "lat" : -36.8364659,
                  "lng" : 174.7838398
               },
               "southwest" : {
                  "lat" : -36.8621041,
                  "lng" : 174.7503805
               }
            }
         },
         "place_id" : "ChIJuZqpSPtHDW0R4LOiQ2HvAAU",
         "types" : [ "political", "sublocality", "sublocality_level_1" ]
      }
   ],
   "status" : "OK"
}

Any help would be greatly appreciated.

please share your json output and the code what u have tried — Pavneet_Singh
– Pavneet_Singh, Commented Nov 11, 2016 at 6:36
@PavneetSingh I have added the response JSON. The code has come and gone, so I can add what I have tried. Im really interested in the best approach if you have one? — Yonkee
– Yonkee, Commented Nov 11, 2016 at 6:40
check this answer. It is what you are looking for. stackoverflow.com/questions/40407198/… — Yoram
– Yoram, Commented Nov 11, 2016 at 6:43
You should convert the object which you get from apiResponse.get(results) to an JSONObject. In that way , you will access to all the elements inside it.. — v1shnu
– v1shnu, Commented Nov 11, 2016 at 6:54
@ViChU How do I get nested values from a JSONObject? I tried but no luck? — Yonkee
– Yonkee, Commented Nov 11, 2016 at 7:02

Pavneet_Singh · Accepted Answer · 2016-11-11 06:58:32Z

4

JSONObject obj=new JSONObject(jsonresult);
// get result array
JSONArray resultsarray= obj.getJSONArray("results"); 
for (int i=0;i<resultsarray.length(),i++){
        // get Objects using index
        JSONObject jsonobject= results.getJSONObject(i);
        // get geometry object
        JSONObject geometry= jsonobject.getJSONObject("geometry");
        // get location object from geometry
        JSONObject location= geometry.getJSONObject("location");

        // get location values from location object
        double lat = location.optDouble("lat",0.0);
        double long = location.optDouble("lng",0.0);
 }

About optDouble

public double optDouble(String key, double defaultValue) {

Get an optional double associated with a key, or the defaultValue if there is no such key or if its value is not a number. If the value is a string, an attempt will be made to evaluate it as a number.

answered Nov 11, 2016 at 6:58

Pavneet_Singh

37.5k5 gold badges57 silver badges71 bronze badges

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

4 Comments

Yonkee Over a year ago

Which JSONObject are you using? Mine doesn't support getJSONArray

Pavneet_Singh Over a year ago

@Yonkee i am using org.json.JSONObject

Yonkee Over a year ago

Boom, its working. I think I was using the wrong JSON library during my investigation. Thanks for your help.

Pavneet_Singh Over a year ago

@Yonkee i am glad that it worked for you :) happy coding

Yoram · Accepted Answer · 2016-11-11 06:49:54Z

Ideally, you would like to access the properties with the same native notation like you would do in JS. Something like this:

String url = "https://maps.googleapis.com/maps/api/geocode/json?address=" + address;
String responseStr = fetch(url);
JsonHelper response =  JsonHelper.forString(responseStr);

String status = (String) response.getValue("status");
if(status != null && status.equals("OK")) {
   lat = (Double) response.getValue("results[0].geometry.location.lat");        
   lng = (Double) response.getValue("results[0].geometry.location.lng");
}

The following JsonHelper class code (taken from jello-framework) lets you do exactly that.

package jello.common;

import java.util.List;

import com.google.gson.Gson;
import java.util.AbstractMap;

public class JsonHelper {

    private Object json;

    public JsonHelper(String jsonString) {
        Gson g = new Gson();
        json = g.fromJson(jsonString, Object.class);
    }

    public static JsonHelper forString(String jsonString) {
        return new JsonHelper(jsonString);
    }

    @SuppressWarnings("unchecked")
    public Object getValue(String path) {
        Object value = json;
        String [] elements = path.split("\\.");
        for(String element : elements) {
            String ename = element.split("\\[")[0];

            if(AbstractMap.class.isAssignableFrom(value.getClass())) {
                value = ( (AbstractMap<String, Object>) value).get(ename);

                if(element.contains("[")) {
                    if(List.class.isAssignableFrom(value.getClass())) {
                        Integer index = Integer.valueOf(element.substring(element.indexOf("[")+1, element.indexOf("]")) );
                        value = ((List<Object>) value).get(index);
                    }
                    else {
                        return null;
                    }
                }
            }
            else {
                return null;
            }
        }

        return value;
    }
}

I have implemented this, but still unsure how to get nested values? JSONHelper jsonHelper = new JSONHelper(apiResponse.toString());

Sangram Badi · Accepted Answer · 2016-11-11 07:06:21Z

0

Use jackson api for parsing,it will be easy

        ObjectMapper mapper = new ObjectMapper();
        JsonNode node = mapper.readTree(json);
        if(node.get("results").isArray()){
            for(int i=0; i <= node.get("results").size()-1; i++){
                System.out.println(node.get("results").get(i));
            }

answered Nov 11, 2016 at 7:06

Sangram Badi

4,30412 gold badges50 silver badges86 bronze badges

Comments

v1shnu · Accepted Answer · 2016-11-11 07:13:35Z

0

I used Gson api and was able to get the location. Try this :

Code::

    Gson gson = new Gson();

    String json = "your json";

    JsonObject map = gson.fromJson(json, JsonObject.class); // to be replaced with your restTemplate call
    JsonArray arr = map.getAsJsonArray("results");

    for (Object j : arr) {
        System.out.println(((JsonObject) j).get("geometry").getAsJsonObject().get("location"));
    }

Console Output::

{"lat":-36.8484597,"lng":174.7633315}
{"lat":-36.8484597,"lng":174.7633315}

So ideally just get the response as a JsonObject instead of a Map and you will be able to read the location.

answered Nov 11, 2016 at 7:13

v1shnu

2,24110 gold badges45 silver badges72 bronze badges

Collectives™ on Stack Overflow

How to parse nested JSON from Map<String, Object>

4 Answers 4

4 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related