Error loading JSON from string in Python

Question

I have a problem loading the following using json.loads()

json.loads("""{"columnName": "ML_Status_Flags_1.LAST_RESOLVED_DATE",
      "columnId": "3",
      "columnIndex": 5, 
      "formulaString": "\u003dGROUPBY(ASdate(Formatdate(#Remedy_CL_!LAST_RESOLVED_DATE_ML_Status_Flags_1;\"dd-MM-yyyy\");\"dd-MM-yyyy\"))"
    }""")

I got the following errors

ERROR:root:An unexpected error occurred while tokenizing input
The following traceback may be corrupted or invalid
The error message is: ('EOF in multi-line string', (1, 9))

and At the end of the error I get this

JSONDecodeError: Expecting ',' delimiter: line 4 column 106 (char 215)

AlexW · Accepted Answer · 2017-12-31 11:46:34Z

2

swap your double quotes for singles on the dates, I dont believe they are escaped with \ in a string

json.loads("""{"columnName": "ML_Status_Flags_1.LAST_RESOLVED_DATE",
      "columnId": "3",
      "columnIndex": 5, 
      "formulaString": "\u003dGROUPBY(ASdate(Formatdate(#Remedy_CL_!LAST_RESOLVED_DATE_ML_Status_Flags_1;'dd-MM-yyyy');'dd-MM-yyyy'))"
    }""")

answered Dec 31, 2017 at 11:46

AlexW

2,16317 gold badges79 silver badges167 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pedro von Hertwig Batista · Accepted Answer · 2017-12-31 11:49:44Z

1

You need to escape your double quotes with a double backward slash \\:

json.loads("""{"columnName": "ML_Status_Flags_1.LAST_RESOLVED_DATE",
       "columnId": "3",
       "columnIndex": 5,
       "formulaString": "\u003dGROUPBY(ASdate(Formatdate(#Remedy_CL_!LAST_RESOLVED_DATE_ML_Status_Flags_1;\\"dd- MM-yyyy\\");\\"dd-MM-yyyy\\"))"
     }""")

answered Dec 31, 2017 at 11:49

Pedro von Hertwig Batista

3,0621 gold badge19 silver badges23 bronze badges

Comments

Anton vBR · Accepted Answer · 2017-12-31 11:55:22Z

1

Looks like a valid json. Adding 'r' before does the trick. See here for more info about 'r' and 'u': https://stackoverflow.com/a/2081708/7386332

The reason is that \ is an escape character in Python and r' makes sure does are not taken into consideration.

import json

json.loads(r"""{"columnName": "ML_Status_Flags_1.LAST_RESOLVED_DATE",
      "columnId": "3",
      "columnIndex": 5, 
      "formulaString": "\u003dGROUPBY(ASdate(Formatdate(#Remedy_CL_!LAST_RESOLVED_DATE_ML_Status_Flags_1;\"dd-MM-yyyy\");\"dd-MM-yyyy\"))"
    }""")

Returns

{'columnId': '3',
 'columnIndex': 5,
 'columnName': 'ML_Status_Flags_1.LAST_RESOLVED_DATE',
 'formulaString': '=GROUPBY(ASdate(Formatdate(#Remedy_CL_!LAST_RESOLVED_DATE_ML_Status_Flags_1;"dd-MM-yyyy");"dd-MM-yyyy"))'}

edited Dec 31, 2017 at 11:55

answered Dec 31, 2017 at 11:49

Anton vBR

19k6 gold badges47 silver badges47 bronze badges

Collectives™ on Stack Overflow

Error loading JSON from string in Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related