Supabase Create or Update request

Questions
1

Hey is there a way to somehow use an update or create row in supabase?

I came to manufacture this workaround but I need to make the workaround for the workaround as well lol

image
image3004×944 230 KB

The reason why I’m using Suoabase is because sheets has too many api restrictions, and Airtable is expensive for this project.

If you could perhaps recommend another software (even selfhosted, I’m open)

2

Update: Came up with this “workaround”

image
image3032×848 241 KB

if anyone needs it, but will still love to hear Opinions and recommendations regarding sheets/Airtable alternatives specifically for N8N

3

Update: Didn’t work, had to loop it in batches of 1

4

I’m new in this, but try to use http module for supabase. With http module you can use upsert command. Search in supabase API.

5

Hey @lootfeey Have you done it ?

6

Yes, I did with help of claude.

7

I’m asking because I tried to do the same but it did not work. Maybe the sql was not set right. Can you share your http request?

8

You need to make a rpc in supabase. And Claude helped with it. http request is simplest. More important thing is RPC.

9

Take a look to this: JavaScript API Reference | Supabase Docs

10

Thanks @lootfeey I will try it again. Hopefully this time it works!