BUG in JSON Exporter - Unnecessary escaping of single-quote producing invalid JSON data
I am trying to export data from one of tables using the JSON exporter... I've found that Zoho Reports exporting is escaping single-quote characters.
e.g. the export produces output like this...
"today\'s"
but based on the JSON Spec...
http://www.json.org Go to state machine diagram for string you'll see that a single-quote does not need to be escaped (i.e. no slash \ )
The JSON as it is is produced by Zoho Reports, fails validation.
If I replace the \' with just a single quote ' the validation passes.
note: I am using the Python Client API and I am using the python replace method to clean-up the data (contents in my snippet) ....into a valid string s
s = contents.replace("\\'", "'")
Please correct the JSON Exporter so it produces JSON that can be validated.