Skip to main content

Delete Record

Deletes a specific record from an Airtable table.

Common Properties

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs

  • Key Id - The key identifier returned from the Connect node.
  • Base Id - The unique identifier of the Airtable base where the record exists.
  • Table Name - The name of the table where the record exists.
  • Record Id - The unique identifier of the record to be deleted.

Output

  • result - An object containing the deletion result, including the deleted record's ID and deletion time.

How It Works

The Delete Record node removes a specific record from an Airtable table. When executed, the node:

  1. Validates the required inputs (Base Id, Table Name, and Record Id)
  2. Constructs the Airtable API endpoint URL for the specific record
  3. Retrieves the API key using the provided Key Id
  4. Sends a DELETE request to the Airtable API
  5. Returns the deletion confirmation as the result

Requirements

  • A valid Airtable account
  • An Airtable base with appropriate permissions
  • A connected Airtable session (using the Connect node)
  • Valid Base Id, Table Name, and Record Id
  • Sufficient permissions to delete records from the table

Error Handling

The node will return specific errors in the following cases:

  • Empty or invalid Key Id
  • Empty or invalid Base Id
  • Empty or invalid Table Name
  • Empty or invalid Record Id
  • Record not found (404 error)
  • Airtable API errors (e.g., insufficient permissions)
  • HTTP connection errors

Usage Notes

  • The Record Id must be the unique identifier assigned by Airtable when the record was created
  • Record Ids can be obtained from the result of Create Record, List Records, or Read Record operations
  • Once a record is deleted, it cannot be recovered through the API (unless using Airtable's backup features)
  • The node will fail if the record doesn't exist or if you don't have permission to delete it
  • Deleted records are returned in the "deleted" field of the result object

Example

To delete a specific contact record:

Inputs:

  • Key Id: (from Connect node)
  • Base Id: "appBase123"
  • Table Name: "Contacts"
  • Record Id: "recRecord123"

Output: The result will contain confirmation of the deletion:

{
"id": "recRecord123",
"deleted": true
}

Best Practices

  • Always verify the Record Id before deletion to prevent accidental data loss
  • Consider implementing confirmation steps in your automation flows for deletions
  • Use List Records or Read Record nodes to verify record existence before attempting deletion
  • Handle deletion errors appropriately in your workflows
  • Keep backups of important data before performing bulk deletions