Hi guys,
I’m using a Coda table to sync data between Coda and Google Sheets, I’m running into the following error:
Exception: Request failed for https://coda.io returned code 422. Truncated server response: {“statusCode”:422,“statusMessage”:“Unprocessable Entity”,“message”:"Sorry, this doc has 100% of the maximum content size to be accessible via the C… (use muteHttpExceptions option to examine full response)
getTable
@ Coda.gs:518
retrieveRows
@ Code.gs:203
prepRows
@ Code.gs:123
addDeleteToSheet
@ Code.gs:93
runSync
@ Code.gs:25
I have about 80 rows that get added daily, the script runs every few hours, and sometimes we make changes to the database, so it’s important that changes including deleted rows are handled appropriately.
Any ideas on how I could resolve this issue? Thanks!