Actions61
- 电子表格 Actions
- 云空间 Actions
- 消息 Actions
- 云文档 Actions
- 日历 Actions
- 多维表格 Actions
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
jsonfield 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
errorproperty 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_tokenproperly, 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 theerrorproperty in the output for more details.- Other errors will include a message and stack trace for debugging.