Supabase node support upsert

Please add upsert on the node. Currently Update or Create but fails if trying to update something that isn’t there.

Yes, really need a method - Create or Modify

Is there any good workaround for that meanwhile? :roll_eyes:

I’m doing the upsert directly via sql

Hi @ericsonmartin, can you give an example workflow where you use upsert via SQL?

Sounds interesting but i have no idea how to do it.

Hi all,

Searching for upsert it landed me here.
Following the link provided by @ericsonmartin, I also managed to use the HTTP node to do an upsert on Superbase.

I hope this helps someone else that lands here.

2 Likes

Landed here looking for Supabase upsert. In case this helps someone else:

I upserted using the Postgres node per this post: Implementing UPSERT/MERGE with Supabase

Just need to ensure that the column(s) you are matching are set to UNIQUE in Supabase/Postgres otherwise you wont be able to select them in the Postgres node per this post: Postgres Node Insert or Update Unique Column Name