Skip to main content

SQL Query

SQL Query — 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.

Inputs​

PropertyFieldDescription
Client IDinClientIDClient ID from Connect node (optional if credentials provided)
SQL QueryinSQLSQL query to execute (e.g. SELECT * FROM Table1 WHERE Status

Outputs​

PropertyFieldDescription
CountoutCountNumber of rows returned
ResultsoutResultsQuery results as array of row objects

Options​

PropertyFieldDescription
Base URLoptBaseURLSeaTable server URL (required when using credentials without Connect node
CredentialsoptCredentialsSeaTable API Token (optional - use instead of Connect node)

Requirements​

  • A Client ID from this package's Connect node, unless you set credentials directly on this node.
  • SeaTable API Token — API Token for SeaTable base access. Grants read or write access to one base.
    • value — API Token (password, required). API Token from SeaTable base settings

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

Create Row · Get Row · List Rows · Update Row · Delete Row · Lock Row · Unlock Row · Search Rows

Elsewhere in the package: Connect · Disconnect · Create Link · Delete Link · Upload File · Get Asset URL · Get Metadata · API Call · Toolkit

See also​