Accessing nested objects with python

Question

I have a response that I receive from foursquare in the form of json. I have tried to access the certain parts of the object but have had no success. How would I access say the address of the object? Here is my code that I have tried.

url = 'https://api.foursquare.com/v2/venues/explore'

params = dict(client_id=foursquare_client_id,
              client_secret=foursquare_client_secret,
              v='20170801', ll=''+lat+','+long+'',
    query=mealType, limit=100)

resp = requests.get(url=url, params=params)

data = json.loads(resp.text)
msg = '{} {}'.format("Restaurant Address: ", 
data['response']['groups'][0]['items'][0]['venue']['location']['address'])
print(msg)

Here is an example of json response:

"items": [
      {
        "reasons": {
          "count": 0,
          "items": [
            {
              "summary": "This spot is popular",
              "type": "general",
              "reasonName": "globalInteractionReason"
            }
          ]
        },
        "venue": {
          "id": "412d2800f964a520df0c1fe3",
          "name": "Central Park",
          "contact": {
            "phone": "2123106600",
            "formattedPhone": "(212) 310-6600",
            "twitter": "centralparknyc",
            "instagram": "centralparknyc",
            "facebook": "37965424481",
            "facebookUsername": "centralparknyc",
            "facebookName": "Central Park"
          },
          "location": {
            "address": "59th St to 110th St",
            "crossStreet": "5th Ave to Central Park West",
            "lat": 40.78408342593807,
            "lng": -73.96485328674316,
            "labeledLatLngs": [
              {
                "label": "display",
                "lat": 40.78408342593807,
                "lng": -73.96485328674316
              }
            ],

the full response can be found here

Including what happens when you run the code will improve the quality and specificity of the answers you receive. After you updated your question, assuming that you correctly import the requisite modules and provide the foursquare credentials, your code should work as is now. If it's not, then sharing the error or errant behavior you see should help make the issue immediately apparent. — Ketzak, Jan 31 '18 at 20:31
Almost duplicate of [Python Accessing Nested JSON Data - Stack Overflow](https://stackoverflow.com/questions/23306653/python-accessing-nested-json-data) -- although in this case the issue is a typo rather than the OP not knowing how to do it. — user202729, Feb 18 '21 at 03:39

score 1 · Answer 1 · answered Jan 31 '18 at 20:03

1

Like so

addrs=data['items'][2]['location']['address']

answered Jan 31 '18 at 20:03

SuperStew

2,857
2
15
27

Ketzak · Answer 2 · 2018-01-31T20:26:34.310

Your code (at least as far as loading and accessing the object) looks correct to me. I loaded the json from a file (since I don't have your foursquare id) and it worked fine. You are correctly using object/dictionary keys and array positions to navigate to what you want. However, you mispelled "address" in the line where you drill down to the data. Adding the missing 'a' made it work. I'm also correcting the typo in the URL you posted.

I answered this assuming that the example JSON you linked to is what is stored in data. If that isn't the case, a relatively easy way to see exact what python has stored in data is to import pprint and use it like so: pprint.pprint(data).

You could also start an interactive python shell by running the program with the -i switch and examine the variable yourself.

score 0 · Answer 3 · answered Jan 31 '18 at 20:04

0

data["items"][2]["location"]["address"]

This will access the address for you.

answered Jan 31 '18 at 20:04

ltd9938

1,444
1
15
29

score 0 · Answer 4 · answered Jan 31 '18 at 20:11

You can go to any level of nesting by using integer index in case of an array and string index in case of a dict. Like in your case items is an array

#items[int index]
items[0]

Now items[0] is a dictionary so we access by string indexes

item[0]['location']

Now again its an object s we use string index

item[0]['location']['address]

Accessing nested objects with python

4 Answers4