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?
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.
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