How to select x level deep JSON data with Python

Question

I am trying to select data with python from what I believe is formatted in JSON. I am using this for loop to select the data as so.

for line_item in response['response']:
   print(line_item['name'] + ', ' + line_item['orderId'])

But how would I also select impressionsDelivered so the output is 1234?

(LineItem){
          orderId = 123456
          name = "fooname"
          stats = (Stats){
                    impressionsDelivered = 1234
                    clicksDelivered = 1234
                    }

I think it may be. I'm using the google API to pull data from DFP. — Artem Yevtushenko
– Artem Yevtushenko, Commented Feb 28, 2017 at 19:01
then print(line_item['stats']['impressionsDelivered']) should work or are you looking for a more generic way to do it? — YOBA
– YOBA, Commented Feb 28, 2017 at 19:04
@YOBA That worked great. Thanks! can you tell me why that worked? — Artem Yevtushenko
– Artem Yevtushenko, Commented Feb 28, 2017 at 19:12

YOBA · Accepted Answer · 2017-02-28 19:27:26Z

Let's say you have this json called response (to use your example):

response = {
          "response":    [   # start of a list of elements
                   {         # start of the 1st element
          "orderId" : 123456,
          "name" : "fooname",
          "stats" : {
                    "impressionsDelivered" : 1234,
                    "clicksDelivered" : 1234
                    }},      # end of the 1st element
                    {        # start of the 2nd element
          "orderId" : 1234565,
          "name" : "fooname2",
          "stats" : {
                    "impressionsDelivered" : 12345,
                    "clicksDelivered" : 12345
                    }}      # end of the second element
                          ] # end of the list
             }

A json is a dictionary like format with keys and values its written: {key:value}

and a value can be itself compose of keys and values example: key: {key2:value2} , {key2:value2} being the value of key

How to access them: You access a dictionary by the keys

in the json above, if I want to access all the values of response:

print( response["response"] )

if you want a deep access to the next element, which is orderId, notice the bracket opening '[' which tells you a list starts:

print( response["response"][0] ) # first element of the list
print( response["response"][0]["orderId"] ) # access orderId

You access a dictionary by its key and a list by its index

Tip: Use Ipython and paste this code to practice

RayLuo · Accepted Answer · 2017-02-28 19:01:17Z

0

This question has nothing to do with REST. Just grab your raw response (presumably in JSON format, as you indicated), and then paste it into any online json viewer, then you should be able to figure out how to navigate to the item you want.

answered Feb 28, 2017 at 19:01

RayLuo

19.6k6 gold badges93 silver badges80 bronze badges

Collectives™ on Stack Overflow

How to select x level deep JSON data with Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related