We want to run a data update action that subsequently triggeres a bot, once a day for each row in a table. The table has roughly 1000 items, and the bot takes 10s each (if executed sychronously, I would estimate this to take 2:30h). Unfortunately we are always running into timeout issues. What is best practice or workarounds for triggering a large amount of rows?
If you could share more details about your relevant configuration, the community could give better assistance.
Could you elaborate what exactly that bot does and how it is configured and by 1000 items do you mean 1000 rows?
Also is it correct that the data update action you mentioned is applicable for just one record to trigger the bot and the action does not repeat for all the 1000 items ( or rows if you have one item per row)
1 Like
Sure:
- We have a bot with a scheduled event source, queries a table with no filter condition (all rows). The process simply runs a data action.
- The data action sets a column value.
- The updated column value triggers another bot, which sends data to another endpoint (either through AppsScript or a Webhook).
The first 30-50 rows get executed as expected, and the rest simply fails with “Fail to execute the process, because the request took too long to process.” In other words: As a hand-triggered action, it works, but once we schedule its execution for each row, only the first pass successfully.
Does that clarify our issue?
The reason is quite simple the scheduled Bot has a 5 minute limit and that’s why it timeouts. 5min * 60 secs / 10s = 30 rows approx.
Now the question is, are you able to do this with AppSheet API as then it’s not triggered row by row?
3 Likes
Hi, just wanna share what worked for me the fastest when doing bulk updates/adds/deletes.
I usually use Bot + Appsheet API Webhooks for adding/editing/deleting large amount of rows.
They are very fast compared to the per row “data action” normally available.
This is specially useful for apps with template items that needs to be duplicated.
The webhook is in JSON format.
Something like this on a prototype I was testing:
It’s usually a JSON template, so these are the following Action types: Add, Edit, Delete
What is usually almost a very long time of data updates is done within less than 20 seconds in my case.
2 Likes