Parsing nested JSON data within keys

Question

I'm trying to parse nested JSON data. I'm trying to get the 'DisplayValue' for each key, my code is

json_obj = r.json()
for result in json_obj["Result"]:
    for employeeid in result["EmployeeId"]:
        cursor.execute("INSERT INTO employee_detail (EmployeeId) VALUES (%s)",
                       (result["DisplayValue"]))

However I get the response

KeyError 'DisplayValue'

JSON output

{
"IsError": "false",
"Status": 0,
"Message": "string",
"Result": [
    {
        "EmployeeId": {
        "DisplayValue": "PW180",
        "FieldHistory": []
        },

        "Title": {
        "DisplayValue": "Mr.",
        "FieldHistory": []
        },

Thanks :)

You don't need the second for loop just use result['EmployeeId']['DisplayValue'] — Kostas Charitidis
– Kostas Charitidis, Commented Sep 18, 2019 at 8:25

Rakesh · Accepted Answer · 2019-09-18 08:21:01Z

1

You have a nested dictionary.

Use:

json_obj = r.json()
for result in json_obj["Result"]:
    cursor.execute("INSERT INTO employee_detail (EmployeeId) VALUES (%s)",
                       (result['EmployeeId']["DisplayValue"],))

answered Sep 18, 2019 at 8:21

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

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

Collectives™ on Stack Overflow

Parsing nested JSON data within keys

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related