How to Get JSON values Python

Question

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

Well, you cannot do response["user"] on a string response. What you want to do is response["user"] on the old value of response before you turned it into a string using json.dumps. — poke
– poke, Commented Sep 13, 2017 at 8:01

deepak murthy · Accepted Answer · 2017-09-13 07:56:38Z

1

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'])

answered Sep 13, 2017 at 7:56

deepak murthy

4113 gold badges6 silver badges21 bronze badges

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

2 Comments

poke Over a year ago

Why would you decode a JSON string right after encoding it?

deepak murthy Over a year ago

well, newbie, but this works, don't know how. can someone explain why this works ?

Collectives™ on Stack Overflow

How to Get JSON values Python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related