json.decoder.JSONDecodeError: Expecting value: , json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes:

Question

Hi I am working with JSON in my file in Python:

import json
userData = '''[
{
    "userID" : "20",
    "devices" : {
        "360020000147343433313337" : "V33_03",
        "3f0026001747343438323536" : "Door_03",
        "170035001247343438323536" : "IR_06",
        "28004c000651353530373132" : "BED_17"
    }
},

]'''

info = json.loads(userData)

I get this error when I load it: json.decoder.JSONDecodeError: Expecting value:

or sometimes when I add something: json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes:

score 3 · Accepted Answer · answered Jul 27 '18 at 07:23

3

Try using the ast module

Ex:

import ast
userData = '''[
{
    "userID" : "20",
    "devices" : {
        "360020000147343433313337" : "V33_03",
        "3f0026001747343438323536" : "Door_03",
        "170035001247343438323536" : "IR_06",
        "28004c000651353530373132" : "BED_17"
    }
},
]'''

info = ast.literal_eval(userData)
print(info)

answered Jul 27 '18 at 07:23

Rakesh

81,458
17
76
113

Is this a JSON object now? – Nikko Jul 27 '18 at 07:26
1

What do you mean by JSON object? using `ast` converts your string data-structure to valid python data-type..like a `dict` same as `json.loads` – Rakesh Jul 27 '18 at 07:26
1

I can get objects by info['userID'] ?, Yeah just tested it, I can go for this. However, still wondering that didn't work... – Nikko Jul 27 '18 at 07:31

score 1 · Answer 2 · answered Jul 27 '18 at 07:29

Looks the format is incorrect.

userData = '''[
{
    "userID" : "20",
    "devices" : {
        "360020000147343433313337" : "V33_03",
        "3f0026001747343438323536" : "Door_03",
        "170035001247343438323536" : "IR_06",
        "28004c000651353530373132" : "BED_17"
    }
},  <--- remove this ","

]'''

See my test:

>>> import json
>>> json.loads('[{"a":"b"}]')
[{u'a': u'b'}]
>>> json.loads('[{"a":"b"},]')
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 366, in decode
    obj, end = self.raw_decode(s, idx=_w(s, 0).end())
  File "C:\Python27\lib\json\decoder.py", line 384, in raw_decode
    raise ValueError("No JSON object could be decoded")
ValueError: No JSON object could be decoded
>>>

score 1 · Answer 3 · edited Jul 18 '19 at 22:38

1

For future reference, below how to get the JSON content or to get some spam:

import requests


url = 'http://httpbin.org/status/200'
r = requests.get(url)

if 'json' in r.headers.get('Content-Type'):
    js = r.json()
else:
    print('Response content is not in JSON format.')
    js = 'spam'

edited Jul 18 '19 at 22:38

Mark Loyman

1,983
1
14
23

answered Jul 18 '19 at 21:30

Marcelo Guimarães

11
1

Does this help with the original question? (identifying the problem within the JSON string) – Mark Loyman Jul 18 '19 at 21:47

score 0 · Answer 4 · answered Jul 27 '18 at 07:44

With your example as-is and no further understanding: info = json.loads(json.dumps(userData)) will work.

There are a lot of posts on SO about python multi-line strings and JSON. Ideally you would not be loading a string from a string variable that way is the general comment you will see.

With some additional explanation, such as where does the data originate and in what format, I can provide additional assistance.

json.decoder.JSONDecodeError: Expecting value: , json.decoder.JSONDecodeError: Expecting property name enclosed in double quotes:

4 Answers4

Linked