Python - Cannot access Requests Json list

Question

I am really struggling with a search of a dict in python. What I do is call an external API using the Requests package.

response = requests.get(apiurl + vnendpoint + '?page=1&per_page=0&sort=id&api_key=' + apikey)

records = response.json()

This works fine and returns the following dict:

{u'pagination': {u'per_page': 0, u'total': 187, u'page': 1}, u'data': [{u'status': u'Inactive', u'name': u'access-a37', id': u'2', u'peripheral':...

The problem is, I now want to search the data object, which is a list inside the original JSON, for an ID which may or may not be there.

x = "1"
if x in records:
    print("add")

This is the part I cannot get past. It always returns a false response, but I know the ID is there.

Am I missing something really straight forward here?

Thanks

You are searching inside the outer dict not the list. You have to access the list first. Then, you will need to check the id field in the dicts I side that list. — juanpa.arrivillaga
– juanpa.arrivillaga, Commented Mar 27, 2017 at 16:09

kichik · Accepted Answer · 2017-03-27 19:28:50Z

2

When you use if x in records: you're checking if the value of x ("1") itself is in records. It's not. According to your question, what is in records['data'] is a dictionary containing an item called id with the value "1". Python doesn't know it needs to look into id for you.

You have two options:

Go over every item in the list, access its id item and compare it to x.
Build a dictionary mapping the id item to the actual data and use that for looking up x.

Code samples:

for i in records['data']:
  if i['id'] == x:
    print('found', x)

# or

d = {}
for i in records['data']:
  d[i['id']] = i
if x in d:
  print('found', x)

edited Mar 27, 2017 at 19:28

answered Mar 27, 2017 at 16:09

kichik

34.9k7 gold badges102 silver badges121 bronze badges

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

Comments

Parison · Accepted Answer · 2017-03-27 16:23:11Z

1

First, get the data object from records

myData=records['data']

Then search for your id in myData

x = 1
myDict = dict()
for dictionnary in myData:
      if ( dictionnary['id'] == x ):
         print ('found',x)
         myDict = dictionnary
         break

answered Mar 27, 2017 at 16:23

Parison

2191 gold badge3 silver badges9 bronze badges

Collectives™ on Stack Overflow

Python - Cannot access Requests Json list

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related