Empty Payload on Database Triggers

auth🟢SQL

Hi I'm having an issue with Database Triggers. I've set one up like so:

CREATE OR REPLACE TRIGGER user_email_confirmed_webhook
AFTER UPDATE ON auth.users
FOR EACH ROW
WHEN (OLD.email_confirmed_at IS DISTINCT FROM NEW.email_confirmed_at)
EXECUTE FUNCTION supabase_functions.http_request(
  'http://<PROJECT_ID>.supabase.co/functions/v1/function-name',
  'POST',
  '{"Content-Type":"application/json"}',
  '{}',
  '5000'
);

CREATE OR REPLACE TRIGGER user_email_confirmed_webhook
AFTER UPDATE ON auth.users
FOR EACH ROW
WHEN (OLD.email_confirmed_at IS DISTINCT FROM NEW.email_confirmed_at)
EXECUTE FUNCTION supabase_functions.http_request(
  'http://<PROJECT_ID>.supabase.co/functions/v1/function-name',
  'POST',
  '{"Content-Type":"application/json"}',
  '{}',
  '5000'
);

The idea is to trigger an email when the email is confirmed (e.g. a welcome email). The problem is when this comes through the edge function the payload is completely empty.

It seems like from https://supabase.com/docs/guides/database/webhooks the Payload should be the user record. Is this a permission thing or is there something I'm completely missing here?

Supabase•5h ago

cerwind

Empty Payload on Database Triggers

auth🟢SQL

Hi I'm having an issue with Database Triggers. I've set one up like so:

CREATE OR REPLACE TRIGGER user_email_confirmed_webhook
AFTER UPDATE ON auth.users
FOR EACH ROW
WHEN (OLD.email_confirmed_at IS DISTINCT FROM NEW.email_confirmed_at)
EXECUTE FUNCTION supabase_functions.http_request(
  'http://<PROJECT_ID>.supabase.co/functions/v1/function-name',
  'POST',
  '{"Content-Type":"application/json"}',
  '{}',
  '5000'
);

CREATE OR REPLACE TRIGGER user_email_confirmed_webhook
AFTER UPDATE ON auth.users
FOR EACH ROW
WHEN (OLD.email_confirmed_at IS DISTINCT FROM NEW.email_confirmed_at)
EXECUTE FUNCTION supabase_functions.http_request(
  'http://<PROJECT_ID>.supabase.co/functions/v1/function-name',
  'POST',
  '{"Content-Type":"application/json"}',
  '{}',
  '5000'
);

Empty Payload on Database Triggers

Similar Threads

Empty Payload on Database Triggers

Similar Threads

Similar Threads

Similar Threads