SmartSuite icon

SmartSuite

Interact with SmartSuite API to manage records, search data, and perform operations on your SmartSuite solutions.

Actions9

Overview

This node interacts with the SmartSuite API to manage and retrieve records within a specified SmartSuite solution and table. Specifically, the Record - Get operation fetches a single record by its ID from a chosen table in a SmartSuite solution. It optionally supports returning "hydrated" records, which include full field data rather than minimal or summarized information.

Common scenarios where this node is beneficial include:

  • Retrieving detailed information about a specific record for further processing or decision-making.
  • Integrating SmartSuite data into workflows that require up-to-date record details.
  • Fetching records dynamically based on user input or other automation triggers.

Practical example:

  • A workflow that triggers when a new email arrives, then uses this node to get detailed information about a related project record in SmartSuite by its ID, enabling subsequent steps to act on the project data.

Properties

Name Meaning
Solution Select the SmartSuite Solution containing the target table.
Table Select the Table within the chosen Solution where the record resides.
Record ID The unique identifier of the record to retrieve.
Hydrated Whether to return hydrated records with full field data (true or false).

Output

The output JSON contains the following structure:

  • success: Boolean indicating if the operation was successful.
  • data: The retrieved record object from SmartSuite, including all available fields.
  • operation: The string "get" indicating the performed operation.
  • resource: The string "record" indicating the resource type.
  • solutionId: The ID of the SmartSuite solution used.
  • tableId: The ID of the table from which the record was fetched.

If the "Hydrated" option is enabled, the data field includes full detailed field data for the record; otherwise, it may contain a more minimal representation.

No binary data output is produced by this operation.

Example output snippet (simplified):

{
  "success": true,
  "data": {
    "id": "record123",
    "field1": "value1",
    "field2": "value2"
  },
  "operation": "get",
  "resource": "record",
  "solutionId": "solution456",
  "tableId": "table789"
}

Dependencies

  • Requires an active connection to the SmartSuite API via an API key credential configured in n8n.
  • The node depends on the SmartSuite API endpoints for solutions, tables, and records.
  • Proper permissions on the SmartSuite account to read records from the specified solution and table are necessary.

Troubleshooting

  • Common issues:

    • Invalid or missing Solution ID, Table ID, or Record ID parameters will cause errors.
    • Insufficient API permissions can result in authorization errors.
    • Network connectivity problems may cause request failures.

  • Error messages:

    • Errors returned from the SmartSuite API will be propagated as error messages.
    • If the record is not found, the API typically returns a 404 error.
    • If the "Hydrated" option is set but the API does not support hydration for the record, the response may be incomplete or cause an error.

  • Resolutions:

    • Verify that the Solution, Table, and Record IDs are correct and exist.
    • Ensure the API key credential has read access to the relevant resources.
    • Check network connectivity and retry if transient errors occur.
    • Use the "continue on fail" option in n8n to handle errors gracefully in workflows.

Links and References

Discussion