How filter required data from response of a request by using Python

Question

I have some response of a get request stored in a variable as below...

dashboard = 'http://12.345.67.890:8000/api/search?query=&starred=false'
dashboardr = s.get(dashboard)
dashboards = dashboardr.content
print(dashboards)

The response looks as below...

[{"id":19,"title":"Apple","uri":"db/abc-api","type":"dash-db","tags":[],"isStarred":false},{"id":20,"title":"Banana","uri":"db/cde-api","type":"dash-db","tags":[],"isStarred":false},{"id":7,"title":"Mango","uri":"db/efg","type":"dash-db","tags":[],"isStarred":false}]

Can some one please help me how we can extract the values of title and stored in another variable?

Title values in the above response are

Apple
Banana
Mango

rkp768 · Accepted Answer · 2019-02-15 18:42:46Z

1

Use eval(dashboards) instead of dashboards.

dashboard = 'http://12.345.67.890:8000/api/search?query=&starred=false'
dashboardr = s.get(dashboard)
# eval() will convert a string to a python statement/expression
dashboards = eval(dashboardr.content)

title_list = []
for _ in dashboards:
   title_list.append(dashboards["title"])

answered Feb 15, 2019 at 18:42

rkp768

564 bronze badges

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

1 Comment

SG131712 Over a year ago

I am getting error as dashboards = eval(dashboardr.content) File "<string>", line 1, in <module> NameError: name 'false' is not defined

balderman · Accepted Answer · 2019-02-15 19:37:21Z

1

Assuming that the response you from the HTTP call is a string, the code below extract the titles.

import json

response_str = '[{"id": 19, "title": "Apple", "uri": "db/abc-api", "type": "dash-db", "tags": [], "isStarred": false},{"id": 20, "title": "Banana", "uri": "db/cde-api", "type": "dash-db", "tags": [], "isStarred": false},{"id": 7, "title": "Mango", "uri": "db/efg", "type": "dash-db", "tags": [], "isStarred": false}]'
response_dict = json.loads(response_str)
titles = [entry['title'] for entry in response_dict]
print(titles)

Output:

[u'Apple', u'Banana', u'Mango']

answered Feb 15, 2019 at 19:37

balderman

24k8 gold badges39 silver badges60 bronze badges

Comments

Ninad Gaikwad · Accepted Answer · 2019-02-16 06:49:34Z

1

for i in eval(dashboards.replace('false', 'False')):
    print(i['title'])

instead of printing title you can save it in a list variable.

edited Feb 16, 2019 at 6:49

answered Feb 15, 2019 at 18:27

Ninad Gaikwad

4,5202 gold badges16 silver badges26 bronze badges

4 Comments

Bakuriu Over a year ago

This is not enough to answer the question, it only fixes the second part of the question not how to parse the response.

SG131712 Over a year ago

When implemented i am getting error print(i['title']) TypeError: string indices must be integers, not str

SG131712 Over a year ago

With the eval function included i am getting ' for i in eval(a): File "<string>", line 1, in <module> NameError: name 'false' is not defined'

Ninad Gaikwad Over a year ago

It's because you have a lower case "false" here instead of "False". You can fix this using the .replace method. Updated answer

Collectives™ on Stack Overflow

How filter required data from response of a request by using Python

3 Answers 3

1 Comment

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related