JSON Parse an element inside an element in Python

Question

I have a JSON text grabbed from an API of a website:

{"result":"true","product":{"made":{"Taiwan":"Taipei","HongKong":"KongStore","Area":"Asia"}}}

I want to capture "Taiwan" and "Taipei" but always fail.

Here is my code:

import json
weather = urllib2.urlopen('url')
wjson = weather.read()
wjdata = json.loads(wjson)
print wjdata['product']['made'][0]['Taiwan']

I always get the following error: Keyword 0 error

Whats the correct way to parse that json?

@Rakesh I get the following error: TypeError: string indices must be integers — xiholac761
– xiholac761, Commented Nov 27, 2019 at 13:20
Errors are pointless without context, please post full error message and print exact json that you receive. — user11877195
– user11877195, Commented Nov 27, 2019 at 13:44
actually he is not receiving json he is receiving string of dictionary. @xiholac761 please check my post — Khakhar Shyam
– Khakhar Shyam, Commented Nov 27, 2019 at 13:49

gitsieg · Accepted Answer · 2019-11-27 13:49:58Z

1

You are indexing an array where there are none. The JSON is the following:

{ 
    "result":"true",
    "product": {
        "made": {
            "Taiwan":"Taipei",
            "HongKong":"KongStore",
            "Area":"Asia"
        }
    }
}

And the above contains no arrays.

You are assuming the JSON structure to be something like this:

{ 
    "result":"true",
    "product": {
        "made": [
            {"Taiwan":"Taipei"},
            {"HongKong":"KongStore"},
            {"Area":"Asia"}

        ]            
    }
}

From a brief look at the doc pages for the json package, I found this conversion table: Conversion table using json.loads

It tells us that a JSON object translates to a dict. And a dict has a method called keys, which returns a list of the keys.

I suggest you try something like this:

#... omitted code
objectKeys = wjdata['product']['made'].keys()

# You should now have a list of the keys stored in objectKeys.
for key in objectKeys:
    print key
    if key == 'Taiwan':
        print 'Eureka'

I haven't tested the above code, but I think you get the gist here :)

edited Nov 27, 2019 at 13:49

answered Nov 27, 2019 at 13:28

gitsieg

235 bronze badges

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

1 Comment

xiholac761 Over a year ago

You're right, there are no arrays. Is it possible to parse "Taipei" from that json data and print it?

rossi · Accepted Answer · 2019-11-27 13:18:03Z

0

wjdata['product']['made']['Taiwan'] works

answered Nov 27, 2019 at 13:18

rossi

3141 silver badge10 bronze badges

3 Comments

xiholac761 Over a year ago

Sadly it results in an error: TypeError: string indices must be integers

rossi Over a year ago

Are you trying to load a dynamic data(with multiple keys) or are you trying to get just key Taiwan

xiholac761 Over a year ago

Just the key Taiwan.

Collectives™ on Stack Overflow

JSON Parse an element inside an element in Python

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related