Extracting multiple fields from json output

Question

Hi folks im new to asking questions in stack but I want to know what is the process in order to remove the 'name' value from the json output below i know how to get the individual names through indexingname = [groups['groups'][0]['name'] for groups in result] but how do i get both names

from pyzabbix import ZabbixAPI

import json

z = ZabbixAPI(url='https://zabbix.server,user='xxxx',password='xxxx')
result = z.host.get(output='groupid',selectGroups='extend', filter={'host' : 'mailpphfprd01'})


name = [groups['groups'] for groups in result]

name

Json Output:

[[{u'flags': u'0',
   u'groupid': u'110',
   u'internal': u'0',
   u'name': u'- GSOC - Systems'},
  {u'flags': u'0',
   u'groupid': u'313',
   u'internal': u'0',
   u'name': u'Applications - Email Digest'}]]

Required output

[u'- GSOC - Systems' u'Applications - Email Digest']

martineau · Accepted Answer · 2016-05-31 19:00:31Z

1

You should be able to do it with a list-comprehension:

json_output = [
  [
    {
      "internal": "0",
      "flags": "0",
      "groupid": "110",
      "name": "- GSOC - Systems"
    },
    {
      "internal": "0",
      "flags": "0",
      "groupid": "313",
      "name": "Applications - Email Digest"
    }
  ]
]

names = [d['name'] for d in json_output[0]]

print(names)  # -> [u'- GSOC - Systems', u'Applications - Email Digest']

edited May 31, 2016 at 19:00

answered May 31, 2016 at 16:20

martineau

124k29 gold badges181 silver badges319 bronze badges

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

2 Comments

ryans11 Over a year ago

json_output[0] why is the index placed here is it to represent the internal []

martineau Over a year ago

The json output is a list of a list of dictionaries, so I just hardcoded the index of the first entry in the outer list — in other words, json_output[0] is the first (and only) entry of that outermost list.

Collectives™ on Stack Overflow

Extracting multiple fields from json output

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related