Selecting fields from JSON output

Question

Using Python, how can i extract the field id to a variable? Basicaly, i to transform this:

{
    "accountWide": true,
    "criteria": [
        {
            "description": "some description",
            "id": 7553,
            "max": 1,
            "orderIndex": 0
        }
     ]
}

to something like

print "Description is: " + description
print "ID is: " + id
print "Max value is : " + max

You could have a look at docs.python.org/library/json.html Everything can be found there. — cb0
– cb0, Commented Oct 17, 2012 at 12:53

bohney · Accepted Answer · 2012-10-17 13:36:16Z

62

Assume you stored that dictionary in a variable called values. To get id in to a variable, do:

idValue = values['criteria'][0]['id']

If that json is in a file, do the following to load it:

import json
jsonFile = open('your_filename.json', 'r')
values = json.load(jsonFile)
jsonFile.close()

If that json is from a URL, do the following to load it:

import urllib, json
f = urllib.urlopen("http://domain/path/jsonPage")
values = json.load(f)
f.close()

To print ALL of the criteria, you could:

for criteria in values['criteria']:
    for key, value in criteria.iteritems():
        print key, 'is:', value
    print ''

edited Oct 17, 2012 at 13:36

answered Oct 17, 2012 at 12:52

bohney

1,2059 silver badges12 bronze badges

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

2 Comments

thclpr Over a year ago

Hi, in fact it is an http output. i will try to convert your example to parse the output from the website.

bohney Over a year ago

@Thales See the example section of: docs.python.org/library/urllib.html#examples Take the value returned by urllib.urlopen and pass that to json.load in place of jsonFile my example above.

user8472 · Accepted Answer · 2012-10-17 12:55:41Z

15

Assuming you are dealing with a JSON-string in the input, you can parse it using the json package, see the documentation.

In the specific example you posted you would need

x = json.loads("""{
 "accountWide": true,
 "criteria": [
     {
         "description": "some description",
         "id": 7553,
         "max": 1,
         "orderIndex": 0
     }
  ]
 }""")
description = x['criteria'][0]['description']
id = x['criteria'][0]['id']
max = x['criteria'][0]['max']

answered Oct 17, 2012 at 12:55

user8472

3,3464 gold badges38 silver badges65 bronze badges

1 Comment

InquilineKea Over a year ago

how about accessing all descriptions (or ids) across all higher-level entities?

Collectives™ on Stack Overflow

Selecting fields from JSON output

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related