Budibase DB icon

Budibase DB

Interact with Budibase DB Public API

Actions13

Overview

The node interacts with the Budibase DB Public API, allowing users to perform various database operations such as creating, updating, deleting rows and tables, as well as retrieving and searching data. Specifically, the "Delete Table" operation enables users to delete an entire table from a Budibase application by specifying its Table ID.

This node is beneficial in scenarios where automated management of Budibase databases is required, such as cleaning up unused tables, managing app lifecycle, or integrating Budibase data management into broader workflows. For example, a user might automate the deletion of temporary tables after processing data or remove obsolete tables during app updates.

Properties

Name Meaning
Table ID The unique identifier of the table to be deleted. This property is required for the Delete Table operation.

Output

The node outputs JSON data representing the response from the Budibase API after attempting to delete the specified table. Typically, this will include confirmation of deletion or error details if the operation failed.

No binary data output is indicated for this operation.

Dependencies

  • Requires an API key credential for authenticating with the Budibase DB Public API.
  • The node expects the base URL of the Budibase instance to be provided via credentials.
  • Proper permissions on the Budibase API are necessary to perform table deletions.

Troubleshooting

  • Common Issues:

    • Invalid or missing Table ID: Ensure the Table ID is correctly specified; otherwise, the API will reject the request.
    • Authentication errors: Verify that the API key credential is valid and has sufficient permissions.
    • Network or connectivity problems: Confirm that the Budibase instance URL is reachable from n8n.

  • Error Messages:

    • Unauthorized or Forbidden: Indicates issues with API credentials or insufficient permissions.
    • Not Found: The specified Table ID does not exist.
    • Bad Request: Malformed request, possibly due to incorrect Table ID format.

Resolving these typically involves verifying input parameters, checking API credentials, and ensuring network accessibility.

Links and References

Discussion