How to check json key and value is available inside json file

Question

I want to check is "Code":"A" avaiable in json file. I already searching on internet and read many QA in stackoverflow but it does not help me. Could anyone show me how to do it?

with open(dummyJson_url):
    dataList = json.load(open(dummyJson_url))

test = json.loads("""{"Code":"A"}""")

racksLocation = dataList["Test"]

for i in range(len(racksLocation)):

    newLoc = dataList["Test"][i]

    if sorted(test.items()) in sorted(newLoc.items()):
        print("Yes")
        break

    else:
        print("No")

and here is my json:

{
    "Test": [
        {
            "Code":"A",
            "Buyer": []
        },
        {
            "Code":"B",
            "New": []
        },
        {
            "Code":"C",
            "Racks": []
        },
        {
            "Code":"D",
            "Baru": []
        }
    ]
}

What's the error are you getting?

Ashfaq
– Ashfaq

2019-10-04 07:53:29 +00:00
Commented Oct 4, 2019 at 7:53 — Ashfaq
– Ashfaq, Commented Oct 4, 2019 at 7:53

Eb J · Accepted Answer · 2019-10-04 08:09:23Z

There is a very simple problem:

>>> print(sorted(test.items()))
[('Code', 'A')] #a list with 1 item(tuple) in it

>>> print(sorted(newLoc.items()))
[('Buyer', []), ('Code', 'A')] #a list with 2 tuples

So when you are trying this:

if sorted(test.items()) in sorted(newLoc.items()):
   ...

the condition fails because [('Code', 'A')] is NOT in [('Buyer', []), ('Code', 'A')] but ('Code', 'A') is! (notice the lack of list brackets here)

All you need to do is access the first(and only) element in [('Code', 'A')] (which is sorted(test.items())[0])

This is all you need to do using just your approach if you prefer to stick with it(which could improve but I wont get into it):

with open(dummyJson_url):
    dataList = json.load(open(dummyJson_url))

test = json.loads("""{"Code":"A"}""")

racksLocation = dataList["Test"]

for i in range(len(racksLocation)):

    newLoc = dataList["Test"][i]

    if sorted(test.items())[0] in sorted(newLoc.items()): #you are now checking the first element inside the list
        print("Yes")
        break

    else:
        print("No")

Harsh Bafna · Accepted Answer · 2019-10-04 07:55:33Z

0

Simplified your code:

with open(dummyJson_url):
    dataList = json.load(open(dummyJson_url))

for item in datalist['Test']:
    if 'Code' in item and item['Code'] == "A":
        print 'yes'
        break
    else:
        print 'no'

answered Oct 4, 2019 at 7:55

Harsh Bafna

2,2341 gold badge17 silver badges26 bronze badges

Comments

Yugandhar Chaudhari · Accepted Answer · 2019-10-04 07:56:22Z

When you do json.loads(json_string) it gives you dictionary if you get for example json_data={"a":1} if you do json_data.get("a") it will give you value 1 if present or None so simply you can check you can make a resulable function for this

 def check_in_json(jsondata,key,value):
       for data in jsondata:
           if data.get(key) == value:
              return True
       return False

And call it like

json_data={
    "Test": [
        {
            "Code":"A",
            "Buyer": []
        },
        {
            "Code":"B",
            "New": []
        },
        {
            "Code":"C",
            "Racks": []
        },
        {
            "Code":"D",
            "Baru": []
        }
    ]
}

check_in_json(json_data["Test"],"Code","A") #you will get True if found else false

Bharat Gera · Accepted Answer · 2019-10-04 08:08:13Z

0

Going with your approach, Try below code:

with open(dummyJson_url):
    dataList = json.load(open(dummyJson_url))

test = {"Code":"A"}

for data in dataList["Test"]:
    if test.items() <= data.items():   # In dict, .items() would give you the set type which can be compared.
        print("Yes")
        break
    else:
        print("No")

Hope this helps!

edited Oct 4, 2019 at 8:08

answered Oct 4, 2019 at 8:00

Bharat Gera

8301 gold badge5 silver badges13 bronze badges

Comments

ZOB · Accepted Answer · 2019-10-04 08:29:40Z

0

JSONObject class has a method named "has":

http://developer.android.com/reference/org/json/JSONObject.html#has(java.lang.String)

answered Oct 4, 2019 at 8:29

ZOB

116 bronze badges

Collectives™ on Stack Overflow

How to check json key and value is available inside json file

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related