Getting specific field values from a JSON using Python [duplicate]

Question

I am pulling out a collection of devices that are downed on our network.

I am running:

rjson = r.json()
print(json.dumps(rjson, indent = 5))

And it returns:

{
     "paging": {
          "size": 13
     },
     "data": {
          "devices": [
               {
                    "hostName": "host_1",
                    "networkAddress": "111.111.111.111",
                    "bestState": "Down",
                    "worstState": "Down",
               },
               {
                    "hostName": "host_2",
                    "networkAddress": "111.111.111.111",
                    "bestState": "Down",
                    "worstState": "Down",
               },
               {
                    "hostName": "host_3",
                    "networkAddress": "111.111.111.111",
                    "bestState": "Down",
                    "worstState": "Down",
               },

I would like to run though this json and create a list with each hostName that is returned. How would I do this?

As a new user, start with the tour and read How to Ask. Concerning your task, decode the JSON and extract the relevant info from the data. — Ulrich Eckhardt
– Ulrich Eckhardt, Commented Oct 25, 2019 at 21:04

kederrac · Accepted Answer · 2019-10-25 21:05:57Z

1

you can try:

from operator import itemgetter

host_names = list(map(itemgetter('hostName'), rjson['data']['devices']))

print(host_names)

output:

['host_1', 'host_2', 'host_3']

answered Oct 25, 2019 at 21:05

kederrac

17.4k6 gold badges36 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

Getting specific field values from a JSON using Python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related