Overview
This node interacts with Baserow, a no-code database platform, to perform operations on rows within a specified table. Specifically, the 'Get' operation retrieves a single row by its ID from a given table. This is useful for scenarios where you need to fetch detailed data of a specific record, such as retrieving user information, order details, or any other row-based data stored in Baserow.
Use Case Examples
- Fetch a user profile row by its ID to display detailed information in a workflow.
- Retrieve a specific order row to process or update its status in an automation.
Properties
| Name | Meaning |
|---|---|
| Host | The base URL of the Baserow API endpoint to connect to. |
| Table ID | The identifier of the table from which to retrieve the row. |
| Row ID | The identifier of the specific row to retrieve from the table. |
| Additional Options | Options to customize the request, including disabling automatic field name mapping from internal field IDs to user-friendly column names. |
Output
JSON
id- The unique identifier of the retrieved row.field_xxx or columnName- The data fields of the row, either as internal field IDs or mapped column names depending on the auto mapping setting.
Dependencies
- Requires an API key credential for authenticating with the Baserow API.
Troubleshooting
- Ensure the 'Host' URL is correct and accessible; connection errors may occur if the endpoint is wrong or down.
- Verify that the 'Table ID' and 'Row ID' are valid and exist in the Baserow instance; invalid IDs will result in errors or empty responses.
- If field auto mapping is disabled, field names will be returned as internal IDs (e.g., 'field_123'), which may require manual interpretation.
- API rate limits or permission issues may cause request failures; check API credentials and permissions.
Links
- Baserow API Documentation - Official documentation for Baserow's API endpoints and usage.