Apitable icon

Apitable

Interact with Apitable API

Record → Record Delete

AI-generated

Overview

This node operation deletes one or more records from a specified datasheet in Apitable. It is useful when you want to programmatically remove outdated, incorrect, or unwanted data entries from your tables within an automation workflow.

Typical use cases include:

  • Cleaning up records that meet certain criteria after processing.
  • Removing test or temporary data automatically.
  • Managing data lifecycle by deleting records no longer needed.

For example, you might configure this node to delete records by their IDs after exporting or archiving them elsewhere.

Properties

Name Meaning
Datasheet Id The unique identifier of the Apitable datasheet (table) from which records will be deleted. This is selected from available datasheets.
Record Ids A JSON array containing the IDs of the records to delete from the specified datasheet. Example: ["rec123", "rec456"]

Output

The node outputs JSON data representing the result of the delete operation. Typically, this includes confirmation of which records were successfully deleted or any errors encountered for specific record IDs.

No binary data output is involved in this operation.

Dependencies

  • Requires an API key credential for authenticating with the Apitable API.
  • Needs access to the Apitable instance URL configured in credentials.
  • Uses the Apitable REST API endpoint /fusion/v1 to perform operations.
  • The node depends on dynamically loaded datasheet options to select the target datasheet.

Troubleshooting

  • Invalid Datasheet Id: If the datasheet ID does not exist or is inaccessible, the node will fail. Verify the datasheet ID is correct and the API key has permission to access it.
  • Invalid Record Ids Format: The Record Ids property must be a valid JSON array of strings. Malformed JSON or incorrect types will cause errors.
  • Record Not Found: Attempting to delete a non-existent record ID may return an error or be ignored depending on API behavior.
  • API Authentication Errors: Ensure the API key credential is valid and has sufficient permissions.
  • Network Issues: Connectivity problems to the Apitable API endpoint will cause request failures.

Links and References

Discussion