Background: The Sheets backend for one of my AppSheet apps (an Order Management System of sorts) has a GAS project whose functions are called by an AppSheet bot under a certain set of circumstances. The GAS code performs some more complex tasks (using data from the Sheets document to create an order in our ERP system via APIs) then upon successful completion the GAS code makes two calls to the AppSheet API - one to update the Order “Header” record and another to update the Order “Trailer” or “Line” records to indicate the order & lines were successfully ‘exported’ into our ERP. This has been functioning nearly perfectly for quite a while (well over a year) with no changes.
Problem: Starting a few hours ago (about 6a EST) the AppSheet API call made by GAS to update the Order Header record is successful (returning a “200” response along with the expected JSON content) then the subsequent API call to update the Order Trailer/Line records fails with a reponse code 429. Oddly, however, there is no content body returned with the error response (whereas in the past when an error is returned there is text content providing some sort of explanation of the error). Additionally, when I look at the app’s Audit Log, there is no entry of the failed API call.
I’m guessing this is probably some transient issue, but is anyone else experiencing a high occurrence of 429 errors when calling the AppSheet API this morning? Any other thoughts or suggestions on how to troubleshoot this to determine if it’s truly a transient issue or if some new rate limits have been implemented? I can’t find anything indicating known service degradations this morning nor anything helpful for debugging this error further.
Please know I understand the 429 response traditionally indicates too many requests, but my app’s transaction volume/request frequency/speed is completely ‘normal’ this morning, so I really am unsure of why these errors are occurring and would appreciate any insight or confirmation that I’m not alone in this (which would further support the transient issue narrative).
Thank you
For the past several hours, a high percentage of