Actions11
多维表格 / Bitable → 搜索记录 / Search Records
AI-generatedSummary
Search Bitable records with filter conditions, supporting pagination, sorting, and field selection.
Inputs
- appToken (required) — Unique identifier of the Bitable app
- tableId (required) — Unique identifier of the table
- filter — Search filter JSON. Example: {"conjunction":"and","conditions":[{"field_name":"Status","operator":"is","value":["Active"]}]}
- returnAll — Whether to return all results or only up to a given limit
- limit — Maximum number of results to return (ignored if returnAll is true). Min 1, max 500.
- options.userIdType — User ID type for the search. Options: Open ID, Union ID, User ID (default: open_id)
- options.simplify — Whether to return simplified response (record_id + fields only). Default: true
- options.automaticFields — Whether to include auto-generated fields (created_time, modified_time, etc.). Default: false
- options.fieldNames — Comma-separated field names to return; leave empty for all.
- options.sort — Sort conditions. Example: ["field_name":"Created","desc":true]
- options.viewId — Filter records by a specific view ID
Output shape
Array of record objects. When simplify is true (default), each record is { record_id, fields }. When false, the full record object from the API is returned.
The node's router wraps each record as { json: record, pairedItem: { item: index } }.