Insert

Insert data into a Supabase table using the REST API.

This task inserts one or more records into a Supabase table using the REST API.

yaml
type: "io.kestra.plugin.supabase.Insert"

Examples

Insert a single record.

yaml

id: supabase_insert_single
namespace: company.team

tasks:
  - id: insert_user
    type: io.kestra.plugin.supabase.Insert
    url: https://your-project.supabase.com
    apiKey: "{{ secret('SUPABASE_API_KEY') }}"
    table: users
    data:
      name: "John Doe"
      email: "[email protected]"
      status: "active"

Insert multiple records.

yaml

id: supabase_insert_multiple
namespace: company.team

tasks:
  - id: insert_users
    type: io.kestra.plugin.supabase.Insert
    url: https://your-project.supabase.com
    apiKey: "{{ secret('SUPABASE_API_KEY') }}"
    table: users
    data:
      - name: "John Doe"
        email: "[email protected]"
        status: "active"
      - name: "Jane Smith"
        email: "[email protected]"
        status: "active"

Insert with conflict resolution (upsert).

yaml

id: supabase_upsert
namespace: company.team

tasks:
  - id: upsert_user
    type: io.kestra.plugin.supabase.Insert
    url: https://your-project.supabase.com
    apiKey: "{{ secret('SUPABASE_API_KEY') }}"
    table: users
    data:
      id: 123
      name: "John Doe Updated"
      email: "[email protected]"
    onConflict: "id"
    resolution: "merge-duplicates"

Properties

apiKey *string

The Supabase API key

The API key for authenticating with Supabase -- use the anon key for client-side operations or the service_role key for server-side operations with elevated privileges.

data *object

The data to insert

The data to insert -- can be a single object or an array of objects.

table *string

The name of the table to insert into

The name of the table in your Supabase database

url *string

The Supabase project URL

The URL of your Supabase project (e.g., https://your-project.supabase.com)

onConflict string

Conflict resolution column(s)

Column name(s) to use for conflict resolution (upsert) -- comma-separated for multiple columns.

options HttpConfiguration

Default

{
  "followRedirects": "true",
  "allowFailed": "false",
  "defaultCharset": "UTF-8"
}

resolution string

Default merge-duplicates

Resolution strategy for conflicts

How to handle conflicts: 'merge-duplicates' (default) or 'ignore-duplicates'

schema string

Default public

The schema to use

The database schema to use for operations -- defaults to 'public'.

select string

Columns to return after insertion

Comma-separated list of columns to return after the insert. Defaults to '*' (all columns).

Outputs

code integer

The HTTP status code of the response

headers object

SubType array

The headers of the response

insertedCount integer

The number of rows inserted

insertedRows array

SubType object

The inserted rows returned from the database

rawResponse string

The raw response body

uri string

Format uri

The URI of the executed request

Definitions

io.kestra.core.http.client.configurations.TimeoutConfiguration

connectTimeout string

Format duration

The time allowed to establish a connection to the server before failing.

readIdleTimeout string

Default PT5M

Format duration

The time allowed for a read connection to remain idle before closing it.

io.kestra.core.http.client.configurations.BasicAuthConfiguration

type *object

password string

The password for HTTP basic authentication.

username string

The username for HTTP basic authentication.

java.nio.charset.Charset

io.kestra.core.http.client.configurations.HttpConfiguration

allowFailed booleanstring

Default false

If true, allow a failed response code (response code >= 400)

allowedResponseCodes array

SubType integer

List of response code allowed for this request

auth BasicAuthConfiguration BearerAuthConfiguration

The authentification to use.

defaultCharset Charsetstring

Default UTF-8

The default charset for the request.

followRedirects booleanstring

Default true

Whether redirects should be followed automatically.

logs array

SubType string

Possible Values

REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODY

The enabled log.

proxy ProxyConfiguration

The proxy configuration.

ssl SslOptions

The SSL request options

timeout TimeoutConfiguration

The timeout configuration.

io.kestra.core.http.client.configurations.ProxyConfiguration

address string

The address of the proxy server.

password string

The password for proxy authentication.

port integerstring

The port of the proxy server.

type string

Default DIRECT

Possible Values

DIRECTHTTPSOCKS

The type of proxy to use.

username string

The username for proxy authentication.

io.kestra.core.http.client.configurations.SslOptions

insecureTrustAllCertificates booleanstring

Whether to disable checking of the remote SSL certificate.

Only applies if no trust store is configured. Note: This makes the SSL connection insecure and should only be used for testing. If you are using a self-signed certificate, set up a trust store instead.

io.kestra.core.http.client.configurations.BearerAuthConfiguration

type *object

token string

The token for bearer token authentication.

​Insert

Insert