How do you reference nested JSON data directly?

Question

I'm calling up a lot of data through an API, and it's nested within many layers. I want to be able to reference pieces easily, with bracket notation ideally.

Right now, I'm pulling the data and it comes out like this:

   {
    'status': 'success', 
    'data': 
          {
           'available_balance': '0.1515', 
           'pending_withdrawals': '0.0000', 
           'withdrawable_balance': '0.1515', 
           'couponable_balance': '0.0000'
          }
    }

I can do balance["data"] which then outputs:

   {
    'available_balance': '0.1515', 
    'pending_withdrawals': '0.0000', 
    'withdrawable_balance': '0.1515', 
    'couponable_balance': '0.0000'
   }

But what I want is to do something like balance["data"["available_balance"]] and get:

0.1515

Have you tried balance["data"]["available_balance"] ?

Stephen C
– Stephen C

2019-08-18 04:17:24 +00:00
Commented Aug 18, 2019 at 4:17 — Stephen C
– Stephen C, Commented Aug 18, 2019 at 4:17

PySaad · Accepted Answer · 2019-08-18 07:25:14Z

3

Try below code:

balance['data']['available_balance']

JSON is loaded as nested dictionaries in python.

edited Aug 18, 2019 at 7:25

PySaad

1,06916 silver badges27 bronze badges

answered Aug 18, 2019 at 4:18

Moshel

4285 silver badges13 bronze badges

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

2 Comments

Teddy Over a year ago

Thank you, this worked, but if I were to have two different labels both named 'available_balance', how would I tell the program which to pick?

FishMonkey Over a year ago

Well, there wouldn't be two 'available_balance' in the same scope, that doesn' t make much sense. Generally, we'd iterate over indexes in 'data' so we'd do something like: balance['data'][0]['available_balance'] , balance['data'][1]['available_balance'], balance['data'][2]['available_balance'], etc

Collectives™ on Stack Overflow

How do you reference nested JSON data directly?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related