Webhooks on User update

Hi! I've just implemented the ability for users to change emails themselves. This is nice and all for the Supabase DB, but I also need to update the email in Stripe, my helpdesk, etc automatically. I did find some posts relating to this, but the auth table doesn't show up in the HTTP extension for me. (I did enable it properly.) Anything I'm missing?

garyaustin•10/7/22, 6:15 PM

You should be able to an update trigger on auth.users and check new.email vs old.email and then use the http fucnction.

maxOP•11/13/22, 4:08 PM

So, after trying to do this for a bit (and a lot of other things happening), I'm completely lost on how to do this.
Webhooks list the tables used by auth and I really don't know a way to do it within triggers.
Both of which don't seem to be ready for production too

garyaustin•11/13/22, 4:14 PM

Webhooks would require you to have a server function (like EDGE functions) to call and process the row data from an update. Then do what ever you need to do with stripe. Using a update trigger and Postgres function with the HTTP extension (your function would need to be "security definer" type to access auth) is other way to go. You might also need to set the search_path to include auth, not sure.

Triggers and Postgres function are part of Postgres so full production. The UI for them is considered

Webhooks on User update

Similar Threads

Similar Threads

Similar Threads