How to avoid webhook triggering from cell format updates???
I'm using make.com to do some automations when certain columns in a row are updated.
Works great until someone re-aligns the columns and updates 1500 cells at once, sending my webhook 1500 requests. I can filter them out by detecting the actual data cell history, but it still uses 3000 operations for no reason and ties up my process for however long that takes to go through.
I need to detect cell creation or update. I have a subscope set for just the columns I want. But I can't block these false updates from triggering it.
If anyone is familiar with make.com or even just a way to block formatting changes from being sent to a webhook you will be my hero.
Thanks!
PS- sometimes it will send over 10k requests, even though I only had 1500 cells change format, so I don't know what's up with that either.
Answers
-
Here's a test I was doing. Selected the one column. Set it to only detect Cell activities. I don't have any way of ignoring the formatting updates.
-
Hi @LVail
I never used make.com as I always create webhooks that responds to my server but I would suggesting checking two things:
- Retry logic - a webhook is waiting for a response with 200 status if not received it will try delivery up to 14 times. Please refer to: https://smartsheet.redoc.ly/#section/Webhook-Callbacks
- Infinite loops - https://smartsheet.redoc.ly/#section/Preventing-Infinite-Loops
Overall it's worth reading the API documentation as it might have the answer to your questions.
