Python parsing json issue

Question

I'm having troubles parsing a complicated json. That is it:

{
    "response": {
        "players": [
            {
                "bar": "76561198034360615",
                "foo": "49329432943232423"
            }
        ]

    }
}

My code:

url = urllib.urlopen("foobar").read()
js = json.load(url)
data = js['response']
print data['players']

The problem is that this would print the dict. What I want is to reach the key's values, like foo and bar. What I tried so far is doing data['players']['foo'] and it gives me an error that list indices should be integers, I tried of course, it didn't work. So my question is how do I reach these values? Thanks in advance.

alexn · Accepted Answer · 2013-04-29 17:51:01Z

8

data['response']['players'] is an array (as defined by the brackets ([, ]), so you need to access items using a specific index (0 in this case):

data['players'][0]['foo']

Or iterate over all players:

for player in data['response']['players']:
    print player['foo']

answered Apr 29, 2013 at 17:51

alexn

59.2k14 gold badges114 silver badges146 bronze badges

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

1 Comment

maikati Over a year ago

Oh yeah, I forgot how to select them exactly. Thanks alot :)

eandersson · Accepted Answer · 2013-04-29 17:57:34Z

3

The problem is that players is a list of items ([ ] in json). So you need to select the first and only item in this case using [0].

print data['players'][0]['foo']

But, keep in mind that you may have more than one player, in which case you either need to specify the player, or loop through the players using a for loop

for player in data['players']:
    print player['foo']

edited Apr 29, 2013 at 17:57

answered Apr 29, 2013 at 17:52

eandersson

26.4k8 gold badges96 silver badges112 bronze badges

1 Comment

eandersson Over a year ago

Haha, yea I saw he was like 60s before me. :)

Collectives™ on Stack Overflow

Python parsing json issue

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related