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, searching, and retrieving data. Specifically, the "Delete Row" operation enables users to remove a specific row from a given table in their Budibase application.

This node is beneficial in scenarios where automated workflows need to manage database records dynamically—for example, cleaning up outdated entries, removing user data upon request, or synchronizing external systems by deleting obsolete rows.

Practical example: Automatically delete a user record from a Budibase table when they unsubscribe from a service.

Properties

Name Meaning
Table ID The unique identifier of the table from which the row will be deleted.
Row ID The unique identifier of the row that should be deleted from the specified table.

Output

The node outputs JSON data representing the response from the Budibase API after attempting to delete the specified row. This typically includes confirmation of deletion or error details if the operation failed.

No binary data output is involved in this operation.

Dependencies

  • Requires an API key credential for authenticating with the Budibase DB Public API.
  • Needs the Budibase domain URL configured in the credentials to form the base API endpoint.
  • The node depends on HTTP requests to the Budibase API endpoints corresponding to database operations.

Troubleshooting

  • Common issues:

    • Invalid or missing Table ID or Row ID can cause the deletion to fail.
    • Incorrect or expired API authentication token may result in authorization errors.
    • Network connectivity problems can prevent communication with the Budibase API.

  • Common error messages:

    • "Unauthorized" or "Authentication failed": Check that the API key credential is correctly set and valid.
    • "Row not found": Verify that the provided Row ID exists in the specified Table ID.
    • "Invalid Table ID": Confirm the Table ID is correct and accessible with the current credentials.

Resolving these usually involves verifying input parameters, refreshing credentials, and ensuring network access.

Links and References

Discussion