Vfrdtyky

My project is currently receiving a JSON message in python which I need to get bits of information out of. For the purposes of this, lets set it to some simple JSON in a string:

jsonStr = '{"one" : "1", "two" : "2", "three" : "3"}'

So far I've been generating JSON requests using a list and then json.dumps but to do the opposite of this I think I need to use json.loads but I haven't had much luck with it. Could anyone provide me a snippet that would return "2" with the input of "two" in the above example?

Very simple:

import json

j = json.loads('{"one" : "1", "two" : "2", "three" : "3"}')

print j['two']

Sometimes your json is not a string. For example if you are getting a json from a url like this:

j = urllib2.urlopen('http://site.com/data.json')

you will need to use json.load, not json.loads:

j_obj = json.load(j)

(it is easy to forget: the 's' is for 'string')

For URL or FIle, use json.load(). For string having .json content, use json.loads().

#! /usr/bin/python



import json

from pprint import pprint



#json_file='a.json' 

json_file='my_cube.json'

cube='1'



json_data=open(json_file)

data = json.load(json_data)

#pprint(data)

json_data.close()



print "Dimension: ", data['cubes'][cube]['dim']

print "Measures:  ", data['cubes'][cube]['meas']

Following is simple example that may help you:

json_string = """

{

    "pk": 1, 

    "fa": "cc.ee", 

    "fb": {

        "fc": "", 

        "fd_id": "12345"

    }

}"""



import json

data = json.loads(json_string)

if data["fa"] == "cc.ee":

    data["fb"]["new_key"] = "cc.ee was present!"



print json.dumps(data)

The output for the above code will be:

{"pk": 1, "fb": {"new_key": "cc.ee was present!", "fd_id": "12345", 

 "fc": ""}, "fa": "cc.ee"}

Note that you can set the ident argument of dump to print it like so (for example,when using print json.dumps(data , indent=4)):

{

    "pk": 1, 

    "fb": {

        "new_key": "cc.ee was present!", 

        "fd_id": "12345", 

        "fc": ""

    }, 

    "fa": "cc.ee"

}