Teable (TuanDK)Install

Summary

Fetch records from a Teable table, optionally filtered, sorted, restricted to a view or fields, and either capped by a limit or fully paginated.

Inputs

• Space (required) — Teable space; used to populate the Base dropdown.
• Base (required) — Base within the space; used to populate the Table dropdown.
• Table (required) — Table to read records from (ID is validated to letters, digits, underscores, hyphens).
• Return All — If true, paginates in pages of 1000 until all records are fetched (hard cap 100,000). Default false.
• Limit — Max records to return when Return All is off (1–1000, default 100). Sent as a single request with take=limit.
• Filter Conditions — Visual list of field/operator/value conditions combined with AND. Supports is, isNot, contains, doesNotContain, isEmpty, isNotEmpty, gt/lt/gte/lte, isAnyOf, isNoneOf, hasAnyOf, hasAllOf, hasNoneOf, isWithin. Values are coerced: true/false/null and integers become typed values; list operators accept comma-separated text or a JSON array; isWithin accepts a mode string or JSON object. List operators and isWithin error if the value is empty.
• View — Additional option: restrict results to a specific view.
• Filter (JSON) — Additional option: raw Teable filter object. Overrides Filter Conditions when set.
• Order By (JSON) — Additional option: sort rules, e.g. [{"fieldId":"fldXXX","order":"asc"}].
• Selected Field IDs — Additional option: comma-separated field IDs to include; empty returns all fields.
• Field Key Type — Additional option: key response fields by name (default) or by field ID.
• Cell Format — Additional option: cell values as structured JSON (default) or plain text.

Output shape

One output item per record, each item's json being the Teable record object (typically id and fields).

Runs once per input item, so multiple input items produce combined results. With Return All off, only the first page up to Limit is returned. The request retries up to 3 times on 429/5xx errors. If Continue On Fail is enabled, failures emit an item with an error message.

Examples

Example 1: Pull all open tasks sorted by due date

Return All on; Filter Condition: Status Is 'Open'; Order By JSON [{"fieldId":"fldDue","order":"asc"}].

Example 2: Get the 50 records from the past week

Return All off, Limit 50; Filter Condition: Created Date Is Within 'pastWeek'.

Example 3: Read a view with ID-keyed fields

Select View, set Field Key Type to Field ID, Selected Field IDs 'fldA,fldB'.

Links

• n8n community nodes installation guide