Not able to parse a json post from javascript in Python

Question

This is the string I'm receiving from the get request:

{'company_code': u'ha', 'from-date': u'', 'to-date': u'', 'ledger_type': u'CLNT', 'cost_center': u'ALL', 'margin': u'wtmg'}

Now, I'm completely confused what to do with this. I want to make str['company_code'] give me "ha" as output.

But even if I do json.dumps() or loads() on it, I'm just not able to access it.

Any help?

Edit: After sending a JSON string from the javascript client, and taking a json.dumps, I get this:

{"company_code": "ha", "from-date": "", "to-date": "", "ledger_type": "CLNT", "cost_center": "ALL", "margin": "wtmg"}

which is a string. I'm not sure how to go forward from here.

Can you please precise in your question in which direction the data is going? I guess you have a javascript client and python server. You sent data in JSON format from python to javascript but you did not use json.dumps and that's why python is issuing it's unicode special u"" formatting. Is that right? — Cilyan
– Cilyan, Commented Jan 11, 2014 at 16:31

falsetru · Accepted Answer · 2014-01-11 16:29:22Z

1

The given string is not a valid JSON. It seems like a result of repr.

>>> print(repr({'company_code': u'ha'}))
{'company_code': u'ha'}

JSON string should be wrapped in double qutoe ('"').

>>> print(json.dumps({'company_code': u'ha'}))
{"company_code": "ha"}

>>> import json
>>> json.loads('"a"')
u'a'
>>> json.loads("'a'")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "C:\Python27\lib\json\__init__.py", line 338, in loads
    return _default_decoder.decode(s)
  File "C:\Python27\lib\json\decoder.py", line 365, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "C:\Python27\lib\json\decoder.py", line 383, in raw_decode
    raise ValueError("No JSON object could be decoded")
ValueError: No JSON object could be decoded

EDIT according to the question edit.

Use json.loads to decode the json string; then access the value using dict[key] syntax.

>>> encoded = '{"company_code": "ha", "from-date": "", "to-date": "", "ledger_type": "CLNT", "cost_center": "ALL", "margin": "wtmg"}'
>>> decoded = json.loads(encoded)
>>> decoded['company_code']
u'ha'

edited Jan 11, 2014 at 16:29

answered Jan 11, 2014 at 16:13

falsetru

371k69 gold badges769 silver badges659 bronze badges

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

7 Comments

Hick Over a year ago

Anyway I could parse it then?

falsetru Over a year ago

@Hick, You can use ast.literal_eval in Python: decoded = ast.literal_eval(the_given_string). It will works as long as it only contains str, unicode, int, float, ...

Hick Over a year ago

Or maybe I could try to send json from the javascript client.

falsetru Over a year ago

@Hick, Yes, that is better than using ast.literal_eval.

falsetru Over a year ago

@Hick, But, it seems like the string is originated from Python. (Do you see u prefix in the string literal?). You should dump json in Python part.

|

Collectives™ on Stack Overflow

Not able to parse a json post from javascript in Python

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related