Actions106
- 日历 Actions
- 多维表格 Actions
- 知识库 Actions
- 通讯录 Actions
- 任务 Actions
- 电子表格 Actions
- 云空间 Actions
- 消息 Actions
- 云文档 Actions
Overview
This node interacts with the "多维表格" (a multidimensional table service) to list fields of a specified data table. It is useful when you want to retrieve metadata about the columns or fields in a particular table within the 多维表格 platform, such as for dynamically generating UI elements, validating data schemas, or integrating table structure information into workflows.
Practical examples include:
- Fetching all field definitions from a specific table to display them in a custom dashboard.
- Using the list of fields to map incoming data before inserting or updating records.
- Paginating through large sets of fields when tables have many columns.
Properties
| Name | Meaning |
|---|---|
| 多维表格 Token | The unique identifier token for the 多维表格 App. This authenticates and scopes the request to a specific app instance. |
| 多维表格 ID | The unique identifier of the data table within 多维表格 whose fields are to be listed. |
| 视图 ID | The unique identifier of a view within the 多维表格 table. Optional; if provided, the fields may be filtered or contextualized according to this view. |
| 是否数组形式返回 | Boolean flag indicating whether text fields should be returned as arrays. If true, text-type fields will be represented as arrays rather than strings. |
| 分页标记 | Pagination token used to fetch subsequent pages of results. For the first request, leave empty to start from the beginning. When more results exist, the response includes a new pagination token to continue fetching. |
| 分页大小 | Number specifying how many fields to return per page. Defaults to 20. Controls the size of each paginated response. |
Output
The node outputs JSON data representing the list of fields retrieved from the specified 多维表格 table. Each item in the output array corresponds to a field definition, including its properties such as field name, type, and possibly other metadata depending on the API response.
If the "是否数组形式返回" property is set to true, text fields in the output will be arrays instead of plain strings.
No binary data output is indicated by the source code or properties.
Dependencies
- Requires an API authentication token ("多维表格 Token") to access the 多维表格 App.
- Needs the unique identifiers for the table ("多维表格 ID") and optionally a view ("视图 ID").
- The node depends on the 多维表格 API endpoint that lists table fields, supporting pagination via tokens and page size parameters.
- No additional external services or environment variables are explicitly required beyond the API token.
Troubleshooting
- Invalid or missing token: If the "多维表格 Token" is incorrect or expired, the node will fail to authenticate. Ensure the token is valid and has sufficient permissions.
- Incorrect table or view IDs: Providing wrong IDs will result in errors or empty results. Verify these identifiers from the 多维表格 platform.
- Pagination issues: If using pagination tokens incorrectly (e.g., reusing old tokens), the node might return errors or duplicate data. Always use the latest token returned by the previous call.
- Large page sizes: Setting "分页大小" too high might cause timeouts or API limits. Use reasonable values like the default 20.
- API errors: Network issues or API changes can cause failures. Check error messages logged by the node for details.
Links and References
- 多维表格 official documentation (for API details and authentication): [Insert actual URL here if known]
- n8n documentation on creating custom nodes and handling pagination: https://docs.n8n.io/integrations/creating-nodes/
- General API pagination concepts: https://restfulapi.net/pagination/