Insert

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

Examples

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: "john@example.com"
      status: "active"

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: "john@example.com"
        status: "active"
      - name: "Jane Smith"
        email: "jane@example.com"
        status: "active"

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: "john.updated@example.com"
    onConflict: "id"
    resolution: "merge-duplicates"

Properties

apiKey *string

data *arrayobject

table *string

url *string

onConflict string

options

Default

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

Definitions

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

allowFailedbooleanstring

Defaultfalse

allowedResponseCodesarray

SubTypeinteger

auth

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

type*object

passwordstring

usernamestring

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

type*object

tokenstring

basicAuthPasswordstring

basicAuthUserstring

connectTimeoutstring

Formatduration

connectionPoolIdleTimeoutstring

Formatduration

defaultCharsetstring

DefaultUTF-8

java.nio.charset.Charset

followRedirectsbooleanstring

Defaulttrue

logLevelstring

Possible Values

ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIED

logsarray

SubTypestring

Possible Values

REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODY

maxContentLengthinteger

proxy

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

addressstring

passwordstring

portintegerstring

typestring

DefaultDIRECT

Possible Values

DIRECTHTTPSOCKS

usernamestring

proxyAddressstring

proxyPasswordstring

proxyPortinteger

proxyTypestring

Possible Values

DIRECTHTTPSOCKS

proxyUsernamestring

readIdleTimeoutstring

Formatduration

readTimeoutstring

Formatduration

ssl

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

insecureTrustAllCertificatesbooleanstring

timeout

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

connectTimeoutstring

readIdleTimeoutstring

DefaultPT5M

resolution string

Defaultmerge-duplicates

schema string

Defaultpublic

select string

Outputs

code integer

headers object

SubTypearray

insertedCount integer

insertedRows array

SubTypeobject

rawResponse string

uri string

Formaturi

ServiceNow

Tasks that create, update, read, and delete ServiceNow records via REST.

DataBusiness

Duckdb

Tasks that connect to DuckDB via JDBC to run queries and loads.

Data

Prefect

Tasks that trigger Prefect deployments and monitor flow runs.

Data

Insert

More Plugins in this Category

ServiceNow

Duckdb

Prefect

1.1.2