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

User · Accepted Answer

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 ''

User · Answer

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

[python] Selecting fields from JSON output

Examples related to python