How to extract value from key of json format using python

Question

My JSON response is as follows:

[{"interface":"WAN 1","status":"Active","ip":"192.168.254.3","gateway":"192.168.254.1","publicIp":"206.59.240.69","dns":"192.168.254.1","vlan":2,"usingStaticIp":false}]

I wanted to extract the value of "status" but getting the below error:

TypeError: 'Response' object has no attribute '__getitem__'

Code snippet:

response = requests.request("GET", url, headers=headers, params=querystring)

print(response.text)
print(response["status"])

Can somebody please help me to extract the value of 'status'?

looks like your response is an array. You would want to access the status property at the index you are looking for — Felipe
– Felipe, Commented Aug 29, 2019 at 15:37

Anoop R Desai · Accepted Answer · 2019-08-29 15:37:20Z

1

You need to load the JSON first:

import json

response = requests.request("GET", url, headers=headers, params=querystring)
data = json.loads(response.text)
print(data["status"])

Note that based on the JSON response sample provided, the response is a list, in which case you would have to print data[0]["status"].

answered Aug 29, 2019 at 15:37

Anoop R Desai

7185 silver badges19 bronze badges

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

1 Comment

Bindu Over a year ago

Thanks a lot Anoop. data[0]["status"] worked for me.

Collectives™ on Stack Overflow

How to extract value from key of json format using python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related