json.decoder.JSONDecodeError: Extra data: line 2 column 1 (char 190)

Question

I am running the following code-

import json

addrsfile = 
open("C:\\Users\file.json", 
"r")
addrJson = json.loads(addrsfile.read())
addrsfile.close()
if addrJson:
    print("yes")

But giving me following error-

Traceback (most recent call last):
  File "C:/Users/Mayur/Documents/WebPython/Python_WebServices/test.py", line 9, in <module>
    addrJson = json.loads(addrsfile.read())
  File "C:\Users\Mayur\Anaconda3\lib\json\__init__.py", line 354, in loads
    return _default_decoder.decode(s)
  File "C:\Users\Mayur\Anaconda3\lib\json\decoder.py", line 342, in decode
    raise JSONDecodeError("Extra data", s, end)
json.decoder.JSONDecodeError: Extra data: line 2 column 1 (char 190)

Anyone help me please?

JSON file is like-

{"name": "XYZ", "address": "54.7168,94.0215", "country_of_residence": "PQR", "countries": "LMN;PQRST", "date": "28-AUG-2008", "type": null}
{"name": "OLMS", "address": null, "country_of_residence": null, "countries": "Not identified;No", "date": "23-FEB-2017", "type": null}

that format of json is called LD JSON. It's better for serial read/write — azizbro, Mar 14 '22 at 09:06

Hannu · Answer 1 · 2018-01-08T17:25:11.133

You have two records in your json file, and json.loads() is not able to decode more than one. You need to do it record by record.

See Python json.loads shows ValueError: Extra data

OR you need to reformat your json to contain an array:

{
    "foo" : [
       {"name": "XYZ", "address": "54.7168,94.0215", "country_of_residence": "PQR", "countries": "LMN;PQRST", "date": "28-AUG-2008", "type": null},
       {"name": "OLMS", "address": null, "country_of_residence": null, "countries": "Not identified;No", "date": "23-FEB-2017", "type": null}
    ]
}

would be acceptable again. But there cannot be several top level objects.

In my case, it turned to be 20000 records in that file. The link suggested in the answer gave away the solution for me. — kkgarg, Mar 02 '21 at 17:37

Richard · Answer 2 · 2019-02-03T19:18:51.347

3

I was parsing JSON from a REST API call and got this error. It turns out the API had become "fussier" (eg about order of parameters etc) and so was returning malformed results. Check that you are getting what you expect :)

edited Feb 03 '19 at 19:18

answered Feb 03 '19 at 18:24

Richard

231
1
2
5

score 2 · Answer 3 · answered Oct 24 '20 at 15:37

2

This error can also show up if there are parts in your string that json.loads() does not recognize. An in this example string, an error will be raised at character 27 (char 27).

string = """[{"Item1": "One", "Item2": False}, {"Item3": "Three"}]"""

My solution to this would be to use the string.replace() to convert these items to a string:

import json

string = """[{"Item1": "One", "Item2": False}, {"Item3": "Three"}]"""

string = string.replace("False", '"False"')

dict_list = json.loads(string)

answered Oct 24 '20 at 15:37

Neil

41
5

This is because `False` is [not a valid boolean, according to JSON schema](http://json-schema.org/understanding-json-schema/reference/boolean.html). The correct boolean you are looking for is `false`, not `"False"` (which is a string). So, in your case, you should use `string.replace("False", "false")`. – Honza Zíka Aug 27 '21 at 08:52

json.decoder.JSONDecodeError: Extra data: line 2 column 1 (char 190)

3 Answers3

Linked