Baserow Plus

Production-grade Baserow node — field-type-aware serialization, decimal auto-normalization, human-readable errors, true batch API, upsert, lookup, retry with backoff, and parallel multi-table fetch.

Actions11

List

AI-generated

Summary

List rows from a Baserow table with pagination, filtering, sorting, and full-text search.

Inputs

  • tableId (required) — Baserow table ID (visible in the table URL: /database/TABLE_ID/)
  • refreshSchema — Force a fresh schema fetch from Baserow, bypassing the 5-minute cache.
  • useNames — Automatically convert between internal field IDs (field_xxx) and human-readable column names.
  • returnRaw — Return raw Baserow field keys (field_xxx) without any name conversion or value cleaning.
  • requestTimeout — Timeout for each API request in milliseconds. Increase for large batch or multi-table operations.
  • fetchAll — Automatically paginates through all rows. Disable to return a single page (up to Page Size).
  • pageSize — Number of rows per page (max 200).
  • maxRecords — Stop after collecting this many records. Set to 0 for unlimited.
  • searchQuery — Full-text search query. Baserow searches across all text-based fields.
  • includeFields — Comma-separated field names to include in the API response (server-side filtering, reduces data transfer).
  • excludeFields — Comma-separated field names to exclude from the API response (server-side).
  • sort — Sort rules with field (loaded from table fields) and direction (ascending/descending).
  • filters — Filter rules with field, operator (equal, not_equal, contains, icontains, gt, gte, lt, lte, blank, not_blank), and value.
  • selectFields — Comma-separated list of field names to include in the output (client-side). Leave empty to return all fields.

Output shape

Array of row objects. Field IDs are mapped to human-readable names by default (unless returnRaw is true). Select/linked-record values are cleaned automatically via cleanFieldValues. Client-side field filtering via selectFields is applied after mapping. Returns all matching rows up to maxRecords if specified, respecting pagination settings.

Field schema is cached per table for 5 minutes; refreshSchema bypasses the cache. Pagination loops while results fill the page and fetchAll is true, stopping when no more results, maxRecords is reached, or results fewer than pageSize when fetchAll is false.

Examples

Example 1: List all rows in a table with human-readable field names

Set tableId to the target table; leave fetchAll true (default), pageSize at 100 (default), and all other filters empty.

Example 2: List rows filtered by a text field, returning only selected columns

Set tableId, searchQuery, includeFields or excludeFields as needed, set selectFields to a comma-separated list of desired column names, and ensure useNames is true (default).

Links

Discussion