Supabase Update

Supabase Update
Certified
Update rows in a Supabase table

PATCHes rows via Supabase REST using a required PostgREST filter. Always requests Prefer: return=representation; select defaults to * to return all columns. Requires an API key with write access to the table.

yaml
type: io.kestra.plugin.supabase.Update

Examples

Update records with a simple filter.

yaml
id: supabase_update_simple
namespace: company.team

tasks:
  - id: update_user_status
    type: io.kestra.plugin.supabase.Update
    url: https://your-project.supabase.com
    apiKey: "{{ secret('SUPABASE_API_KEY') }}"
    table: users
    data:
      status: "inactive"
      updated_at: "{{ now() }}"
    filter: "id=eq.123"

Update multiple records with complex filtering.

yaml
id: supabase_update_multiple
namespace: company.team

tasks:
  - id: update_inactive_users
    type: io.kestra.plugin.supabase.Update
    url: https://your-project.supabase.com
    apiKey: "{{ secret('SUPABASE_API_KEY') }}"
    table: users
    data:
      status: "archived"
      archived_at: "{{ now() }}"
    filter: "status=eq.inactive&last_login=lt.2023-01-01"

Update with return of specific columns.

yaml
id: supabase_update_with_return
namespace: company.team

tasks:
  - id: update_user_email
    type: io.kestra.plugin.supabase.Update
    url: https://your-project.supabase.com
    apiKey: "{{ secret('SUPABASE_API_KEY') }}"
    table: users
    data:
      email: "newemail@example.com"
      email_verified: false
    filter: "id=eq.123"
    select: "id,email,email_verified,updated_at"

Properties

apiKey *string

Supabase API key

API key sent in Authorization and apikey headers; use service_role for writes and elevated policies, anon key is limited.

data *object

Row values to apply

Map of column names to values sent as JSON after rendering expressions.

filter *string

PostgREST filter

Required filter expression (e.g., id=eq.123) that scopes which rows are updated; broad filters can modify many rows.

table *string

Target table name

Supabase table to patch; value is rendered before the request.

url *string

Supabase project URL

Base project URL (e.g., https://your-project.supabase.com); the REST path /rest/v1 is appended automatically.

options

Default

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

HTTP request options

Definitions

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

allowFailedbooleanstring

Defaultfalse

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

allowedResponseCodesarray

SubTypeinteger

List of response code allowed for this request

auth

The authentication to use.

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

type*object

passwordstring

The password for HTTP basic authentication.

usernamestring

The username for HTTP basic authentication.

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

type*object

tokenstring

The token for bearer token authentication.

io.kestra.core.http.client.configurations.DigestAuthConfiguration

type*object

passwordstring

The password for HTTP Digest authentication.

usernamestring

The username for HTTP Digest authentication.

basicAuthPasswordstring

The password for HTTP basic authentication. Deprecated, use auth property with a BasicAuthConfiguration instance instead.

basicAuthUserstring

The username for HTTP basic authentication. Deprecated, use auth property with a BasicAuthConfiguration instance instead.

connectTimeoutstring

Formatduration

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

connectionPoolIdleTimeoutstring

Formatduration

The time an idle connection can remain in the client's connection pool before being closed.

defaultCharsetstring

DefaultUTF-8

The default charset for the request.

java.nio.charset.Charset

enabledTcpExtendedKeepAlivebooleanstring

Defaulttrue

Whether to enable TCP Keep-Alive extended socket options (TCP_KEEPIDLE, TCP_KEEPINTERVAL, TCP_KEEPCOUNT).

Set to false when running on Windows workers, as these extended socket options are not supported by the Windows JDK and will cause connection failures.

followRedirectsbooleanstring

Defaulttrue

Whether redirects should be followed automatically.

logLevelstring

Possible Values

ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIED

The log level for the HTTP client.

logsarray

SubTypestring

Possible Values

REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODY

The enabled log.

maxContentLengthinteger

The maximum content length of the response.

proxy

The proxy configuration.

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

addressstring

The address of the proxy server.

passwordstring

The password for proxy authentication.

portintegerstring

The port of the proxy server.

typestring

DefaultDIRECT

Possible Values

DIRECTHTTPSOCKS

The type of proxy to use.

usernamestring

The username for proxy authentication.

proxyAddressstring

The address of the proxy server.

proxyPasswordstring

The password for proxy authentication.

proxyPortinteger

The port of the proxy server.

proxyTypestring

Possible Values

DIRECTHTTPSOCKS

The type of proxy to use.

proxyUsernamestring

The username for proxy authentication.

readIdleTimeoutstring

Formatduration

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

readTimeoutstring

Formatduration

The maximum time allowed for reading data from the server before failing.

ssl

The SSL request options

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

insecureTrustAllCertificatesbooleanstring

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.

timeout

The timeout configuration.

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

connectTimeoutstring

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

readIdleTimeoutstring

DefaultPT5M

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

pluginDefaultsRef string

Reference (ref) of the pluginDefaults to apply to this task.

schema string

Defaultpublic

Database schema

Postgres schema for the request; defaults to public and adds Accept-Profile/Content-Profile headers when set.

select string

Columns returned

Comma-separated columns to include in the response; defaults to *.

Outputs

code integer

HTTP status code

headers object

SubTypearray

Response headers

rawResponse string

Raw response body

updatedCount integer

Number of rows updated

updatedRows array

SubTypeobject

Updated rows returned

uri string

Formaturi

Executed request URI

Dataform

Tasks that run Dataform data transformations through the Dataform CLI.

Data

Pinecone

Interact with Pinecone, a managed vector database, from your Kestra workflows. Create serverless indexes, upsert vectors, query by similarity, fetch or delete vectors by ID, and inspect index statistics.

AIData

Supabase UpdateCertifiedUpdate rows in a Supabase table

Supabase Update

More Plugins in this Category

Dataform

Pinecone

Supabase Update
Certified
Update rows in a Supabase table