Iterate over JSON Object using Python

Question

I have a JSON object and was wondering how I can iterate over the object to pull values for "id".

{
"totalSize": 5,
"done": true,
"records": [
    {
        "attributes": {
            "type": "EventLogFile",
            "url": "/services/data/v38.0/sobjects/EventLogFile/0AT1U000003kk7dWAA"
        },
        "Id": "0AT1U000003kk7dWAA"
    },
    {
        "attributes": {
            "type": "EventLogFile",
            "url": "/services/data/v38.0/sobjects/EventLogFile/0AT1U000003kk7eWAA"
        },
        "Id": "0AT1U000003kk7eWAA"

I was trying something below.

sub_data = s["records"]["id"]
for i in sub_data:
        print(sub_data['id'])

blhsing · Accepted Answer · 2018-12-11 17:45:07Z

2

You can iterate through the records key as a list and then access the Id key of each sub-dict:

for i in s["records"]:
    print(i['Id'])

answered Dec 11, 2018 at 17:45

blhsing

109k9 gold badges88 silver badges132 bronze badges

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

2 Comments

Maestro Over a year ago

Thanks!. I did try that and received following errorr: for i in s["records"]: TypeError: string indices must be integers, not str

blhsing Over a year ago

Glad to be of help. Can you mark this answer as accepted if you find it to be correct? (Click on the grey check mark next to the answer.)

caverac · Accepted Answer · 2018-12-11 19:47:25Z

0

s = """{ "totalSize": 5, 
        "done": true, "records": [ 
            { "attributes": { 
                "type": "EventLogFile", 
                "url": "/services/data/v38.0/sobjects/EventLogFile/0AT1U000003kk7dWAA" }, 
                "Id": "0AT1U000003kk7dWAA" } 
        ] 
    }"""
s = json.loads(s)

[r['Id'] for r in s['records']]

['0AT1U000003kk7dWAA']

edited Dec 11, 2018 at 19:47

answered Dec 11, 2018 at 17:44

caverac

1,7072 gold badges16 silver badges23 bronze badges

6 Comments

Maestro Over a year ago

Your solutions seem right. Just iterate over list of dictionary.Guess, I still get the same error. s1 = [r['id'] for r in s['records']] TypeError: string indices must be integers, not str

caverac Over a year ago

@AshishLal can you add the JSON that triggers this error?

Maestro Over a year ago

{ "totalSize": 5, "done": true, "records": [ { "attributes": { "type": "EventLogFile", "url": "/services/data/v38.0/sobjects/EventLogFile/0AT1U000003kk7dWAA" }, "Id": "0AT1U000003kk7dWAA" }, ] }

caverac Over a year ago

It works for me [r['Id'] for r in s['records']] the result is ['0AT1U000003kk7dWAA']

Maestro Over a year ago

I am sure it works. Not sure why its not working for me

|

Collectives™ on Stack Overflow

Iterate over JSON Object using Python

2 Answers 2

2 Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related