Perform CRUD operations in Supabase
Includes:
- Insert (Create)
- Select (Read)
- Upsert
- Update
- Delete
Official docs here: https://supabase.com/docs/reference/javascript/select
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:
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.
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.
Like any other custom query, you can add bindings and use them in the Fields section: https://docs.budibase.com/docs/data-sources#using-query-bindings