How to parse JSON Array of objects in python

Question

I received the following JSON Array from the POST response of an HTTP request:

[{
    "username": "username_1",
    "first_name": "",
    "last_name": "",
    "roles": "system_admin system_user",
    "locale": "en",
    "delete_at": 0,
    "update_at": 1511335509393,
    "create_at": 1511335500662,
    "auth_service": "",
    "email": "userid_1@provider_1.com",
    "auth_data": "",
    "position": "",
    "nickname": "",
    "id": "short-string-of-random-characters-1"
}, {
  ...
}
<more such objects>..]

Given that typeof(response) gives me requests.models.Response, how can I parse it in Python?

Possible duplicate of Convert string to JSON using Python if not, then it's an array which means its already parsed as json, so I'm not sure what you're asking in that case — Nick is tired
– Nick is tired, Commented Jan 10, 2018 at 14:39
you might want to mask personal information such as email, phone etc from your snippets before posting on public forums — y2k-shubham
– y2k-shubham, Commented Oct 5, 2018 at 8:23

johnthagen · Accepted Answer · 2020-04-07 18:02:37Z

25

Take a look at the json module. More specifically the 'Decoding JSON:' section.

import json
import requests

response = requests.get()  # api call

users = json.loads(response.text)
for user in users:
    print(user['id'])

edited Apr 7, 2020 at 18:02

johnthagen

9,3698 gold badges44 silver badges49 bronze badges

answered Jan 10, 2018 at 14:36

Jim Wright

6,0681 gold badge18 silver badges35 bronze badges

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

2 Comments

prashant thakre Over a year ago

Its not required for you to import json, Its simple python dict and use for loop without loading to json.

Jim Wright Over a year ago

@prashantthakre How can you loop over the dict without first json decoding the string?

MITHU · Accepted Answer · 2018-01-10 15:15:48Z

5

You can try like below to get the values from json response:

import json

content=[{
    "username": "admin",
    "first_name": "",
    "last_name": "",
    "roles": "system_admin system_user",
    "locale": "en",
    "delete_at": 0,
    "update_at": 1511335509393,
    "create_at": 1511335500662,
    "auth_service": "",
    "email": "[email protected]",
    "auth_data": "",
    "position": "",
    "nickname": "",
    "id": "pbjds5wmsp8cxr993nmc6ozodh"
}, {
    "username": "chatops",
    "first_name": "",
    "last_name": "",
    "roles": "system_user",
    "locale": "en",
    "delete_at": 0,
    "update_at": 1511335743479,
    "create_at": 1511335743393,
    "auth_service": "",
    "email": "[email protected]",
    "auth_data": "",
    "position": "",
    "nickname": "",
    "id": "akxdddp5p7fjirxq7whhntq1nr"
}]

for item in content:
    print("Name: {}\nEmail: {}\nID: {}\n".format(item['username'],item['email'],item['id']))

Output:

Name: admin
Email: [email protected]
ID: pbjds5wmsp8cxr993nmc6ozodh

Name: chatops
Email: [email protected]
ID: akxdddp5p7fjirxq7whhntq1nr

answered Jan 10, 2018 at 15:15

MITHU

1664 gold badges15 silver badges45 bronze badges

1 Comment

y2k-shubham Over a year ago

please consider masking personal information such as email from snippets in your answer. See edit history of question for more details

Abhishek Kaushik · Accepted Answer · 2018-01-10 14:39:07Z

0

use python 3 and import urlib

import urllib.request
import json
url = link of the server 
#Taking response and request  from url

r = urllib.request.urlopen(url)
#reading and decoding the data
data = json.loads(r.read().decode(r.info().get_param('charset') or 'utf-8'))


for json_inner_array in data:
        for json_data in json_inner_array:
                    print("id: "+json_data["id"])

answered Jan 10, 2018 at 14:39

Abhishek Kaushik

931 gold badge2 silver badges12 bronze badges

Comments

Buzz · Accepted Answer · 2018-01-10 14:37:02Z

-2

It seems what you are looking for is the json module. with it you can use this to parse a string into json format:

import json
output=json.loads(myJsonString)

answered Jan 10, 2018 at 14:37

Buzz

1,91721 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to parse JSON Array of objects in python

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related