飞书Install

Summary

Queries a Feishu Bitable table for records matching specified conditions.

Inputs

• authentication (required) — Credential type: Application-level (feishuNodeCredentialsApi) or User-level (feishuNodeOauth2Api).
• app_toke (required) — Unique identifier for the Bitable app (app_token).
• table_id (required) — Unique identifier for the specific table within the app.
• combineConditions — Logic to combine multiple conditions: 'or' (Any Condition) or 'and' (All Conditions). Defaults to 'or'.
• mustMatch — Collection of filter conditions. Each condition includes Column Name or ID, a Condition operator (e.g., equals, contains, isEmpty), and a Value. Field types dynamically load supported operators.
• options.user_id_type — Format of user IDs in multi-value fields (open_id, union_id, or user_id). Defaults to 'open_id'.
• options.timeout — Request timeout in milliseconds (0 disables timeout).

Output shape

A list of items, each containing a record with its fields and metadata (e.g., record_id, created_time).

Returns only records that match the defined 'Must Match' conditions. The operation uses the Feishu Bitable API to filter records. If no conditions are defined, behavior is not explicitly specified in the source, but the UI description indicates 'optional' conditions allow returning all records.

Examples

Example 1: Find an existing order record by email.

Set app_token and table_id. Configure 'Must Match' with Column Name 'Email', Condition 'is', and Value from input data.

Example 2: Check if a user exists using multiple conditions.

Set 'Combine Conditions' to 'and'. Add two 'Must Match' conditions (e.g., Name and Department) to verify the user exists.

Example 3: Filter for empty fields to find new records.

Set 'Must Match' with Column Name 'Completion Status', Condition 'isEmpty', and no Value.

Links

• n8n community nodes installation guide