Accessing nested value in loop in json using python

Question

I want to fetch the value of each api3 in this json object where each array has api3 value.

 {
    "count": 10,
    "result": [
    {
            "type": "year",
            "year": {
                "month": {
                    "api1": {
                        "href": "https://Ap1.com"
                    },
                    "api2": {
                        "href": "FETCH-CONTENT"
                    },
                    "api3": {
                        "href": "https://Ap3.com"
                    },
                    "api4": {
                        "href": "https://Ap4.com"
                    }
                },
                "id": "sdvnkjsnvj",
                "summary": "summeryc",
                "type": "REST",
                "apiId": "mlksmfmksdfs",
                "idProvider": {
                    "id": "sfsmkfmskf",
                    "name": "Apikey"
                },
                "tags": []
            }
        },
        {
            "type": "year1",
            "year": {
                "month": {
                    "api1": {
                        "href": "https://Ap11.com"
                    },
                    "api2": {
                        "href": "FETCH-CONTENT-1"
                    },
                    "api3": {
                        "href": "https://Ap13.com"
                    },
                    "api4": {
                        "href": "https://Ap14.com"
                    }
                },
                "id": "sdvnkjsnvj",
                "summary": "summeryc",
                "type": "REST",
                "apiId": "mlksmfmksdfs",
                "idProvider": {
                    "id": "sfsmkfmskf",
                    "name": "Apikey"
                },
                "tags": []
            }
        },

I am able to get the whole json object and first value inside it.

with open('C:\python\examplee.json','r+') as fr:
data = json.load(fr)
print(data["result"])

Thank you in advance for helping me figuring this.

print([i["year"]["month"]["api3"]["href"] for i in data["result"]])? — Rakesh
– Rakesh, Commented May 13, 2019 at 13:42
You just need to choose the correct indexes and keys to deal with @RJ_Singh check my answer below :) — Devesh Kumar Singh
– Devesh Kumar Singh, Commented May 13, 2019 at 14:03

Devesh Kumar Singh · Accepted Answer · 2019-05-13 13:43:24Z

1

For each element in list of result key, get the value for the nested dictionary within item

print([item['year']['month']['api3'] for item in data['result']])

The output will be [{'href': 'https://Ap3.com'}, {'href': 'https://Ap13.com'}]

Or if you want to get the href value as well

print([item['year']['month']['api3']['href'] for item in data['result']])

The output will be

['https://Ap3.com', 'https://Ap13.com']

So your whole code will look like

data = {}
with open('C:\python\examplee.json','r+') as fr:
    data = json.load(fr)

print([item['year']['month']['api3']['href'] for item in dct['result']])

answered May 13, 2019 at 13:43

Devesh Kumar Singh

20.5k5 gold badges25 silver badges43 bronze badges

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

6 Comments

RJ_Singh Over a year ago

Thanks @Devesh.. But it is not working i tried putting multiple combination to get the href option but no luck so far.

RJ_Singh Over a year ago

Your solution works absolutely fine @Devesh with the json provided in the question.Now i am facing difficulty because there is slight changes in my json file. All fields are same in all the elements except one of the fields doesn't match.That is why it is not working.

RJ_Singh Over a year ago

Absolutely @Devesh Thanks a bunch ..:)

RJ_Singh Over a year ago

But what would be the approach if we have json file with the same file content and one element is having different field.

RJ_Singh Over a year ago

Let us continue this discussion in chat.

|

vurmux · Accepted Answer · 2019-05-13 13:39:47Z

1

Looks like your JSON schema is static so you can just use this:

print([x['year']['month']['api3']['href'] for x in data['result']])

will return you:

['https://Ap3.com', 'https://Ap13.com']

answered May 13, 2019 at 13:39

vurmux

10.1k3 gold badges30 silver badges49 bronze badges

Collectives™ on Stack Overflow

Accessing nested value in loop in json using python

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related