Record → Get
AI-generatedOverview
This node retrieves a specific record from a Cubable base and table using a unique record ID. It is useful for scenarios where you need to fetch detailed information about a single record, such as viewing or processing data from a database or spreadsheet-like structure in Cubable. For example, you might use this node to get customer details, order information, or any other specific entry stored in Cubable.
Use Case Examples
- Retrieve a customer record by its unique ID to display on a dashboard.
- Fetch a specific order record to update its status or process payment.
Properties
| Name | Meaning |
|---|---|
| Authentication | Selects the authentication method to access Cubable API, currently supports Access Token. |
| Base | Specifies the Cubable base from which to retrieve the record. Can be selected from a list or entered by ID. |
| Table | Specifies the table within the selected base to retrieve the record from. Can be selected from a list or entered by ID. |
| Record ID | The unique identifier of the record to be retrieved. |
| Options | Additional options to customize the output, such as which custom fields to include, whether to expand nested custom fields, and whether to return custom fields by their field IDs. |
Output
JSON
recordID- The unique identifier of the retrieved record.base- The Cubable base from which the record was retrieved.table- The table within the base from which the record was retrieved.fields- The fields and their values of the retrieved record, including custom fields as specified by options.
Dependencies
- Cubable API access with an access token credential
Troubleshooting
- Ensure the Base and Table IDs are valid and correctly formatted to avoid validation errors.
- Verify that the Record ID exists in the specified table to prevent 'record not found' errors.
- Check that the access token used for authentication is valid and has sufficient permissions to read records.