JSON parse error

[JMPeterson]

Has there been a change in how AppSheet handles JSON packets recently? I have been seeing errors the last couple hours that were not happening earlier today, or earlier this week. Is anyone else seeing anything unusual?

The specific error message I receive is "Error: Failed to parse JSON due to The JSON object contains a trailing comma at the end which is not supported in this mode. Change the reader options. LineNumber: 0 | BytePositionInLine: 83..". There have been no changes made to webhook itself, or the tables it interacts with.

[Marc_Dillon · Accepted solution]

I saw the same error just a few hours ago. Upon closer inspection I did find a trailing comma in my JSON, at the end of the "Properties" section to be specific. Deleting it solved the issue.

This JSON was a fairly old setup, which hadn't been changed in a long time until I was working on it today, so yah, they maybe changed something small?

[JMPeterson]

@Marc_Dillon you sir were spot on. The "Properties" section was exactly where that trailing comma was hiding. I had not thought to look there. Similarly, that JSON has been that way for quite a long time and working flawlessly until ~10am CST. I appreciate your help!

[Marc_Dillon]

Yah something was definitely changed. I found another instance of this error, on a Bot that hasn't been touched in months, and continually sends slack messages so it is obvious to see when it is working or not. Here is a screenshot from automation monitor showing approximate time when something was changed. I think that's UTC time.

[Steve]

Escalated.

[adamws]

Thanks for highlighting this! There was a related library update that changed JSON validation. We've reverted that back because of the unanticipated impact. We will validate the trailing comma case before attempting the change again. Will let you know on this thread when that change goes out as well.