Read nested json data with python

Question

I'm trying to read all id's from below JSon data for all purchase orders. In below example there are just 2 id's (523fbc6c-359a-49ea-81ea-065e20e4b1db + 77a5e074-5b23-4f85-989d-1b8152982c6e). Any ideas how to achieve this?

Have tried some blogs and code snippets, but result yet :) Next example can be used:

json_data = {
        "purchaseOrder": [
            {
                "id": "523fbc6c-359a-49ea-81ea-065e20e4b1db",
                "installationNumber": "test",
                "peerId": "ac0fd195-cb24-4ced-a5fe-664a25651855",
                "validFrom": "2019-05-28T14:57:21.000+0000",
                "validTo": "2019-05-28T15:57:21.000+0000",
                "originalQuantity": 20,
                "quantity": 0,
                "price": 5,
                "periodInitial": "2019-05-28T15:00:00.000+0000",
                "periodFinal": "2019-05-28T16:00:00.000+0000"
            },
            {
                "id": "77a5e074-5b23-4f85-989d-1b8152982c6e",
                "installationNumber": "test",
                "peerId": "308866ba-90cb-47a7-8c73-589c0f355eb7",
                "validFrom": "2019-05-28T14:57:21.000+0000",
                "validTo": "2019-05-28T15:57:21.000+0000",
                "originalQuantity": 20,
                "quantity": 15,
                "price": 5,
                "periodInitial": "2019-05-28T15:00:00.000+0000",
                "periodFinal": "2019-05-28T16:00:00.000+0000"
            }
        ],
        "salesOrder": [
            {
                "id": "7113f1ee-6980-4447-bf71-75c93a4c5bad",
                "installationNumber": "test",
                "peerId": "308866ba-90cb-47a7-8c73-589c0f355eb7",
                "validFrom": "2019-05-28T14:57:21.000+0000",
                "validTo": "2019-05-28T15:57:21.000+0000",
                "originalQuantity": 20,
                "quantity": 0,
                "price": 5,
                "periodInitial": "2019-05-28T15:00:00.000+0000",
                "periodFinal": "2019-05-28T16:00:00.000+0000"
            }
        ],
        "agreement": [
            {
                "id": "e0f0ea4d4ecb357f443df720c457d8f20bcdc0b9d28b8eaa24a1b6bd80bd3ac50",
                "installationNumber": "test",
                "quantity": 15,
                "price": 5,
                "periodInitial": "2019-05-28T15:00:00.000+0000",
                "periodFinal": "2019-05-28T16:00:00.000+0000",
                "type": "A",
                "status": "",
                "agrPurchOrder": "523fbc6c-359a-49ea-81ea-065e20e4b1db",
                "agrSalesOrder": "7113f1ee-6980-4447-bf71-75c93a4c5bad",
                "creationDate": "2019-06-06T09:42:46.710+0000"
            },
            {
                "id": "e0f0ea4d4ecb357f443df720c457d8f20bcdc0b9d28b8eaa24a1b6bd80bd3ac51",
                "installationNumber": "test",
                "quantity": 5,
                "price": 5,
                "periodInitial": "2019-05-28T15:00:00.000+0000",
                "periodFinal": "2019-05-28T16:00:00.000+0000",
                "type": "A",
                "status": "",
                "agrPurchOrder": "77a5e074-5b23-4f85-989d-1b8152982c6e",
                "agrSalesOrder": "7113f1ee-6980-4447-bf71-75c93a4c5bad",
                "creationDate": "2019-06-06T09:42:46.711+0000"
            }
        ],
        "status": ""
    }

please show us your codes and we will comment on it. thanks. — jose_bacoy
– jose_bacoy, Commented Jun 6, 2019 at 14:09
purchase_ids = [entry['id'] for entry in json_data['purchaseOrder']] — balderman
– balderman, Commented Jun 6, 2019 at 14:18

jose_bacoy · Accepted Answer · 2019-06-06 14:17:25Z

1

Use comprehensions and it will collect all id in purchase order.

print([item['id'] for item in json_data['purchaseOrder']])

Result: ['523fbc6c-359a-49ea-81ea-065e20e4b1db', '77a5e074-5b23-4f85-989d-1b8152982c6e']

answered Jun 6, 2019 at 14:17

jose_bacoy

12.7k1 gold badge25 silver badges41 bronze badges

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

Comments

vurmux · Accepted Answer · 2019-06-06 14:17:18Z

1

Use list comprehensions:

result = [x['id'] for x in json_data['purchaseOrder']]

['523fbc6c-359a-49ea-81ea-065e20e4b1db',
 '77a5e074-5b23-4f85-989d-1b8152982c6e']

answered Jun 6, 2019 at 14:17

vurmux

10.1k3 gold badges30 silver badges49 bronze badges

Comments

Lahel Light · Accepted Answer · 2019-06-06 14:20:57Z

0

You can import the JSON data and loop through the "purchaseOrder" array and append the IDs of each element in an array.

answered Jun 6, 2019 at 14:20

Lahel Light

761 silver badge6 bronze badges

Comments

Kevin · Accepted Answer · 2019-06-06 15:36:15Z

0

Your json_data variable is not a json construct. It is a python dictionary. If you want to process it as json data, you first need to load it with the json module. You can change your variable to be a string of json data like below:

import json

json_data = '''
{
        "purchaseOrder": [
            {
                "id": "523fbc6c-359a-49ea-81ea-065e20e4b1db",
                "installationNumber": "test",
                "peerId": "ac0fd195-cb24-4ced-
...
}
'''

loaded_json = json.loads(json_data)
print(loaded_json['purchaseOrder']

You can then iterate through the loaded_json object and traverse it as a json object.

edited Jun 6, 2019 at 15:36

Kevin

18.8k8 gold badges71 silver badges86 bronze badges

answered Jun 6, 2019 at 14:29

Shane Parker

1

Collectives™ on Stack Overflow

Read nested json data with python

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related