Parse Json data

Question

a=  [{
    "data" : {
        "check": true,
    },
    "AMI": {
        "status": 1,
        "firewall":{
            "status": enable  
        },
        "d_suffix": "x.y.com",
        "id": 4
    },
    "tags": [  #Sometime tags could be like "tags":  ["default","auto"]
        "default"
    ],
    "hostname": "abc.com",   
}
]

How to get a hostname on the basis of tags?I am trying to implement it using

for i in a:
  if i['tags'] == 'default':
     output = i['hostname']

but it's failing because 'tags' is a list which is not mapping to hostname key.Is there any way i can get hostname on the basis of 'tags'?

Barmar · Accepted Answer · 2017-03-30 22:55:44Z

1

Use in to test if something is in a list. You also need to put default in quotes to make it a string.

for i in a:
    if 'default' in i['tags']:
        output = i['hostname']
        break

If you only need to find one match, you should break out of the loop once you find it.

If you need to find multiple matches, use @phihag's answer with the list comprehension.

answered Mar 30, 2017 at 22:55

Barmar

789k57 gold badges554 silver badges668 bronze badges

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

4 Comments

techno Over a year ago

I tried this thing earlier but thing is this way it can find the tags with default but instead of returning hostname associated with the 'default' tag it returns first 'hostname' value in the dic.

techno Over a year ago

I tried this thing earlier but thing is this way it can find the tags with default but instead of returning hostname associated with the 'default' tag it returns the 'hostname' value associated with "tags" : [ 'default', 'auto']

Barmar Over a year ago

If tags are ['default', 'auto'] then it's the default, isn't it? You only want to match it if default is the only tag?

Barmar Over a year ago

You can use if len(i['tags']) == 1 and i['tags'][0] == 'default':

phihag · Accepted Answer · 2017-03-30 23:13:15Z

1

To get all hostnames tagged as default, use a list comprehension:

def_hostnames = [i['hostname'] for i in a if 'default' in i['tags']]
print('Default hostnames: %s' % ','.join(def_hostnames))

If you only want the first hit, either use def_hostnames[0] or the equivalent generator expression:

print('first: %s' % next(i['hostname'] for i in a if 'default' in i['tags']))

Your current code fails because it uses default, which is a variable named default. You want to look for a string default.

edited Mar 30, 2017 at 23:13

answered Mar 30, 2017 at 22:54

phihag

289k75 gold badges473 silver badges488 bronze badges

2 Comments

techno Over a year ago

I added some more info and fixed the 'default' string .Thing is I only want one hostname associated with the 'default' tag .

phihag Over a year ago

@techno I have amended the answer with the equivalent generator expression which only gets the first hit.

Avinash Bakshi · Accepted Answer · 2017-03-30 23:03:00Z

Make sure that you have everything in Json format like

a=  [{
    "data" : {
        "check": True,
    },
    "AMI": {
        "status": 1,
        "firewall":{
            "status": "enable"  
        },
        "d_suffix": "x.y.com",
        "id": 4
    },
    "tags": [
        "default"
    ],
    "hostname": "abc.com",   
}
]

and then you can easily get it by using in

for i in a:
    if 'default' in i['tags']:
        output = i['hostname']

Collectives™ on Stack Overflow

Parse Json data

3 Answers 3

4 Comments

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

2 Comments

Comments

Related