Problem decoding json strings using json module

Question

After contacting a server I get the following strings as response

{"kind": "t2", "data": {"has_mail": null, "name": "shadyabhi", "created": 1273919273.0, "created_utc": 1273919273.0, "link_karma": 1343, "comment_karma": 301, "is_gold": false, "is_mod": false, "id": "425zf", "has_mod_mail": null}}

which is stored as type 'str' in my script.

Now, when I try to decode it using json.dumps(mystring, sort_keys=True, indent=4), I get this.

"{\"kind\": \"t2\", \"data\": {\"has_mail\": null, \"name\": \"shadyabhi\", \"created\": 1273919273.0, \"created_utc\": 1273919273.0, \"link_karma\": 1343, \"comment_karma\": 301, \"is_gold\": false, \"is_mod\": false, \"id\": \"425zf\", \"has_mod_mail\": null}}"

which should really be like this

shadyabhi@archlinux ~ $ echo '{"kind": "t2", "data": {"has_mail": "null", "name": "shadyabhi", "created": 1273919273.0, "created_utc": 1273919273.0, "link_karma": 1343, "comment_karma": 299, "is_gold": "false", "is_mod": "false", "id": "425zf", "has_mod_mail": "null"}}' | python2 -mjson.tool
{
    "data": {
        "comment_karma": 299, 
        "created": 1273919273.0, 
        "created_utc": 1273919273.0, 
        "has_mail": "null", 
        "has_mod_mail": "null", 
        "id": "425zf", 
        "is_gold": "false", 
        "is_mod": "false", 
        "link_karma": 1343, 
        "name": "shadyabhi"
    }, 
    "kind": "t2"
}
shadyabhi@archlinux ~ $

So, what is it that's going wrong?

g.d.d.c · Accepted Answer · 2011-09-13 17:07:02Z

2

You need to load it before you can dump it. Try this:

data = json.loads(returnFromWebService)

json.dumps(data, sort_keys=True, indent=4)

To add a bit more detail - you're receiving a string, and then asking the json library to dump it to a string. That doesn't make a great deal of sense. What you need to do first is put the data into a more meaningful container. By calling loads you take the string value of the return and parse it into an actual Python Dictionary. Then, you can pass that data to dumps which outputs a string using your requested formatting.

answered Sep 13, 2011 at 17:07

g.d.d.c

48.3k12 gold badges105 silver badges116 bronze badges

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

1 Comment

shadyabhi Over a year ago

Aha, while looking at the documentation, I was wondering as to how to get that obj. Now, I know. So, by using loads, I deserialize the string.

Duncan · Accepted Answer · 2011-09-13 17:08:22Z

1

You have things backwards. If you want to convert a string to a data structure you need to use json.loads(thestring). json.dumps() is for converting a data structure to a json encoded string.

answered Sep 13, 2011 at 17:08

Duncan

96.4k15 gold badges129 silver badges160 bronze badges

Comments

Remi · Accepted Answer · 2011-09-13 17:09:27Z

1

You are supposed to dump an object (like a dictionary) which then becomes a string, not the other way round... see here.

Use json.loads() instead.

answered Sep 13, 2011 at 17:09

Remi

21.3k9 gold badges59 silver badges41 bronze badges

Comments

Aaron Dufour · Accepted Answer · 2011-09-13 17:10:56Z

1

You want json.loads. The dumps method is for going the other way (dumping an object to a json string).

answered Sep 13, 2011 at 17:10

Aaron Dufour

17.6k1 gold badge51 silver badges73 bronze badges

Collectives™ on Stack Overflow

Problem decoding json strings using json module

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related