CODEWITHSUNDEEP
jsonpython-3.x
deepak murthy
deepak murthy

Reputation: 411

How to Get JSON values Python

Learning Days Code to the get the data in JSON Format

#...
cursor.execute("SELECT * FROM user")
response = {
    "version": "5.2",
    "user_type": "online",
    "user": list(cursor),
}
response = json.dumps(response, sort_keys=False, indent=4, separators=(',', ': '))
print(response)
# ...

This produces output as 

{
"version": "5.2",
"user_type": "online",
"user":
[
    {
        "name": "John",
        "id": 50
    },
    {
        "name": "Mark",
        "id": 57
    }
]
}

print(response["user"]) - TypeError: string indices must be integers

How do i access the values in JSON

Upvotes: 0

Views: 41

Answers (1)

deepak murthy
deepak murthy

Reputation: 411

json.dumps return a string, need a small conversion something like this, not sure is this the exact method to do

Solution:

response = JSONEncoder().encode(response )
response = JSONDecoder().decode(response )
response = json.loads(response )
print(response['user'[0]['id'])

Upvotes: 1

Related Questions