Actions16
Overview
This node operation "删除数据表" (Delete Data Table) under the resource "AI表格" is designed to delete a specific data table within an AI-powered spreadsheet system. It is useful when you want to programmatically remove unwanted or obsolete tables from your AI spreadsheets, for example, cleaning up test data sheets or removing outdated datasets.
Typical use cases include:
- Automating cleanup of temporary or intermediate data tables.
- Managing AI spreadsheet resources by deleting tables no longer needed.
- Integrating with workflows that require dynamic modification of AI spreadsheet contents.
Properties
| Name | Meaning |
|---|---|
| AI表格ID (baseId) | The unique identifier of the AI spreadsheet (base). Can be obtained via URL parsing. |
| 数据表ID或名称 (sheetIdOrName) | The ID or name of the target data table to delete within the AI spreadsheet. |
| 操作人的 unionId (operatorId) | The unionId of the operator performing the deletion. Can be retrieved from user details. |
Output
The output of this operation will be JSON data indicating the result of the delete action. Typically, it may contain confirmation of successful deletion or error information if the operation failed.
If the node supports binary data output, it is not indicated in the provided code or properties, so the output is expected to be purely JSON structured.
Dependencies
- Requires an API key credential for authenticating with the AI spreadsheet service.
- The node depends on the external AI spreadsheet platform's API to perform the deletion.
- Proper permissions are required for the operator identified by
operatorIdto delete tables. - No additional environment variables or configurations are explicitly mentioned.
Troubleshooting
Common issues:
- Invalid or missing
baseId,sheetIdOrName, oroperatorIdparameters will cause the operation to fail. - Insufficient permissions for the operator to delete the specified table.
- Network or API errors from the AI spreadsheet service.
- Invalid or missing
Error messages:
- Errors related to "Operation not found" indicate misconfiguration of the operation parameter.
- API errors returned from the AI spreadsheet service will be passed through; check the error message for details.
Resolutions:
- Verify all required input properties are correctly set and valid.
- Ensure the operator has the necessary rights to delete the table.
- Check network connectivity and API credentials.
- Enable "Continue On Fail" option in the node settings to handle errors gracefully during batch executions.
Links and References
- Refer to the AI spreadsheet platform's official API documentation for details on deleting data tables.
- Consult user management documentation to obtain the operator's unionId.
- n8n documentation on handling API credentials and error handling best practices.