How to parse nested JSON in python

Question

I'm struggling to access some values in this nested json in python.

How can I access this ['Records'][0]['s3']['bucket']['name'] ? I did search a lot to find a simple python snippet, but no luck. Thanks in advance!

{
  "Records": [
    {
      "eventName": "xxxxxxx",
      "userIdentity": {
        "principalId": "AWS:XXXXXXXXXXXXXX"
      },
      "requestParameters": {
        "sourceIPAddress": "XX.XX.XX.XX"
      },
      "responseElements": {
        "x-amz-request-id": "8CXXXXXXXXXXHRQX",
        "x-amz-id-2": "doZ3+gxxxxxxx"
      },
      "s3": {
        "s3SchemaVersion": "1.0",
        "configurationId": "X-Event",
        "bucket": {
          "name": "bucket-name",
          "ownerIdentity": {
            "principalId": "xxxxxxx"
          },
          "arn": "arn:aws:s3:::bucket-name"
        },
        "object": {
          "key": "object.png",
          "sequencer": "0060XXXXXXX75X"
        }
      }
    }
  ]
}

Actually, I made a library for this a little while ago: QueryTree. It makes writing to deeply nested structures and converting them between formats. But if you are just trying to read that value, you already did it. The snipet you gave will work. Just parse the json first with the built-in json library — QuinnF
– QuinnF, Commented Apr 5, 2021 at 2:54
@cosmos-1905-14 I'm not sure exactly what you mean by nested but both the links I gave can absolutely handle the JSON structure in your question — QuinnF
– QuinnF, Commented Apr 5, 2021 at 2:58

Supreme1707 · Accepted Answer · 2021-04-05 02:57:32Z

2

Since this is a string, use the json.loads method from the inbuilt JSON library.

import json

json_string = # your json string
parsed_string = json.loads(json_string)
print(parsed_string) # it will be a python dict
print(parsed_string['Records'][0]['s3']['bucket']['name']) # prints the string

answered Apr 5, 2021 at 2:57

Supreme1707

1781 silver badge8 bronze badges

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

Comments

mochsner · Accepted Answer · 2021-04-05 02:57:34Z

Have you tried running your example? If you're loading the json from elsewhere, you'd need to convert it to this native dictionary object using the json library (as mentioned by others, json.loads(data))

kv = {
  "Records": [
    {
      "eventName": "xxxxxxx",
      "userIdentity": {
        "principalId": "AWS:XXXXXXXXXXXXXX"
      },
      "requestParameters": {
        "sourceIPAddress": "XX.XX.XX.XX"
      },
      "responseElements": {
        "x-amz-request-id": "8CXXXXXXXXXXHRQX",
        "x-amz-id-2": "doZ3+gxxxxxxx"
      },
      "s3": {
        "s3SchemaVersion": "1.0",
        "configurationId": "X-Event",
        "bucket": {
          "name": "bucket-name",
          "ownerIdentity": {
            "principalId": "xxxxxxx"
          },
          "arn": "arn:aws:s3:::bucket-name"
        },
        "object": {
          "key": "object.png",
          "sequencer": "0060XXXXXXX75X"
        }
      }
    }
  ]
}

print("RESULT:",kv['Records'][0]['s3']['bucket']['name'])

RESULT: bucket-name

Collectives™ on Stack Overflow

How to parse nested JSON in python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related