Python -check if a key:value pair exists at least once in a nested json object

Question

I've got a JSON-object looking like this:

I want to check if one of the given prices ({0} , {1} , {2}) contains priceType == "04" and countriesIncluded == "DE"

My code:

r = requests.get(f'https://api.vlb.de/api/v2/product/{isbn}/ean?access_token=9xx9xxxxxc9')
        vlb = json.loads(r.text)
        for i in vlb['prices']:
            if i['priceType'] == "04" and i["countriesIncluded"] == "DE":
                neupreis = i['priceAmount']
            else:
                neupreis = "False"

The problem with my attempt is the following: neupreis will always get the value of the last price (in this case {2} where the condition is false) but I want to check if any of the prices meet the condition.

Is there a better way to search through a JSON object than the for-loop I'm using?

PS: I've found some similar questions on Stack Overflow, but none of those Json-objects were as nested as mine… Thank you!

MangoNrFive · Accepted Answer · 2022-07-19 12:33:29Z

2

Using your code, if I understand you correctly, you could just do something like this:

r = requests.get(f'https://api.vlb.de/api/v2/product/{isbn}/ean?access_token=9xx9xxxxxc9')
vlb = json.loads(r.text)

neupreis = "False"
for i in vlb['prices']:
    if i['priceType'] == "04" and i["countriesIncluded"] == "DE":
        neupreis = i['priceAmount']
        break

A different approach would be to use a list-comprehension like this:

neupreise = [i['priceAmount'] for i in vlb["prices"] if i['priceType'] == "04" and i["countriesIncluded"] == "DE"]

In this case all the priceAmounts for the prices that meet the criterium are saved in a list. If the list is empty, then none of them met the criterium.

edited Jul 19, 2022 at 12:33

answered Jul 19, 2022 at 11:57

MangoNrFive

1,6091 gold badge12 silver badges24 bronze badges

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

4 Comments

Alexander Over a year ago

you should include a break statement once the correct value is found. Also your indentation is way off.

jack Over a year ago

This will only give you the last matching one, what if you have multiple ones which matches the condition

MangoNrFive Over a year ago

@jack the question was about if any of the prices meet the condition. This is what the code does. Otherwise you could append it to a list or better yet directly use a list-comprehension.

lasse3434 Over a year ago

Awesome,that solved my problem and I just had to change 1-2 lines of code, Thank you!

jack · Accepted Answer · 2022-07-19 12:03:06Z

This should help if you want to check if you don't want the last forloop to silently do nothing you can add before the second loop if indexes:

r = requests.get(f'https://api.vlb.de/api/v2/product/{isbn}/ean?access_token=9xx9xxxxxc9')
    vlb = json.loads(r.text)
    indexes=[]
        for i, preisDict in enumerate(vlb['prices']):
            if preisDict['priceType'] == "04" and preisDict["countriesIncluded"] == "DE":
                #neupreis = preisDict['priceAmount']
                indexes.append(i)
# Now you can access the Prices which meets the condition using
for i in indexes: # Will silently do nothing if the is not any which matches the condition
    vlb['prices'][i] # then do something with the right pricetypes

Collectives™ on Stack Overflow

Python -check if a key:value pair exists at least once in a nested json object

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related