Aitable icon

Aitable

Interact with the Aitable API
Join our community

Actions6

Overview

This node interacts with the Aitable API to manage records within datasheets. Specifically, for the Record - Delete operation, it deletes a record identified by its Record ID from a selected datasheet.

Common scenarios where this node is useful include:

  • Automating data cleanup by removing outdated or incorrect records.
  • Integrating workflows that require conditional deletion of records based on external triggers.
  • Managing data lifecycle in Aitable datasheets programmatically.

For example, you might use this node to delete a customer record after they unsubscribe from a service or to remove inventory items that are no longer available.

Properties

Name Meaning
Datasheet Select the datasheet from which the record will be deleted. Options are dynamically loaded from your Aitable spaces and datasheets.
Record ID The unique identifier of the record to delete within the selected datasheet.

Output

The output JSON contains a confirmation of the deletion operation:

{
  "success": true,
  "message": "Record deleted successfully"
}

This indicates that the record was successfully removed from the datasheet.

Dependencies

  • Requires an API authentication token credential to access the Aitable API.
  • The node makes HTTP requests to the Aitable API endpoints under https://aitable.ai/fusion/v1/.
  • The user must have appropriate permissions on the Aitable account to delete records.

Troubleshooting

  • Error: "Aitable API Error: [message]"
    This error occurs if the API request fails. Common causes include invalid Record ID, insufficient permissions, or network issues.
    Resolution: Verify the Record ID exists in the selected datasheet, check API credentials, and ensure network connectivity.

  • Record not found or cannot be deleted
    If the specified Record ID does not exist or has already been deleted, the API may return an error.
    Resolution: Confirm the Record ID is correct and current.

  • Authentication errors
    If the API token is missing or invalid, requests will fail.
    Resolution: Reconfigure the API authentication token credential with valid credentials.

  • Rate limiting or API downtime
    Temporary failures may occur due to API rate limits or service outages.
    Resolution: Retry after some time or check Aitable service status.

Links and References

Discussion