TeableInstall

Summary

Lists records from a selected Teable table, optionally filtering, sorting, limiting fields, or restricting results to a view. Enable Return All to paginate through results, up to a hard cap of 100,000 records.

Inputs

• Space, Base, Table (required) — Select the Teable space, a base within it, and the table to list records from.
• Return All — Defaults to false. When disabled, returns up to Limit records; when enabled, fetches pages of up to 1,000 records until all results are retrieved or the 100,000-record cap is reached.
• Limit — Maximum records to return when Return All is off; defaults to 100 and is configured from 1 to 1,000.
• Filter Conditions — Add field comparisons using the available operators. Conditions are combined with AND. Is Empty and Is Not Empty do not use a comparison value.
• View — Restrict results to a selected view in the table.
• Filter (JSON) — Provide a raw Teable filter object. If set, it overrides Filter Conditions.
• Order By (JSON) — Provide JSON sort rules, for example [{"fieldId":"fldXXX","order":"asc"}].
• Selected Field IDs — Comma-separated field IDs to include. Leave blank to request all fields.
• Field Key Type — Choose human-readable field names or internal field IDs for field keys; defaults to field names.
• Cell Format — Choose structured JSON or plain text cell values; defaults to JSON.

Output shape

A list of n8n items, one per returned record, with each record as the item's JSON.

With Return All off, the node reads records from the API response's records array. With Return All on, it paginates and returns up to 100,000 records. Failures throw unless Continue On Fail is enabled, in which case an item containing an error message is emitted for the input item.

Examples

Example 1: Fetch up to 100 records from a table, filtered to records where a selected field equals a value.

Set Space, Base, and Table; keep Return All off and configure Filter Conditions.

Example 2: Fetch all matching records from a particular view, sorted by a field.

Enable Return All, select View, and provide Order By (JSON).

Links

• n8n community nodes installation guide