How to search for specific value in Json array using Python

Question

I'm using a website's API to get information. It outputs 100 values.

What is the best practice of searching for a specific value in this array?

The array looks something like this:

{
  "success":true,
  "data":
  {
    "array":
    [
      {
        "id":"1","name":"Value1"
      },
      {
        "id":"2","name":"Value2"
      }
    ]
  }
}

I try searching for the data using this snippet I found elsewhere, however it does not work:

for name in (r.json()['data']['array'][0]['name']):
    if r.json()['data']['array'][0] == s_name:
    ident = r.json()['data']['array'][0]['id']
    name = r.json()['data']['array'][0]['name']
    print (name + ' - ' + ident)
else:
    print ('Nothing was found.')

So if I was trying to reference Value1 how would I do this using Python?

Please note: I'm a rookie developer, first time using Json, not very experienced with Python.

All help is greatly appreciated.

I think you need to look at the json librairy for python. r.json() gives a string in a form of a json. You need to dump the string to obtain a dict like object — Whitefret
– Whitefret, Commented Jun 30, 2016 at 6:23
@Whitefret Assuming r is obtained by request.get(), r.json() returns a Python dictionary. — DeepSpace
– DeepSpace, Commented Jun 30, 2016 at 6:24
@DeepSpace thanks for the precision. I guess it should work then... — Whitefret
– Whitefret, Commented Jun 30, 2016 at 6:25
Alright I look into the documentation. I try to take shortcuts, I have not read any Python/Json documentation I just dove right into it. I have grasped the basics (so I think). However I'm missing out on a lot of things that I should know. — Zach Long
– Zach Long, Commented Jun 30, 2016 at 6:25

Roee Anuar · Accepted Answer · 2018-08-30 08:38:04Z

21

Here is a one-liner example for searching:

aaa = {
  "success":True,
  "data":
  {
    "array":
    [
      {
        "id":"1","name":"Value1"
      },
      {
        "id":"2","name":"Value2"
      }
    ]
  }
}

[a['name'] for a in aaa['data']['array'] if a['id']=='1']

This will return all the found cases, or an empty array if nothing is found

answered Aug 30, 2018 at 8:38

Roee Anuar

3,4682 gold badges23 silver badges36 bronze badges

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

Comments

AChampion · Accepted Answer · 2020-10-08 23:55:29Z

10

Not sure where that piece of code came from but it looks very wrong.

Just looking at the structure you can do something like:

for attrs in r.json()['data']['array']:
    if attrs['name'] == s_name:
        ident = attrs['id']
        name = attrs['name']
        print(name, '-', ident)
        break
else:
    print('Nothing found!')

edited Oct 8, 2020 at 23:55

answered Jun 30, 2016 at 6:26

AChampion

30.4k4 gold badges63 silver badges79 bronze badges

Comments

DeepSpace · Accepted Answer · 2016-06-30 06:25:37Z

8

Your code can be simplified a lot:

# no need to call `r.json` so many times, can simply save it to a variable
json_data = r.json()
for item in json_data["data"]["array"]:
    if item["name"] == "Value1":
        # do something...

answered Jun 30, 2016 at 6:25

DeepSpace

82.1k12 gold badges119 silver badges166 bronze badges

Collectives™ on Stack Overflow

How to search for specific value in Json array using Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related