Actions16
Overview
This node interacts with the AI表格 (AI Table) service to retrieve data from a specified data table within an AI表格 instance. It is useful when you want to programmatically access and manipulate tabular data stored in AI表格, for example, to integrate AI表格 data into workflows, automate reporting, or synchronize data with other systems.
A practical example would be fetching a specific sheet's data by providing the AI表格 ID, the target sheet's ID or name, and the operator's user identifier, then using this data downstream in your automation workflow.
Properties
| Name | Meaning |
|---|---|
| AI表格ID (baseId) | The unique identifier of the AI表格 instance. Can be obtained via the "解析URL" operation. |
| 数据表ID或名称 (sheetIdOrName) | The ID or name of the target data table (sheet) within the AI表格 instance. |
| 操作人的 unionId (operatorId) | The unionId of the operator performing the action. Can be retrieved via user management. |
Output
The node outputs JSON data representing the contents of the requested data table. The structure typically includes rows and columns as retrieved from the AI表格 service. This allows subsequent nodes in the workflow to process or transform the tabular data.
If the node supports binary data output (not evident from the provided code), it would represent file attachments or similar content related to the data table, but no such indication is present here.
Dependencies
- Requires an API key credential for authenticating with the AI表格 service.
- The node depends on the AI表格 API being accessible and the provided IDs (baseId, sheetIdOrName) and operatorId being valid.
- No additional external libraries beyond standard Node.js modules are indicated.
Troubleshooting
Common issues:
- Invalid or missing AI表格 ID, sheet ID/name, or operator unionId will cause the operation to fail.
- Network connectivity problems or API authentication errors may prevent data retrieval.
- If the specified sheet does not exist or the operator lacks permission, the node will throw an error.
Error messages:
"Operation "<operation>" not found": Indicates the requested operation is not implemented or incorrectly specified.- Errors containing
"error"in the JSON output indicate failure during execution; check credentials and input parameters.
Resolutions:
- Verify all required properties are correctly set and valid.
- Ensure the API key credential is configured properly in n8n.
- Confirm that the operatorId corresponds to a user with sufficient permissions.
- Check network connectivity and API endpoint availability.
Links and References
- AI表格 official documentation (for API details and obtaining IDs)
- n8n documentation on creating and configuring API key credentials
- User management guide for retrieving operator unionId