How to loop through JSON items and JSON subitems

Question

I have the following JSON input

{
    "requestId": "453sdafwa234",
    "result": [
        {
            "seq": 0,
            "GUID": "081119bd-63a8-42ca-85de-5b4761234955",
            "amount": 1234,
            "externalId": "1234567890",
            "Status": "OK"
        },
        {
            "seq": 1,
            "GUID": "011119bd-42ca-63a8-85de-5b47111a8955",
            "amount": 5678,
            "externalId": "2345678901",
            "Status": "OK"
        }]
}

I want to loop through all result and then output the externalId key value.

I tried

json_op = json.loads(json_string)

for op in json_op:
    for r in op["result"]:
      print r["externalId"]

which did not work.

I also tried

json_op = json.loads(json_string)

for op in json_op:
    r.get["result"].get["externalId"]

But this also didnt work. What is the right way?

Your json has duplicate keys and once you load this into python as a dict only the last (result) is kept. — zipa
– zipa, Commented Oct 11, 2018 at 8:34
for data in s['result']: print(data['externalId']).. s being the json — iamklaus
– iamklaus, Commented Oct 11, 2018 at 8:37
Once the json string parsed using json.loads(), what you have is a plain python dict (where on of the keys maps to a python list of python dicts). The fact it's been built from a json string is totally irrelevant, it's just plain python dicts and lists, both types being fairly well documented. — bruno desthuilliers
– bruno desthuilliers, Commented Oct 11, 2018 at 9:10

U13-Forward · Accepted Answer · 2018-10-11 08:42:05Z

2

Then why not list comprehension:

print([i["externalId"] for i in json_op["result"]])

Or want formatted:

print('\n'.join([i["externalId"] for i in json_op["result"]]))

answered Oct 11, 2018 at 8:42

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

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

Comments

Iker Ocio Zuazo · Accepted Answer · 2018-10-11 08:38:18Z

1

Ok. First of all you have to import json lib at the beginning of your code.

Then, you are not iterating properly your dictionary object.

If you want to read your requestId key, just write

print(json_op['requestId'])

For iterating results:

json_op = json.loads(s)

print(json_op['requestId'])

for res in json_op['result']:
    print(res['seq'])
    print(res['GUID'])
    print(res['amount'])
    ...

Try and tell me something. I cannot run the code now.

answered Oct 11, 2018 at 8:38

Iker Ocio Zuazo

3515 silver badges14 bronze badges

Comments

Ashutosh Chapagain · Accepted Answer · 2018-10-11 08:39:07Z

1

for i in json_op["result"]:
    print (i["externalId"])

This works.

answered Oct 11, 2018 at 8:39

Ashutosh Chapagain

9269 silver badges15 bronze badges

Comments

Mike Scotty · Accepted Answer · 2018-10-11 08:39:10Z

1

import json

s = """{
    "requestId": "453sdafwa234",
    "result": [
        {
            "seq": 0,
            "GUID": "081119bd-63a8-42ca-85de-5b4761234955",
            "amount": 1234,
            "externalId": "1234567890",
            "Status": "OK"
        },
        {
            "seq": 1,
            "GUID": "011119bd-42ca-63a8-85de-5b47111a8955",
            "amount": 5678,
            "externalId": "2345678901",
            "Status": "OK"
        }]
}"""

json_op = json.loads(s)

for item in json_op['result']:
    print(item['externalId'])

Output:

1234567890
2345678901

answered Oct 11, 2018 at 8:39

Mike Scotty

10.8k5 gold badges41 silver badges52 bronze badges

Collectives™ on Stack Overflow

How to loop through JSON items and JSON subitems

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related