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  lt module gt      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

User · Answer

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)

User · Answer

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

User · Answer

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

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

Examples related to python

Examples related to json

Examples related to python-3.x