Skip to main content

Supabase - Database Call

Overview

Makes a CRUD call to the Supabase REST API.

Hint - Place this block inside a Set Data Structure block to handle the response.


BlockCompatible SlotsDescription
Supabase — Create UserData StructureAllows you to create a user account on your Supabase instance via Comnoco
Supabase — LoginData StructureAllows you to authenticate a user with your Supabase instance via Comnoco
tip
  • Place this block in the from slot of a Set Data Structure block to handle the response.
  • If accessing a schema other than the default public one, ensure you have set up Supabase permissions correctly following this guide
Returns
Data Structure

Parameters

ParameterParameterValid BlocksRequired
Query Builder StructureThe parameters to send as part of the query URL (eg: id=eq.1) defined as a Data StructureData Structure Block GroupNo
Base URLYour Supabase instance's base URL, eg: https://yourprojecturl.supabase.co. We recommend you set this as an environment variable.Text Process Block GroupNo
API KeyYour Supabase API Key. This can be your Anon or Service Role key. If you have RLS enabled, and want the current user to define access permissions use the Anon key. To give comnoco full access as a backend process, use the Service Role key. We recommend you set this as a system secret.Secret Block GroupNo
User TokenThe Access Token (JWT) of a logged-in Supabase user, if provided, this will be used to determine the user's permissions (data returned) as set by RLS. Will remove the `Bearer` prefix from an auth header if necessary.Semi-Secret Block GroupNo
Table NameThe name of the table to callText Process Block GroupYes
Call MethodThe type of call to makeText Process Block GroupNo
Record DataThe records to insert or update depending on the Call MethodSupabase Payload Block GroupNo
Bulk Insert ModeTo bulk insert CSV simply choose CSV here, map CSV (in a text block) to the body and include the names of the columns as the first rowText Process Block GroupNo
Show Advanced OptionsIf on, shows the additional option of defining or appending query parameters manually (define your own postgREST query string).Boolean Block GroupNo
OptionsThese control behaviour and set PostgREST Prefer Header valuesText Block GroupNo
Query ParametersAdd your own parameters to send as part of the query URL (eg: id=eq.1). If you have defined a Query Builder output this field it will be added to the end of the URL.Supabase Payload Block GroupNo
Catch Errors to Data StructureCatch errors from the Supabase call as a Data Structure and return them as the response value to enable manual error handling. If turned on errors will not get caught in a Try-Catch block.Boolean Block GroupNo
Project Connection ConfigA Supabase connection configuration that was setup in the Databases panelText Process Block GroupNo
Project SchemaSwitch schema on your Supabase project, defaults to 'public'. See https://supabase.com/docs/guides/api/using-custom-schemas for a guide on custom schemas.Text Process Block GroupNo