Feishu Node icon

Feishu Node

Feishu Node

Overview

The "多维表格 - 查询记录" (Bitable - Search Records) operation in this custom n8n node allows users to query records from a Feishu (Lark) Bitable table. This is useful for automating workflows that need to retrieve structured data from Feishu's collaborative spreadsheet-like tables, such as reporting, synchronization with other systems, or conditional logic based on table contents.

Practical examples:

  • Fetching customer data from a CRM table for further processing.
  • Retrieving task lists or project information for automated notifications.
  • Integrating Feishu Bitable data into dashboards or analytics pipelines.

Properties

Name Type Meaning
多维表格 Token String The unique identifier (token) for the Bitable App. Required for authentication and identifying which app's tables to access.
多维表格 ID String The unique identifier of the Bitable table to query. Specifies which table's records will be retrieved.
用户 ID 类型 Options The type of user ID to use in the request. Options include Open ID, Union ID, or User ID. Determines how user context is interpreted by the API.
分页标记 String Pagination token. Leave empty for the first request; if more results are available, the response includes a new page_token to use for subsequent requests.
分页大小 Number Page size. The number of records to fetch per request. Default is 20. Useful for controlling batch sizes in large tables.
请求体JSON JSON The request body in JSON format. Allows specifying filters and other advanced query parameters. See Feishu API docs for details.

Output

  • The output is an array of objects under the json field for each input item processed.
  • Each object contains the queried records from the specified Bitable table, matching the filter and pagination criteria provided.
  • If an error occurs and "Continue On Fail" is enabled, the output will contain an object with an error property describing the issue.

Example output structure:

[
  {
    "json": {
      "items": [
        {
          "record_id": "rec123",
          "fields": {
            "Name": "Alice",
            "Email": "alice@example.com"
          }
        },
        ...
      ],
      "has_more": true,
      "page_token": "nextPageToken"
    }
  }
]
  • If binary data is returned (not typical for this operation), it would be summarized as file attachments or similar content.

Dependencies

  • External Service: Requires access to the Feishu (Lark) Bitable API.
  • API Key/Credentials: Needs valid Feishu credentials configured in n8n (feishuCredentialsApi).
  • Environment: No special environment variables required beyond standard n8n credential setup.

Troubleshooting

  • Common Issues:

    • Invalid Token or Table ID: Ensure that both the "多维表格 Token" and "多维表格 ID" are correct and correspond to accessible resources.
    • Authentication Errors: Make sure the Feishu credentials are correctly set up in n8n.
    • Pagination Problems: If not handling page_token properly, you may miss records or get repeated data.
    • Malformed JSON in Request Body: Double-check the syntax and structure of the "请求体JSON" property.
  • Error Messages:

    • "未实现方法: <resource>.<operation>": Indicates the selected resource/operation combination is not implemented in the node.
    • "NodeApiError": Usually means an error was returned from the Feishu API. Check the error property in the output for more details.
    • Other errors will include a message and stack trace for debugging.

Links and References

Discussion