Python json loads error JSONDecodeError Expecting Value

Asked Sep 24 '19 at 15:13

Active Sep 24 '19 at 15:26

Viewed 310 times

I have read just about every json loads out there: Python json.loads fails with `ValueError: Invalid control character at: line 1 column 33 (char 33)`
Python Json lower case nan
JSONDecodeError: Expecting value: line 1 column 1 (char 0)
Single versus double quotes in json loads in Python

I have replaced single quotes with double quotes, I have changed nan to NaN, I have checked for carriage returns, I encoded it as utf-8. Still I am getting an error when trying json.loads or ast.literval_eval.

JSONDecodeError: Expecting value: line 1 column 33 (char 32)
ValueError: malformed node or string: <_ast.Name object at 0x0000016583978160>

The string starts like this

temp3[:50]
>>> '{"firstOTDriveAlreadyHappened": False, "NeedsHomeA'

Any ideas?

____SOLUTION___

Mentioned in a comment, but I had to make the following maps:

temp3 = temp3.replace('False', 'false')
temp3 = temp3.replace('True', 'true')
temp3 = temp3.replace('None', 'null')
temp3 = temp3.replace('nan', 'NaN')
temp3 = temp3.replace("'", '"')

https://docs.python.org/3/library/json.html#encoders-and-decoders

edited Sep 24 '19 at 15:26

asked Sep 24 '19 at 15:13

qwertylpc

2,016
7
24
34

1

Please provide a [mcve] – Pitto Sep 24 '19 at 15:13
1

_Any ideas?_ Yes -- show us the full json string. – John Gordon Sep 24 '19 at 15:15
I don't mind if you share the full json to check for inconsistency – Celius Stingher Sep 24 '19 at 15:15
1

In json `False` is spelled `false`. – quamrana Sep 24 '19 at 15:17
@quamrana Thank you I didn't see that anywhere - and why are the other comments so passive aggresive, that is a minimally reproducible example and sometimes people can't provide entire strings because of sensitive info – qwertylpc Sep 24 '19 at 15:19
1

For all future newbies to `json`, the requisite reading is: http://json.org/ – quamrana Sep 24 '19 at 15:19
2

Nobody mentioned it but the problem lays in the source of that "JSON". It should be fixed there and not by shaky string replacement on the receiver side. – ElmoVanKielmo Sep 24 '19 at 15:31

Python json loads error JSONDecodeError Expecting Value

0 Answers0