JSON Website response into Python dictionary

Question

I'm trying to load a JSON response from a website into a Python (2.7) dictionary, but am getting stuck iterating through more than the outer JSON object.

E.g. the website response looks like:

{
  "movies": [
    {
      "movieTitle": "True Lies",
      "Cert": "15",
      "Released": "1987",
    },
     {
      "movieTitle": "Scary Movie",
      "Cert": "18",
      "Released": "1997",
    },

My Python is as follows, and when printing 'json_object' I see all of the data, but how can I get the JSON array held within 'json_object' into a Python list / dictionary?

response = requests.get('https://api.foo.com/movies/all', headers=headers)
json_object = json.loads(response.text)
print json_object

The question is unclear. json_object is a dict; json_object["movies"] is a list. Where exactly are you having problems? — Daniel Roseman
– Daniel Roseman, Commented Mar 8, 2016 at 8:58

Aswin Murugesh · Accepted Answer · 2016-03-08 09:02:26Z

1

In order to iterate over each movie, Use:

json_object = json.loads(response.text)
for movie in json_object['movies']:
    print movie['movieTitle']

answered Mar 8, 2016 at 9:02

Aswin Murugesh

11.1k11 gold badges46 silver badges73 bronze badges

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

1 Comment

M. Wombat Over a year ago

Perfect, this was the missing link in my logic. Many thanks :)

Avinash Raj · Accepted Answer · 2016-03-08 09:05:48Z

0

Try using json.loads. It shall convert your json into a python dictionary and you can access the elements now and manipulate them as you normall would in a python dict.

dict1 = json.loads(json_object)

For eg, to obtain the movie title:

title = dict1["movies"][0]["movietitle"]

edited Mar 8, 2016 at 9:05

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

answered Mar 8, 2016 at 8:58

Apoorva Srivastava

3882 silver badges19 bronze badges

2 Comments

Daniel Roseman Over a year ago

How does this help? OP is already using json.loads, as shown in the code.

Aswin Murugesh Over a year ago

This is wrong too. dict1['movies'] is a list. This will throw an error

Collectives™ on Stack Overflow

JSON Website response into Python dictionary

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related