Skip to main content

List Rows

Lists rows in Baserow.

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)
Table IDinTableIDThe ID of the table to list rows from

Outputs​

PropertyFieldDescription
CountoutCountNumber of rows returned in this page
Has MoreoutHasMoreTrue if there are more pages available
RowsoutRowsArray of rows matching the query
TotaloutTotalTotal number of rows matching the filter

Options​

PropertyFieldDescription
Base URLoptBaseURLBaserow base URL (required if not using Connect node)
CredentialsoptCredentialsBaserow database token (optional - use instead of Connect node)
Filter TypeoptFilterTypeHow to combine multiple filters One of: AND, OR.
FiltersoptFiltersJSON object of filters (e.g. {"filter__field_1__equal":"value"})
Order ByoptOrderByField name to sort by. Prefix with - for descending (e.g. -Name)
PageoptPagePage number for pagination (starts at 1)
Page SizeoptSizeNumber of rows per page (max 200)
SearchoptSearchFull-text search across all fields
Timeout (seconds)optTimeoutMaximum time to wait for response

Requirements​

  • A Client ID from this package's Connect node, unless you set credentials directly on this node.
  • Baserow Database Token — Database token for API access with granular table-level permissions
    • value — Database Token (password, required). Your Baserow database token

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

Get Row · Create Row · Update Row · Delete Row

Elsewhere in the package: Connect · Disconnect · List Fields · Toolkit

See also​