CODEWITHSUNDEEP
pythonjson
Dev Ops
Dev Ops

Reputation: 127

loop through nested dictionary in python

I wish to loop through the following json dictionary:

hgetjsonObject = {
    u 'jsonrpc': u '2.0', u 'result': [{
        u 'hosts': [{
            u 'status': u '0',
            u 'hostid': u '10394',
            u 'name': u 'vsclap01l'
        }, {
            u 'status': u '0',
            u 'hostid': u '10395',
            u 'name': u 'vsclap03l'
        }, {
            u 'status': u '0',
            u 'hostid': u '10396',
            u 'name': u 'vscldb04l'
        }],
        u 'groupid': u '4',
        u 'name': u 'Zabbix servers'
    }], u 'id': 2
}

Here is what I have tried so far:

print(hgetjsonObject['result'][0]['hosts'][0])

But when I run it, it aborts with the following:

{u'status': u'0', u'hostid': u'10394', u'name': u'vsclap01l'}
Traceback (most recent call last):
  File "./automaton.py", line 341, in <module>
    print(hgetjsonObject['result'][0]['hosts'][0])
IndexError: list index out of range

I want to be able to do something like this:

for eachhost in hgjsonObject['result']:
    print(eachhost['hostid'],eachhost['name'])

When I run the for loop, I get errors.

Upvotes: 0

Views: 80

Answers (2)

Taj Uddin
Taj Uddin

Reputation: 523

I see two problems. 1) there is space between u an field in your dictionary which will cause issue.

2) because result is a list and under that hosts is another list, you should iterate through both the lists 

for eachresult in hgetjsonObject['result']:
         for eachhost in eachresult['hosts']:
             print(eachhost['hostid'],eachhost['name'])

Output:

10394 vsclap01l 10395 vsclap03l 10396 vscldb04l

Upvotes: 1

Mojtaba Kamyabi
Mojtaba Kamyabi

Reputation: 3600

for access to hosts key iterate in this way:

>>> for eachhost in hgetjsonObject['result'][0]['hosts']:
        print(eachhost["hostid"], eachhost["name"])

('10394', 'vsclap01l')
('10395', 'vsclap03l')
('10396', 'vscldb04l')

Upvotes: 0

Related Questions