Parsing nested json payload python

Question

I am trying to get only value A from from this nested json payload.

My function:

import requests
import json
def payloaded():
from urllib.request import urlopen
with urlopen("www.example.com/payload.json") as r:
    data = json.loads(r.read().decode(r.headers.get_content_charset("utf-8")))
text = (data["bod"]["id"])
print(text)

The payload:

bod: {
id: [
    {
        value: "A",
        summary: "B",
        format: "C"
    }
  ]
},

Currently it is returning everything within the brackets [... value ... summary ... format ...]

Solution found:

def payloaded():
from urllib.request import urlopen
with urlopen("www.example.com/payload.json") as r:
    data = json.loads(r.read().decode(r.headers.get_content_charset("utf-8")))
text = (data["bod"]["id"][0]["value"])
print(text)

maxymoo · Accepted Answer · 2016-05-13 03:28:10Z

1

Since the id value is a list (even though it just contains a single value), you'll need to go inside it with a list indexer. Since lists in Python are zero-indexed (they start from zero) you'll use [0] to extract the first element:

data["bod"]["id"][0]["value"]

answered May 13, 2016 at 3:28

maxymoo

36.7k12 gold badges97 silver badges121 bronze badges

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

1 Comment

avorter Over a year ago

Thanks! I came to the same solution as you suggested.

avorter · Accepted Answer · 2016-05-13 04:05:03Z

0

This works:

def payloaded():
from urllib.request import urlopen
with urlopen("www.example.com/payload.json") as r:
    data = json.loads(r.read().decode(r.headers.get_content_charset("utf-8")))
text = (data["bod"]["id"][0]["value"])
print(text)

answered May 13, 2016 at 4:05

avorter

1191 gold badge2 silver badges10 bronze badges

Collectives™ on Stack Overflow

Parsing nested json payload python

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related