I’m trying to run a webhook to interact with appsheet API to add new rows to a table. In the table there is a [Date] column, that is a Date type column. In the JSON body I put
- “Date”: “<<TODAY()>>”
And when the webhook runs it throws the error
Error: Value ‘20/01/2020’ in field ‘Date’ in table ‘Maintenance’ cannot be converted to type ‘Date’.
If I remove that part of the JSON, and just rely on that column’s Initial Value setting of TODAY(), it works fine.
I’m wondering if it is some sort of locale conflict, since the app is based off of Google sheets with French timezone in their settings, and loaded into the editor with the French locale setting, whereas I am in the US and use MM/DD/YYYY.