Question 109908 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Improperly formatted JSON, no idea what is incorrect

I have a JSON string here. In Python, whenever I json.loads(string), I get json.decoder.JSONDecodeError: Expecting ',' delimiter: line 1 column 21 (char 20). However, I am completely lost on why it is an improperly formatted JSON. I have tried adding r infront of the string but with no avail.

JSON String:

string = '{"alarm_flood": "[{"Date_Time": "01-12-2009 12:18:42", "flood_status": "1", "FloodIndex": "0", "Plant_Area": "AREA 1"}, {"Date_Time": "01-12-2009 12:18:42", "flood_status": "0", "FloodIndex": "0", "Plant_Area": "AREA 1"}]", "flood_status": "[{"Date_Time": "01-12-2009 12:18:42", "flood_status": "1", "FloodIndex": "0", "Plant_Area": "AREA 1"}, {"Date_Time": "01-12-2009 12:18:42", "flood_status": "0", "FloodIndex": "0", "Plant_Area": "AREA 1"}]"}'

Can someone point me to the right direction?

Tags:

2

Answers


  1. 0

    You had some extra quotation marks. Here is the corrected version:

    string = '{"alarm_flood": [{"Date_Time": "01-12-2009 12:18:42", "flood_status": "1", "FloodIndex": "0", "Plant_Area": "AREA 1"}, {"Date_Time": "01-12-2009 12:18:42", "flood_status": "0", "FloodIndex": "0", "Plant_Area": "AREA 1"}], "flood_status": [{"Date_Time": "01-12-2009 12:18:42", "flood_status": "1", "FloodIndex": "0", "Plant_Area": "AREA 1"}, {"Date_Time": "01-12-2009 12:18:42", "flood_status": "0", "FloodIndex": "0", "Plant_Area": "AREA 1"}]}'
    Login or Signup to reply.
  2. 0

    you have some extra double quotes, you can remove them using replace

    string = string.replace('"[', '[').replace(']"', ']');
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search