recurse through json in python

Question

I have a sample json:

I want to use the json module of python and recurse through to find the "MaxSize" in "pevcwebasg". Have the following code:

import json

param_file_handle = json.load(open("sample.json"))
print param_file_handle['Resources']['pevcwebasg']['Type']
resources = param_file_handle['Resources']
for asg in resources:
     print asg["Type"]

The out put of which is :

> AWS::AutoScaling::AutoScalingGroup Traceback (most recent call last): 
> File "test.py", line 8, in <module>
>     print asg['Type'] TypeError: string indices must be integers

What I dont get is this line "print param_file_handle['Resources']['pevcwebasg']['Type']" works fine and gets me the output but when i recurse through and try and find asg["Type"], it fails. Any better way to do this ? I need to recurse through the tree and find the value.

Edit 1:

as I do recurse through values, I get stuck with error.

param_file_handle = json.load(open("sample.json"))
resources = param_file_handle['Resources']
for asg in resources.values():
     if asg["Type"] == "AWS::AutoScaling::AutoScalingGroup":
          for values in asg['Properties']:
              print values["MaxSize"]

error :

Traceback (most recent call last):
  File "test.py", line 9, in <module>
    print values["MaxSize"]
TypeError: string indices must be integers

it was a huge json, didn't want it to take the whole space so just used the pic. I know I could have trimmed it. Will do. — Scooby
– Scooby, Commented Dec 23, 2015 at 14:30

Kevin · Accepted Answer · 2015-12-23 14:20:51Z

3

for asg in resources:

This iterates through the keys of resources, rather than the values. Try:

for asg in resources.values():

answered Dec 23, 2015 at 14:20

Kevin

76.5k13 gold badges141 silver badges168 bronze badges

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

3 Comments

rajesh.kanakabandi Over a year ago

I would do keys() instead of values() so you have the option to reproduce the content of the key which meets your Criteria.

Scooby Over a year ago

@rajesh.kanakabandi and owner of the post - take a look at the edit

rajesh.kanakabandi Over a year ago

you dont need the inner for loop. when you want to Access the MaxSize.

rajesh.kanakabandi · Accepted Answer · 2015-12-23 14:57:12Z

1

param_file_handle = json.load(open("sample.json"))
resources = param_file_handle['Resources']
for asg in resources.values():
     if asg["Type"] == "AWS::AutoScaling::AutoScalingGroup":
          print asg["Properties"]["MaxSize"]

try this.

answered Dec 23, 2015 at 14:57

rajesh.kanakabandi

3243 silver badges11 bronze badges

Comments

Elixir Techne · Accepted Answer · 2015-12-23 14:23:38Z

0

you broke hirerchy, missed "pevcwebasg"

resources = param_file_handle['Resources']['pevcwebasg']
for asg in resources:
     print asg["Type"]

answered Dec 23, 2015 at 14:23

Elixir Techne

1,85615 silver badges21 bronze badges

Collectives™ on Stack Overflow

recurse through json in python

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related