access to json values using python

Question

I have my JSON file:

[
   {
      "order_":{
         "id":"B2B78502",
         "status_order_id":5,
         "status_order_name":"Sent",
         "customer_id":256,
         "order_products":[
            {
               "order_product":{
                  "id":83630,
                  "order_id":79288,
                  "product_id":13519,
                  "quantity":"1.0",
                  "price":"72.44",
                  "addressbook_":{
                     "name":"user user",
                     "address":"adress",
                     "city":"THIENNES",
                     "country":"FR",
                     "postal_code":"59189",
                     "phone":"000000000"
                  },
                  "product_name":"product",
                  "product_code":"20159"
               }
            }
         ],
         "customer_email":"[email protected]",
         "customer_company":"SARL"
      }
   }
]

I want to insert data into a MySQL table, but I can not access all the values

here is my code:

json_obj = r.json()

for ord in json_obj:
    print("id:", ord["order"]["id"])
    print("order_produvt_id:", ord["order"]["order_products"]"order_product"]["id"])
    print('---')

I want to access all the data I want to access all the data but I get this error :

  id: B2B78588
    print("order_product_id:", ord["order"]["order_products"]["order_product"]["id"])
TypeError: list indices must be integers or slices, not str

That's not JSON.

Sookie Singh
– Sookie Singh

2018-08-03 13:43:39 +00:00
Commented Aug 3, 2018 at 13:43 — Sookie Singh
– Sookie Singh, Commented Aug 3, 2018 at 13:43
and check this link.

Sookie Singh
– Sookie Singh

2018-08-03 13:46:21 +00:00
Commented Aug 3, 2018 at 13:46 — Sookie Singh
– Sookie Singh, Commented Aug 3, 2018 at 13:46
it's a JSON recover from an API

user_1330
– user_1330

2018-08-03 13:48:51 +00:00
Commented Aug 3, 2018 at 13:48 — user_1330
– user_1330, Commented Aug 3, 2018 at 13:48

Spiderbro · Accepted Answer · 2018-08-03 13:52:47Z

1

In side "order_products", you have an array, indicated by these braces: [ ].

You need to access arrays with Integers, like the error tells you.

ord["order"]["order_products"][0]["order_product"]["id"]

The above example should work.

edited Aug 3, 2018 at 13:52

answered Aug 3, 2018 at 13:41

Spiderbro

3702 silver badges10 bronze badges

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

2 Comments

user_1330 Over a year ago

yes you are right thank you, I did not pay attention that it is an array, I tried your code, I get this error: KeyError: 'id'

Spiderbro Over a year ago

Edited my answer. I missed that "id" was in the "order_product" object

Collectives™ on Stack Overflow

access to json values using python

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related