Reduce the amount of info in the webhook notification

Options
Senthil Saivam
edited 08/24/21 in API & Developers

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?

  1. Stop cell level changes from being included in the webhook notification. So you will only get row level changes.
  2. 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

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Senthil Saivam

    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

Answers