Reduce the amount of info in the webhook notification
Hi,
Lets say you have a sheet with lots of formula columns and lots of rows. The webhook notification seems to include all the rows in the sheets and all the cells in all the formula columns for all the rows. This happens even if you just changed one cell in one row and saved the sheet.
Is there a way to do any of the following?
- Stop cell level changes from being included in the webhook notification. So you will only get row level changes.
- Stop changes being reported on rows where nothing happened. Formula re-calculations where the result did not change should not be notified as a change.
Thanks.
cheers,
senthil
Best Answer
-
When a formula is re-calculated, even if the output of the formula is the same, this will be recognized as a modification of that row as you've found. Please let our Product team know about your specific use-case and scenario (detailing the formulas you're using and webhook) by filling in this form, here.
In regards to your first request, would you be able to provide more information? It would be useful to know what your current scope is, and an example of the notification.
Currently, sheet is the only supported value for the scope attribute. However, you can set an array of columns as a subscope if you want to limit the webhook to specific columns. (See: Webhook Scope & Events in the API Documentation here).
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
When a formula is re-calculated, even if the output of the formula is the same, this will be recognized as a modification of that row as you've found. Please let our Product team know about your specific use-case and scenario (detailing the formulas you're using and webhook) by filling in this form, here.
In regards to your first request, would you be able to provide more information? It would be useful to know what your current scope is, and an example of the notification.
Currently, sheet is the only supported value for the scope attribute. However, you can set an array of columns as a subscope if you want to limit the webhook to specific columns. (See: Webhook Scope & Events in the API Documentation here).
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Thanks @Genevieve P.
The scope is sheet and there are too many columns in the sheet to use the subscope for excluding formula columns.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives