Overview
This node provides integration with the Aitable.ai API, allowing users to manage records within datasheets in their Aitable workspace. Specifically, the "Delete Record" operation enables deleting an existing record from a specified datasheet by providing the relevant IDs.
Common scenarios where this node is beneficial include:
- Automating data cleanup by removing outdated or incorrect records.
- Integrating Aitable record management into broader workflows that require conditional deletion of entries.
- Synchronizing external systems by deleting records in Aitable when they are removed elsewhere.
Example: Automatically delete a project record from a datasheet when it is marked as completed in another system.
Properties
| Name | Meaning |
|---|---|
| Space ID | The unique identifier of the Aitable space containing the datasheet (e.g., spcX9P2xUcKst) |
| Datasheet ID | The unique identifier of the datasheet from which the record will be deleted (e.g., dstXXXXXXXXXXXX) |
| Record ID | The unique identifier of the record to delete within the datasheet (e.g., recXXXXXXXXXXXX) |
Output
The output JSON object contains the result of the delete operation with the following fields:
success(boolean): Indicates whether the deletion was successful.message(string): A descriptive message about the operation outcome.recordId(string): The ID of the record that was requested to be deleted.datasheetId(string): The ID of the datasheet from which the record was deleted.response(object): The full response returned by the Aitable API for further inspection.
If the deletion fails, success will be false, and the message will describe the failure reason.
The node does not output binary data.
Dependencies
- Requires an active connection to the Aitable.ai API.
- Requires an API authentication token credential configured in n8n to authorize requests.
- The node uses HTTP requests authenticated via this credential to perform operations on the Aitable API endpoints.
Troubleshooting
- Missing Required IDs: If either the Datasheet ID or Record ID is missing, the node throws an error indicating the missing parameter.
- API Errors: If the API returns an error or the deletion fails, the node outputs a failure message with details. Common causes include invalid IDs, insufficient permissions, or network issues.
- Authentication Issues: Ensure the API key credential is valid and has sufficient permissions to delete records.
- Continue On Fail: If enabled, the node will continue processing subsequent items even if one deletion fails, outputting error details in the JSON.
Links and References
- Aitable.ai Official Website
- Aitable API Documentation (Unofficial) (Note: This is a placeholder; actual docs may vary)