Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

AppSheet API Failure: No rows are present

I'm battling various issues with a webhook task that invokes the AppSheet API. One is that it sometimes returns an error that "No rows are present". Any direction regarding troubleshooting is welcome.

My Start expression is simply a "[Related...]" virtual column that uses a REF_ROWS function to generate a list of key values. I confirmed precise spelling of the column names, as well as that the JSON syntax parallels other webhook tasks that do work as expected. The Bypass Security Filters? property is enabled for the automation's event.

Example of error from the app Audit Log

dbaum_1-1655635535332.png

Step details from Automation Monitor showing row IDs can be referenced, but are not included in body of HTTP request to API

dbaum_2-1655636240598.png

Rows section of body of HTTP request to API

dbaum_3-1655636391234.png

 

 

 

0 3 383
3 REPLIES 3
Top Labels in this Space