Overview
This node integrates with Baserow, a no-code database platform, to perform CRUD operations on rows within a specified table. Specifically, the 'Update' operation allows users to update a row in a Baserow table by specifying the table ID and the row ID, along with the data to update. This is useful for automating data management tasks, such as updating records based on external triggers or workflows.
Use Case Examples
- Updating a customer record in a Baserow table when new information is received from a CRM system.
- Automating inventory updates by modifying rows in a Baserow table when stock levels change.
Properties
| Name | Meaning |
|---|---|
| Host | The base URL of the Baserow API endpoint to connect to. |
| Table ID | The identifier of the Baserow table where the row to update is located. |
| Row ID | The identifier of the specific row in the table to update. |
| Additional Options | Optional settings including disabling automatic field name mapping from internal field IDs to column names. |
Output
JSON
id- The unique identifier of the updated row.field_xxx or columnName- The updated fields and their values in the row, where field names may be either internal field IDs or column names depending on auto mapping setting.
Dependencies
- Requires an API key credential for authenticating with the Baserow API.
Troubleshooting
- Ensure the provided Table ID and Row ID are correct and exist in the Baserow instance to avoid 'not found' errors.
- If field auto mapping is disabled, field names in the input data must match the internal field IDs (e.g., 'field_123') rather than column names.
- API request failures may occur if the host URL is incorrect or the API key credential is invalid or missing.
Links
- Baserow API Documentation - Official documentation for the Baserow API endpoints and usage.