Supabase-datasource

Perform CRUD operations in Supabase

Includes:

Insert (Create)
Select (Read)
Upsert
Update
Delete

Official docs here: https://supabase.com/docs/reference/javascript/select

Documentation

Connecting

Provide a URL and API Key to connect:

These can be found within your project page in Supabase:

Click on the settings cog along the left-hand side:

Finally click on API to see the project URL and project API keys:

Usage

When pulling data from a table you must provide the name of the table, but also the names of the columns that you want to return.

To return all columns simply enter *.

Note that we are returning data.data in the transformer. You can return just data if you need access to the status code and message.

Filters

If you provide a Filter column then a filter will be applied based on the chosen operator and comparison value. There is a large list of available operators, detailed for which can be found here.

Bindings