Tulip icon

Tulip

Consume Tulip API

Actions13

Table → Delete All Records

AI-generated

Overview

This node interacts with the Tulip API to delete all records from a specified table. It is useful in scenarios where you need to clear out data from a table entirely, such as resetting datasets, cleaning up test data, or preparing tables for new batch imports. For example, if you have a production table that accumulates temporary records during operations, this node can be used to remove all those records at once.

Properties

Name Meaning
Table Name or ID Select the target table from a list or specify its ID via an expression. This determines which table's records will be deleted.
Allow Records In Use Boolean option to allow deletion even if some records are currently in use by running Tulip apps. If set to true, the node skips checking for active usage, but this may cause issues in apps relying on those records.

Output

The node outputs JSON data representing the result of the delete operation. Typically, this includes confirmation of successful deletion or details about any errors encountered. The output does not include binary data.

Dependencies

  • Requires an API key credential for authenticating with the Tulip API.
  • Needs network access to the Tulip service endpoint.
  • The node depends on internal methods and actions defined in bundled modules for routing requests and handling table operations.

Troubleshooting

  • Records in Use Error: If the deletion fails because some records are currently used by running apps, consider enabling the "Allow Records In Use" option to bypass this check. Be cautious as this might disrupt app functionality.
  • Invalid Table ID: Ensure the table ID or name is correct and accessible with the provided credentials.
  • Authentication Failures: Verify that the API key credential is valid and has sufficient permissions.
  • Network Issues: Confirm connectivity to the Tulip API endpoint.

Links and References

Discussion