Budibase DB icon

Budibase DB

Interact with Budibase DB Public API

Actions13

Overview

The node interacts with the Budibase DB Public API, specifically allowing users to create a new row in a specified table within a Budibase application. This operation is useful when you want to programmatically add data entries to your Budibase database tables from workflows, such as inserting user-submitted form data, logging events, or syncing external data sources.

For example, you might use this node to:

  • Add a new customer record to a "Customers" table after a form submission.
  • Insert transaction details into a "Sales" table automatically from an e-commerce platform.
  • Log sensor data readings into a "Measurements" table for IoT applications.

Properties

Name Meaning
Table ID The identifier of the table where the new row will be created.
Payload The JSON object representing the data for the new row. This should match the table schema.

Output

The node outputs the response from the Budibase API after creating the row. The json output field contains the newly created row's data as returned by the API, typically including the row's unique ID and all fields with their values.

If the API supports it, the node may also output binary data, but based on the provided code and properties, the primary output is JSON data representing the created row.

Dependencies

  • Requires an active connection to the Budibase DB Public API.
  • Needs an API authentication token or key configured in the node credentials to authorize requests.
  • The base URL for the API is dynamically set from the credential domain configuration.

Troubleshooting

  • Invalid Table ID: If the provided Table ID does not exist or is incorrect, the API will likely return an error indicating the table was not found. Verify the Table ID is correct.
  • Malformed Payload: The payload must be valid JSON matching the table schema. Errors can occur if required fields are missing or types do not match. Validate the JSON structure before sending.
  • Authentication Errors: Missing or invalid API credentials will cause authorization failures. Ensure the API key/token is correctly configured.
  • Network Issues: Connectivity problems to the Budibase API endpoint will result in request failures. Check network access and API availability.

Links and References

Discussion