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

Lookup

AI-generated

Summary

Search Baserow table rows by field value using specified operator and return limit.

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.
  • lookupField (required) — The field to search in.
  • lookupValue (required) — The value to search for. Supports n8n expressions.
  • lookupOperator — How to match the lookup value.
  • lookupLimit — Maximum number of matching rows to return.

Output shape

array

Array of matching rows with field values mapped to human-readable names (unless returnRaw is true) and cleaned of select/linked-record formatting. If no rows match, array contains { _lookup: { field: string, value: string, operator: string, found: 0 } }.

Examples

Example 1: Find rows where 'status' column equals 'active'.

Table ID + Lookup Field = status + Lookup Value = active + Lookup Operator = equal + Max Results = 10

Links

Discussion