How to access values in deeply nested json

Question

I'm having a file that is deeply nested and wondering how I can access the values for Product (details, color, size, material).

  {
     "article": [

      {
       "product":{
        "details": {
        "color": "blue",
        "size": "small",
        "material": "cotton"
        }
      },
      "availability": "in stock",
      "sku": "2317",
      "cost": "$23"
      },
     {
     "product":{
        "details": {
        "color": "red",
        "size": "large",
        "material": "plastic"
        }
     },
     "availability": "no stock",
     "sku": "4342",
     "cost": "$44"
     }
     ],

   "IDs":[
  {
   "name": "Manager",
   "batchID": 3312312
  }
 ]
}

My goal is to iterate over the values for each product using python.

Thank you in advance

to deep searching in json, you need to iterate it recursively , see this link -> https://stackoverflow.com/questions/10756427/loop-through-all-nested-dictionary-values — Gautam Jangid, Dec 08 '21 at 15:57

score 0 · Answer 1 · answered Dec 08 '21 at 15:53

You can do something like this


mydict =   {
     "article": [

      {
       "product":{
        "details": {
        "color": "blue",
        "size": "small",
        "material": "cotton"
        }
      },
      "availability": "in stock",
      "sku": "2317",
      "cost": "$23"
      },
     {
     "product":{
        "details": {
        "color": "red",
        "size": "large",
        "material": "plastic"
        }
     },
     "availability": "no stock",
     "sku": "4342",
     "cost": "$44"
     }
     ],

   "IDs":[
  {
   "name": "Manager",
   "batchID": 3312312
  }
 ]
}

for item in mydict['article']:
    print(item['product'])

Is this what you wanted?

score 0 · Accepted Answer · answered Dec 08 '21 at 15:55

0

This will give you the list of products

products = [ item['product'] for item in data['articles']]

answered Dec 08 '21 at 15:55

Shashikamal R C

512
3
8

score 0 · Answer 3 · answered Dec 08 '21 at 16:09

I've put your JSON into JSONPath, and after small trial and error it is evident that you need this JSONPath to access the fields:

$.article[*].product.details

Loop through the array using something like that (sorry, don't have a python env to check properly):

import json

json_data= json.dumps("your_json")

items = json.loads(json_data)
for i in range(0, len(items['article'])):
   print items['article'][i]['product']['details']

How to access values in deeply nested json

3 Answers3