teable Node icon

teable Node

teable Node

Actions4

纪录 → 获取记录

AI-generated

Summary

Fetch records from a specific Teable table with support for filtering, sorting, and result limits.

Inputs

  • base — The Teable database containing the target table.
  • tableId (required) — The target table from which to retrieve records.
  • limit — Maximum number of records to return (1 to 2000, default 100).
  • filterType — Filtering method to apply: 'none', 'manual' (condition builder), or 'json'.
  • matchType — Determines whether to match 'anyFilter' or 'allFilters' when using manual filtering.
  • filters — Collection of condition rules applied when filterType is set to 'manual'.
  • filterJson — Raw JSON string defining filter rules when filterType is set to 'json'.
  • options — Additional query settings, including field sorting configurations.

Output shape

a list of items

Returns an array of JSON objects, where each object represents a table record matching the filter criteria.

Examples

Example 1: Retrieve top 50 records from a table without filtering

Select the Base and Table ID, set limit to 50, and filterType to 'none'.

Example 2: Filter records using visual filter conditions

Set filterType to 'manual', matchType to 'allFilters', and configure specific field conditions.

Links

Discussion