Python JSON parse - Extract attribute

Question

Im having more difficulty with this than I should be!

Im trying to extract postalCode from the below bing maps JSON:

{  
   "authenticationResultCode":"ValidCredentials",
   "brandLogoUri":"http:\/\/dev.virtualearth.net\/Branding\/logo_powered_by.png",
   "copyright":"Copyright © 2014 Microsoft and its suppliers. All rights reserved. This API cannot be accessed and the content and any results may not be used, reproduced or transmitted in any manner without express written permission from Microsoft Corporation.",
   "resourceSets":[  
  {  
     "estimatedTotal":1,
     "resources":[  
        {  
           "__type":"Location:http:\/\/schemas.microsoft.com\/search\/local\/ws\/rest\/v1",
           "bbox":[  
              56.216052482429326,
              -2.9494141659354827,
              56.223777917570679,
              -2.9308900340645176
           ],
           "name":"Street, Leven, KY8 5",
           "point":{  
              "type":"Point",
              "coordinates":[  
                 56.2199152,
                 -2.9401521
              ]
           },
           "address":{  
              "addressLine":"Street",
              "adminDistrict":"Scotland",
              "adminDistrict2":"Fife",
              "countryRegion":"United Kingdom",
              "formattedAddress":"Street, Leven, KY8 5",
              "locality":"Leven",
              "postalCode":"KY8 5"
           },
           "confidence":"Medium",
           "entityType":"Address",
           "geocodePoints":[  
              {  
                 "type":"Point",
                 "coordinates":[  
                    56.2199152,
                    -2.9401521
                 ],
                 "calculationMethod":"Interpolation",
                 "usageTypes":[  
                    "Display",
                    "Route"
                 ]
              }
           ],
           "matchCodes":[  
              "Good"
           ]
        }
     ]
  }
   ],
   "statusCode":200,
   "statusDescription":"OK",
   "traceId":"8fdd75362a694e02a45fa17d6e7c0e95|DB40080932|02.00.108.1000|DB4SCH010061257, DB4SCH010061346"
  }

My code only returns the field names and not the attribute:

r = requests.get(current_url)
        json_data = r.json()
        for item in json_data['resourceSets'][0]['resources']:
            for field in item['address']:
                print field

What am I missing? Sorry for the novice question!

print field, item['address'][field]

thefourtheye
– thefourtheye

2014-12-28 13:04:57 +00:00
Commented Dec 28, 2014 at 13:04 — thefourtheye
– thefourtheye, Commented Dec 28, 2014 at 13:04

Paul Lo · Accepted Answer · 2014-12-28 13:07:19Z

2

for field in item['address'] by default iterate through the key in item['address'] (a dictionary) only, so you need to:

for item in json_data['resourceSets'][0]['resources']:
    for field in item['address']:
        print field, item['address'][field]

answered Dec 28, 2014 at 13:07

Paul Lo

6,1466 gold badges33 silver badges37 bronze badges

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

Comments

Daniel Roseman · Accepted Answer · 2014-12-28 13:07:32Z

1

For loops over dictionaries in Python iterate just over the keys. If you want the values as well, you should use .items():

 for field, value in item['address'].items():
            print field, value

answered Dec 28, 2014 at 13:07

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

Collectives™ on Stack Overflow

Python JSON parse - Extract attribute

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related