How to parse JSON data in python and Django

[Salima Begum]

Hi all,

From below json data to parse this data to fetch categoryId and categoryName in four levels of data I used for loop for fetching data and inserting into database table. Is there any better way to do this in python and Django?

Please Help me to achieve this. Let me know if you have any suggestions.

```

response = requests.request("GET", url, headers=headers_name, data=payload)
    response.json()
    json_encoded_e = json.dumps(response.json(), indent=4)
    json_decode_e = json.loads(json_encoded_e)
    categoryTreeId = json_decode_e["categoryTreeId"]
    categoryTreeVersion = json_decode_e["categoryTreeVersion"]
    rootCategoryNode = json_decode_e["rootCategoryNode"]
    json_encoded_e1 = json.dumps(rootCategoryNode, indent=4)
    json_decode_e1 = json.loads(json_encoded_e1)
    category_1 = json_decode_e1["childCategoryTreeNodes"]
    for i in category_1:
        cat_id = i['category']['categoryId']
        cat_name = i['category']['categoryName']
        category_child = i['childCategoryTreeNodes']
        saveForm = Some_data_table(categoryTreeId=categoryTreeId,
                                    categoryTreeVersion=categoryTreeVersion,
                                    categoryId=cat_id, categoryName=cat_name,
                                    parent_id=cat_id, parent_name=cat_name,
                                    )
        saveForm.save()
        for child in category_child:
            cat_ch_id = child['category']['categoryId']
            cat_ch_name = child['category']['categoryName']
            saveForm = Some_data_table(categoryTreeId=categoryTreeId,
                                        categoryTreeVersion=categoryTreeVersion,
                                        categoryId=cat_ch_id, categoryName=cat_ch_name,
                                        parent_id=cat_id, parent_name=cat_name,
                                        )
            saveForm.save()
            if 'childCategoryTreeNodes' in child:
                cat_subch= child['childCategoryTreeNodes']
                for subch in cat_subch:
                    cat_subch_id = subch['category']['categoryId']
                    cat_subch_name = subch['category']['categoryName']
                    saveForm = Some_data_table(categoryTreeId=categoryTreeId,
                                                categoryTreeVersion=categoryTreeVersion,
                                                categoryId=cat_subch_id, categoryName=cat_subch_name,
                                                parent_id=cat_ch_id, parent_name=cat_ch_name,
                                                )
                    saveForm.save()
                    if 'childCategoryTreeNodes' in subch:
                        cat_subch_subch = subch['childCategoryTreeNodes']
                        for subch_subch in cat_subch_subch:
                            cat_subch_subch_id = subch_subch['category']['categoryId']
                            cat_subch_subch_name = subch_subch['category']['categoryName']
                            saveForm = Some_data_table(categoryTreeId=categoryTreeId,
                                                        categoryTreeVersion=categoryTreeVersion,
                                                        categoryId=cat_subch_subch_id,
                                                        categoryName=cat_subch_subch_name,
                                                        parent_id=cat_subch_id, parent_name=cat_subch_name,
                                                        )
                            saveForm.save()

                    else:
                        continue
            else:
                continue

```

```

{'categoryTreeId': '0',
 'categoryTreeVersion': 'some',
 'rootCategoryNode': {'category': {'categoryId': '0', 'categoryName': 'Root'},
 'childCategoryTreeNodes':
 [{'category': {'categoryId': '1', 'categoryName': 'Collectibles'},
'parentCategoryTreeNodeHref': 'https://api.example.com/',
'childCategoryTreeNodes':
[{'category': {'categoryId': '34', 'categoryName': 'Advertising'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=1',
'childCategoryTreeNodes':
[{'category': {'categoryId': '36', 'categoryName': 'Soda'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=34',
'childCategoryTreeNodes':
[{'category': {'categoryId': '852', 'categoryName': 'Fountain'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=36',
'categoryTreeNodeLevel': 4, 'leafCategoryTreeNode': True},
{'category': {'categoryId': '853', 'categoryName': 'Canada Dry'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=36',
'categoryTreeNodeLevel': 4, 'leafCategoryTreeNode': True},
{'category': {'categoryId': '855', 'categoryName': '7 UP'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=36',
'categoryTreeNodeLevel': 4, 'leafCategoryTreeNode': True},
{'category': {'categoryId': '856', 'categoryName': 'Squirt'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=36',
'categoryTreeNodeLevel': 4, 'leafCategoryTreeNode': True},
{'category': {'categoryId': '857', 'categoryName': 'Hires Root Beer'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=36',
'categoryTreeNodeLevel': 4, 'leafCategoryTreeNode': True},
{'category': {'categoryId': '877', 'categoryName': 'Dr Pepper'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=36',
'categoryTreeNodeLevel': 4, 'leafCategoryTreeNode': True},
{'category': {'categoryId': '1334', 'categoryName': 'Moxie'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=36',
'categoryTreeNodeLevel': 4, 'leafCategoryTreeNode': True},
{'category': {'categoryId': '3897', 'categoryName': 'Schweppes'},
'parentCategoryTreeNodeHref': 'https://api.example.com/category_id=36',
'categoryTreeNodeLevel': 4,
'leafCategoryTreeNode': True},
-----------------------------------------------------------------
-------------------------------------------------------------------
------------------------------------------------------------------
```

Thanks

~Salima