how do you extract data from json using python

Question

I have this json file:

{
  "entityId": "12345",
  "displayName": "hostabc",
  "toRelationships": {
    "isProcessOf": [
      {
        "id": "proce123D00BB86",
        "type": "PROCESS_GROUP_INSTANCE"
      },
      {
        "id": "proc678DD0DBA4",
        "type": "PROCESS_GROUP_INSTANCE"
      },
      {
        "id": "proc978DD0DBA4",
        "type": "PROCESS_GROUP_INSTANCE"
      }
      
    ]
  }
}

I need to extract id fields under isProcessOf and build a data list.

I am new to python, how would I do this?

Reading JSON from a file?

001
– 001

2022-01-12 21:13:16 +00:00
Commented Jan 12, 2022 at 21:13 — 001
– 001, Commented Jan 12, 2022 at 21:13

user7864386 · Accepted Answer · 2022-01-12 21:14:14Z

1

Looks like a list comprehension would do the job. You access dictionary values by its keys, so since you want to access 'id's of dictionaries in a list under the 'isProcessOf' key, which in turn is under the 'toRelationships' key, you can do it as:

out = [d['id'] for d in dct['toRelationships']['isProcessOf']]

Output:

['proce123D00BB86', 'proc678DD0DBA4', 'proc978DD0DBA4']

answered Jan 12, 2022 at 21:14

user7864386

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

Comments

Sascha Kirch · Accepted Answer · 2022-01-12 21:33:20Z

0

I would use the json package in python and then read the data using list comprehension:

import json
file_dir = "<YOUR_FILE_DIR>"
with open(file_dir ) as f:
    data = json.load(f)
id_list = [process['id'] for process in data['toRelationships']['isProcessOf']]

answered Jan 12, 2022 at 21:33

Sascha Kirch

5242 gold badges5 silver badges20 bronze badges

Collectives™ on Stack Overflow

how do you extract data from json using python

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related