Budibase DB

Overview

The node interacts with the Budibase DB Public API, specifically allowing operations on database tables and rows within a Budibase application. The "Update Row" operation updates an existing row in a specified table by sending a JSON payload with the new data for that row.

This node is useful when you want to programmatically modify data stored in Budibase tables as part of an automated workflow. For example, you could update user information, change status flags, or correct entries based on external triggers or inputs from other systems.

Properties

Output

The node outputs JSON data representing the response from the Budibase API after attempting to update the row. This typically includes the updated row's details or confirmation of the update operation.

If the node supports binary data output (not indicated here), it would represent any file or media content returned by the API, but this operation primarily deals with JSON data.

Dependencies

• Requires an API key credential for authenticating with the Budibase DB Public API.
• Needs the base URL of the Budibase instance configured in credentials.
• The node depends on the Budibase API being accessible and the provided Table ID and Row ID being valid.

Troubleshooting

• Invalid Table ID or Row ID: If these identifiers are incorrect or do not exist, the API will likely return an error indicating the resource was not found. Verify IDs before running the node.
• Malformed Payload: The JSON payload must conform to the expected schema of the table. Invalid or incomplete JSON may cause the update to fail.
• Authentication Errors: Ensure the API key credential is correctly set up and has sufficient permissions.
• Network Issues: Connectivity problems to the Budibase instance will prevent the node from completing successfully.

Links and References

• Budibase Documentation
• Budibase API Reference (for detailed API usage and schemas)