Actions16
Overview
This node interacts with the "AI表格" (AI Table) service to retrieve a specific record from a data table. It is designed to fetch detailed information about one record identified by its unique record ID within a specified AI table and sheet.
Common scenarios where this node is useful include:
- Automating workflows that require fetching detailed data from an AI-powered spreadsheet or database.
- Integrating AI表格 data into other systems or processes, such as reporting, notifications, or further data processing.
- Retrieving user-specific or operation-specific records dynamically based on input parameters.
For example, you might use this node to get a customer's order details stored in an AI表格 sheet by providing the table ID, sheet name, and record ID, then use that data downstream in your workflow.
Properties
| Name | Meaning |
|---|---|
| AI表格ID (baseId) | The unique identifier of the AI表格 base (table). Can be obtained via the "解析URL" operation. |
| 数据表ID或名称 (sheetIdOrName) | The target data sheet's ID or name within the AI表格 base. |
| 记录ID (recordId) | The unique identifier of the record to query within the specified sheet. |
| 操作人的 unionId (operatorId) | The unionId of the operator performing the action. Can be retrieved from user management. |
Output
The node outputs JSON data representing the requested record's details from the AI表格. The structure typically includes all fields and values stored in that record.
If the node supports binary data output (not explicitly shown in the provided code), it would represent any file attachments or media associated with the record. However, based on the static analysis, the primary output is JSON containing the record data.
Dependencies
- Requires an API key or authentication token credential configured in n8n to access the AI表格 service.
- Depends on the AI表格 API endpoints to fetch record data.
- No additional external libraries are explicitly required beyond standard Node.js modules and n8n workflow utilities.
Troubleshooting
- Missing or invalid IDs: Ensure that the
baseId,sheetIdOrName, andrecordIdare correctly provided and correspond to existing resources in AI表格. - Authentication errors: Verify that the API credentials are correctly set up and have sufficient permissions to read records.
- Record not found: If the specified record ID does not exist in the given sheet, the node may throw an error or return empty data.
- Operation not found error: This occurs if the operation parameter is incorrect or missing; ensure "获取记录" (get record) operation is selected.
- Continue on Fail: If enabled, the node will output error messages per item instead of stopping execution, which helps in batch processing scenarios.
Links and References
- AI表格 Official Documentation (example placeholder, replace with actual URL)
- n8n Documentation on Creating Custom Nodes
- Dingtalk API Reference (since the bundled code references Dingtalk, possibly related)
Note: The summary is based solely on static analysis of the provided source code and property definitions.