[Solved] How can I INSERT / POST data to Supabase?

[stefansladdeneng1]

I understand how to combine sql queries in one go using sql only. What i do not get is how to make a comination in url for the thunkable call to post in the supabase url.
I want to insert into column XXX, value 111, column YYY, value 222. The command is available in Supabase docs - but not how to post from Thunkable.
@jared probably you know!!…

[jared]

For an INSERT, it’s a POST call. What have you tried?

[stefansladdeneng1]

Yes i know it is a POST rather than a get - But instead of SELECT* i tried
INSERT INTO (HIGHSCORE: Value ‘123’ and ALIAS: Value ‘Stefan’)
Which did not work

[jared]

You must read the docs I shared in the other post dude.

You don’t use sql statements over the rest interface.

[stefansladdeneng1]

I get that - But the docs does not tell us how to implement it with Thunkable…Does it ? Or do you meqan its only to do a Copy paste and it will work?

[jared]

See the video

Supabase Starter Template

https://x.thunkable.com/projectPage/652308d92ecc34478bef887d A basic template to show how to configure your blocks to: Execute User Authentication and Registration Execute GETs to grab data from a table using simple text-matching Include a User Auth Token to support the use of Row Level Security, making the data in your database more secure. Store data from an API to the Local table then display the data in a Data Viewer. Use the Data Viewer to display data in an onscreen popup Supabse RLS p…

[stefansladdeneng1]

I get it Jared - But i do not see how you made it in the actual URL -

You where saying earlier that the POST variables where to be in the URL…
But what you sent show variablas as part of the BODY.
Its the POST part i need some conceptual guidence

The “GET” part is pretty clear to me and i get result

[jared]

that’s right.

to post data to your backend, you won’t put the new records data in the URL,

you will set the body of the API call

you can find the URL though if you are unsure in your supabase backend. go to the table. click the api tab at the top right. click the button that says BASH.