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

by

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.

More Related Contents:

  1. Let JSON object accept bytes or let urlopen output strings
  2. Trying to parse `request.body` from POST in Django [duplicate]
  3. Serialising an Enum member to JSON
  4. pandas.io.json.json_normalize with very nested json
  5. OpenAI GPT-3 API error: “Cannot specify both model and engine”
  6. Handle JSON Decode Error when nothing returned
  7. How to open a file within python?
  8. A simple maths operation on a CSV column using python [closed]
  9. Why am getting an "elif" syntax error showing invalid syntax in python [closed]
  10. Access a particular field in arbitrarily nested JSON data [duplicate]
  11. How can I connect to MySQL in Python 3 on Windows?
  12. Scheduling Python Script to run every hour accurately
  13. Using multiple Python engines (32Bit/64bit and 2.7/3.5)
  14. Importing class from another file [duplicate]
  15. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  16. What is the meaning of “Failed building wheel for X” in pip install?
  17. return SQL table as JSON in python
  18. When should iteritems() be used instead of items()?
  19. Clear QLineEdit on click event
  20. How to set the timezone in Django
  21. Understand Python swapping: why is a, b = b, a not always equivalent to b, a = a, b?
  22. pip no longer working after update error ‘module’ object is not callable
  23. How do I create a multiline plot using seaborn?
  24. Python – Printing a dictionary as a horizontal table with headers
  25. TypeError: ‘zip’ object is not subscriptable
  26. How to completely traverse a complex dictionary of unknown depth?
  27. Switching to Python 3 causing UnicodeDecodeError
  28. json.dump throwing “TypeError: {…} is not JSON serializable” on seemingly valid object?
  29. Is there any working memory profiler for Python3 [closed]
  30. pandas scatter plotting datetime

Leave a Comment