7
Add 'WHEN' Condition for UPDATE Webhooks in UI
Source: supabase/supabase#36447 · opened by @sebasbeleno
Currently, when creating a database webhook for UPDATE events through the Supabase UI, there isn't an option to specify a conditional WHEN clause.
This limitation causes an issue when an Edge Function is triggered by a row update and subsequently modifies a column in that same row. This modification re-triggers the UPDATE webhook, leading to an infinite loop or unnecessary function executions.
While it's possible to add a WHEN clause using SQL to prevent this (e.g., WHEN (old.* IS DISTINCT FROM new.*) on specific columns), this functionality is missing from the dashboard UI
This limitation causes an issue when an Edge Function is triggered by a row update and subsequently modifies a column in that same row. This modification re-triggers the UPDATE webhook, leading to an infinite loop or unnecessary function executions.
While it's possible to add a WHEN clause using SQL to prevent this (e.g., WHEN (old.* IS DISTINCT FROM new.*) on specific columns), this functionality is missing from the dashboard UI
No pledges yet. Be the first to back this.
Comments
Similar requests
Retrieve list of users by ID
1 vote · 0 comments
Webhooks which call Edge functions should be configured via config.toml
1 vote · 0 comments
Webhook Retries
12 votes · 0 comments
Webhooks Enabled by Default
1 vote · 0 comments
Add Reverse Proxy Support for Local Supabase Development
1 vote · 0 comments
No comments yet.