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
Step details from Automation Monitor showing row IDs can be referenced, but are not included in body of HTTP request to API
Rows section of body of HTTP request to API
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |