Delete
Delete data from a Supabase table using the REST API.
Delete data from a Supabase table using the REST API.
Delete data from a Supabase table using the REST API.
This task deletes records from a Supabase table using the REST API with support for filtering conditions.
type: "io.kestra.plugin.supabase.Delete"Examples
Delete a specific record by ID.
id: supabase_delete_by_id
namespace: company.team
tasks:
- id: delete_user
type: io.kestra.plugin.supabase.Delete
url: https://your-project.supabase.com
apiKey: "{{ secret('SUPABASE_API_KEY') }}"
table: users
filter: "id=eq.123"
Delete multiple records with complex filtering.
id: supabase_delete_multiple
namespace: company.team
tasks:
- id: delete_inactive_users
type: io.kestra.plugin.supabase.Delete
url: https://your-project.supabase.com
apiKey: "{{ secret('SUPABASE_API_KEY') }}"
table: users
filter: "status=eq.inactive&last_login=lt.2022-01-01"
Delete with return of deleted records.
id: supabase_delete_with_return
namespace: company.team
tasks:
- id: delete_user_with_audit
type: io.kestra.plugin.supabase.Delete
url: https://your-project.supabase.com
apiKey: "{{ secret('SUPABASE_API_KEY') }}"
table: users
filter: "id=eq.123"
select: "id,name,email,deleted_at"
Properties
apiKey*Requiredstring
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.
filter*Requiredstring
Filter conditions
Filter conditions using PostgREST syntax to specify which records to delete (e.g., 'id=eq.123', 'status=eq.inactive'). Be careful with this filter as it determines which records will be deleted.
table*Requiredstring
The name of the table to delete from
The name of the table in your Supabase database
url*Requiredstring
The Supabase project URL
The URL of your Supabase project (e.g., https://your-project.supabase.com)
optionsNon-dynamic
{
"followRedirects": "true",
"allowFailed": "false",
"defaultCharset": "UTF-8"
}io.kestra.core.http.client.configurations.HttpConfiguration
falseIf true, allow a failed response code (response code >= 400)
List of response code allowed for this request
The authentification to use.
io.kestra.core.http.client.configurations.BasicAuthConfiguration
The password for HTTP basic authentication.
The username for HTTP basic authentication.
io.kestra.core.http.client.configurations.BearerAuthConfiguration
The token for bearer token authentication.
The password for HTTP basic authentication. Deprecated, use auth property with a BasicAuthConfiguration instance instead.
The username for HTTP basic authentication. Deprecated, use auth property with a BasicAuthConfiguration instance instead.
durationdurationThe time an idle connection can remain in the client's connection pool before being closed.
UTF-8The default charset for the request.
java.nio.charset.Charset
trueWhether redirects should be followed automatically.
ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIEDThe log level for the HTTP client.
REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODYThe enabled log.
The maximum content length of the response.
The proxy configuration.
io.kestra.core.http.client.configurations.ProxyConfiguration
DIRECTDIRECTHTTPSOCKSThe address of the proxy server.
The password for proxy authentication.
The port of the proxy server.
DIRECTHTTPSOCKSThe type of proxy to use.
The username for proxy authentication.
durationdurationThe maximum time allowed for reading data from the server before failing.
The SSL request options
io.kestra.core.http.client.configurations.SslOptions
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.
The timeout configuration.
io.kestra.core.http.client.configurations.TimeoutConfiguration
durationThe time allowed to establish a connection to the server before failing.
PT5MdurationThe time allowed for a read connection to remain idle before closing it.
schemastring
publicThe schema to use
The database schema to use for operations -- defaults to 'public'.
selectstring
Columns to return after deletion
Comma-separated list of columns to return from the deleted records. Defaults to '*' (all columns). Set to empty string to not return any data.
Outputs
codeinteger
The HTTP status code of the response
deletedCountinteger
The number of rows deleted
deletedRowsarray
The deleted rows returned from the database (if select was specified)
headersobject
The headers of the response
rawResponsestring
The raw response body
uristring
uriThe URI of the executed request
