Record → Create or Update
AI-generatedOverview
This node interacts with Cubable to create or update records in a specified base and table. It is useful for automating data management tasks such as inserting new records or updating existing ones in Cubable databases. For example, it can be used to sync data from other applications into Cubable or to maintain up-to-date records based on external inputs.
Use Case Examples
- Creating a new record in a Cubable table from form submission data.
- Updating existing records in Cubable based on changes detected in another system.
Properties
| Name | Meaning |
|---|---|
| Authentication | Selects the authentication method to access Cubable API, currently supports Access Token. |
| Base | Specifies the Cubable Base where the record will be created or updated. Can be selected from a list or entered by ID. |
| Table | Specifies the Table within the selected Base where the record will be created or updated. Can be selected from a list or entered by ID. |
| Fields | Defines the fields and their values for the record to be created or updated. Supports mapping fields automatically or manually. |
| Ignore Fields From Input | Specifies fields to ignore from the input data when updating records, useful to prevent overwriting certain fields. |
Output
JSON
recordId- The unique identifier of the created or updated record in Cubable.fields- The data fields of the record after creation or update, reflecting the current state.
Dependencies
- Cubable API with access token authentication
Troubleshooting
- Ensure the Base and Table IDs are valid and correctly formatted to avoid validation errors.
- Verify that the access token provided has sufficient permissions to create or update records in the specified Base and Table.
- When using field mapping, ensure the field names match those in Cubable to prevent mapping errors.
- If ignoring fields, confirm that the fields listed exist in the input data to avoid unexpected behavior.