Actions13
Overview
The node provides integration with the Budibase DB Public API, allowing users to perform various operations on Budibase database tables and rows. Specifically, the "Search Rows" operation enables querying rows within a specified table using a JSON-based query payload. This is useful for retrieving filtered data from a Budibase table based on custom search criteria.
Common scenarios include:
- Searching for records in a Budibase table that match specific conditions.
- Filtering data dynamically by constructing complex queries in JSON format.
- Integrating Budibase data retrieval into automated workflows where conditional data fetching is required.
Example: A user wants to find all rows in a customer table where the customer's status is "active". They would specify the Table ID and provide a JSON query payload defining this filter condition.
Properties
| Name | Meaning |
|---|---|
| Table ID | The identifier of the Budibase table in which to perform the search operation. |
| Query Payload | The JSON request body defining the search query. It specifies the filtering criteria for searching rows in the table. |
Output
The node outputs JSON data representing the rows returned by the search query. The structure corresponds to the response from the Budibase DB API's search endpoint, typically including an array of matching row objects with their fields and values.
If the node supports binary data output (not indicated here), it would represent any associated binary content related to the rows, but this is not evident from the provided code.
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 API requests is taken from the configured credentials domain.
Troubleshooting
- Empty or no results: Ensure the Table ID is correct and the query payload is properly structured according to Budibase API specifications.
- Authentication errors: Verify that the API key or token credential is valid and has sufficient permissions.
- Malformed JSON in Query Payload: The query must be valid JSON; syntax errors will cause request failures.
- Network issues: Confirm that the Budibase API endpoint is reachable from the n8n environment.
Links and References
- Budibase Documentation
- Budibase API Reference (for details on query payload structure and available operations)