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.

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.

logsarray

SubTypestring

Possible Values

REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODY

The enabled log.

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.

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.

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

AWS

Enterprise

Tasks that integrate AWS services into Kestra enterprise workflows including task runners and log management.

CloudCoreDataInfrastructure

Debezium DB2

Tasks that ingest IBM Db2 change data through Debezium connectors in Kestra.

Data

Supabase UpdateCertifiedUpdate rows in a Supabase table

Supabase Update

More Plugins in this Category

AWS

Debezium DB2

Supabase Update
Certified
Update rows in a Supabase table