How to get a json value inside of another json in python?

Question

I am trying to get the "id" and "phone" values in the data out of this json:

  "status": "success",
  "data": {
    "id": "MertD43fdfdDdsjk",
    "countrycode": "GB",
    "country": "United Kingdom",
    "createdAt": 15534534000,
    "validUntil": 15534534000,
    "service": "gmail",
    "phone": "446576879809",
    "price": 0.21
  }
}

My current code is

json_data = json.loads(response.text)
    #print(json_data)
    values = json_data.items()
    #print(values)
    recieved = False


    for key, value in values:
        print(key, value)

        if key == "id":
            numid = value
            print(numid)
        elif key == "phone":
            phone = value
            print("Recieved the Phone Number - ",phone)
            recieved = True
        elif value == "Mobile number isn't received. Please try again":
            if recieved == False:
                getPhoneNumber()

I know I am only accessing status and data items and not the stuff inside of data. Currently, I am receiving the JSON as a result of requesting from an API so the values are always different.

Please provide a minimal reproducible example, as well as the current and expected output. — AMC
– AMC, Commented Dec 22, 2020 at 16:19

baduker · Accepted Answer · 2020-12-22 16:15:57Z

4

If that's a pure JSON from an API, why not do this?

d = {
    "status": "success",
    "data": {
        "id": "MertD43fdfdDdsjk",
        "countrycode": "GB",
        "country": "United Kingdom",
        "createdAt": 15534534000,
        "validUntil": 15534534000,
        "service": "gmail",
        "phone": "446576879809",
        "price": 0.21
    }
}

print(d["data"]["id"], d["data"]["phone"])

Output:

MertD43fdfdDdsjk 446576879809

answered Dec 22, 2020 at 16:15

baduker

20.1k9 gold badges43 silver badges63 bronze badges

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

Comments

0stone0 · Accepted Answer · 2020-12-22 16:22:30Z

1

No need for loops, you can access the data by the key;

import json

json_string = '{"status": "success", "data": {"id": "MertD43fdfdDdsjk", "countrycode": "GB", "country": "United Kingdom", "createdAt": 15534534000, "validUntil": 15534534000, "service": "gmail", "phone": "446576879809", "price": 0.21 } }'
json_data = json.loads(json_string)
data_dict = json_data['data']

dataid = data_dict['id']
phone = data_dict['phone']

print(dataid)
print(phone)

MertD43fdfdDdsjk

446576879809

Getting values from JSON using Python

edited Dec 22, 2020 at 16:22

answered Dec 22, 2020 at 16:18

0stone0

45.5k6 gold badges53 silver badges82 bronze badges

2 Comments

baduker Over a year ago

Don't use id as variable name, as this shadows the built-in id.

0stone0 Over a year ago

Thanks @baduker! I've improved my answer!

shepx · Accepted Answer · 2020-12-22 16:25:14Z

1

values is a dict, you can direct access fields

numid = values['data']['id']
phone = values['data']['phone']

answered Dec 22, 2020 at 16:25

shepx

684 bronze badges

Comments

Nanthakumar J J · Accepted Answer · 2020-12-22 16:22:39Z

0

Use requests module which provides more features of extracting text # pip install requests
In this module after getting a response try response.json

For eg: if the received data is

 d = {
     "status": "success",
     "data": {
         "id": "MertD43fdfdDdsjk",
         "countrycode": "GB",
         "country": "United Kingdom",
         "createdAt": 15534534000,
         "validUntil": 15534534000,
         "service": "gmail",
         "phone": "446576879809",
         "price": 0.21
     }
 }

Then to access id and phone number:=>

 data['data']['id'] # or 'phone'

answered Dec 22, 2020 at 16:22

Nanthakumar J J

9101 gold badge8 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to get a json value inside of another json in python?

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related