Upsert Row

Upsert Row — see the properties below.

This node is also exposed as an AI Agent tool.

This node has 1 input port and 1 output port.

Common Properties

Every node shares these.

Name — the node's display name on the canvas.
Color — the node's colour on the canvas.
Delay Before (sec) — wait this long before the node runs.
Delay After (sec) — wait this long after the node runs.
Continue On Error — carry on instead of failing the flow. Defaults to false.

info

When Continue On Error is true the error is not raised at all, so a Catch node will not see it either.

Property	Field	Description
Client ID	`inClientID`	Client ID from Connect node (optional if credentials provided)
Data	`inData`	Row data as JSON object (must include primary key or unique column)
Table	`inTable`	Table name

Property	Field	Description
Result	`outResult`	Upserted row data (if Return Data is enabled)

Property	Field	Description
Credentials	`optCredentials`	Supabase API key (optional - use instead of Connect node)
On Conflict	`optOnConflict`	Column(s) to determine conflict (default: primary key)
Project URL	`optProjectURL`	Supabase project URL (required if using credentials directly)
Return Data	`optReturnData`	Return the upserted row

A Client ID from this package's Connect node, unless you set credentials directly on this node.
Supabase API Key — API key for Supabase authentication. Use anon key for client-side or service_role key for server-side operations.
- value — API Key (password, required). Your Supabase anon key or service_role key from Project Settings > API

Store these in a Vault and reference the vault item from the node, rather than typing the secret into the property.