SmartSuite icon

SmartSuite

Interact with SmartSuite API

Actions21

Record → Get Record

AI-generated

Overview

This node operation retrieves a specific record from SmartSuite based on the provided Solution ID, Table ID, and Record ID. It optionally supports returning the record with related data hydrated, which means including related or linked data within the record. This operation is useful for scenarios where you need to fetch detailed information about a particular record in a SmartSuite table, such as retrieving a customer profile, project details, or any other entity stored in SmartSuite.

Use Case Examples

  1. Fetch a customer record by its unique Record ID to display detailed customer information in a dashboard.
  2. Retrieve a project record with related tasks and team member data hydrated for comprehensive project management.
  3. Get a specific inventory item record from a warehouse management solution to check stock levels and related supplier information.

Properties

Name Meaning
Solution Select the SmartSuite Solution from which to retrieve the record. This identifies the workspace or environment containing the data.
Table Select the Table within the chosen Solution that contains the record. This identifies the specific dataset or entity type.
Record ID The unique identifier of the SmartSuite record to retrieve.
Hydrated Boolean flag to indicate whether to return the record with related data hydrated (i.e., including linked or related records).

Output

JSON

  • id - The unique identifier of the retrieved record.
  • fields - The data fields and their values for the retrieved record.
  • relatedData - Optional related or linked data included if the 'Hydrated' option is enabled.

Dependencies

  • SmartSuite API with an API key credential for authentication

Troubleshooting

  • Ensure the Solution ID, Table ID, and Record ID are correct and exist in SmartSuite; otherwise, the node will fail to find the record.
  • If the 'Hydrated' option is enabled but related data is missing, verify that the related data exists and the API permissions allow access.
  • Common error messages include authentication failures (check API credentials), resource not found (verify IDs), and permission errors (check user access rights).

Links

Discussion