SmartSuite icon

SmartSuite

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

Actions9

Overview

This node integrates with the SmartSuite API to manage and retrieve data from SmartSuite solutions, specifically focusing on operations related to tables and records within those solutions. For the Table - List operation, it lists all tables available in a specified SmartSuite solution.

Common scenarios where this node is beneficial include:

  • Automating workflows that require fetching metadata about tables in a SmartSuite solution.
  • Dynamically retrieving table lists to populate dropdowns or for further processing in automation pipelines.
  • Integrating SmartSuite table data into other systems by first enumerating available tables.

Practical example:

  • A user wants to get an overview of all tables in a particular SmartSuite solution to decide which table to query or update next in their workflow automation.

Properties

Name Meaning
Solution Select a SmartSuite Solution (required). This property lets you choose the specific SmartSuite solution whose tables you want to list. The options are dynamically loaded from your connected SmartSuite account.

Output

The output JSON structure for the Table List operation contains:

  • success: Boolean indicating if the operation was successful.
  • data: An array of table objects representing each table in the selected solution. Each object includes details such as table ID, name, label, description, icon, and other metadata returned by the SmartSuite API.
  • operation: The operation performed, here always "list".
  • resource: The resource type, here always "table".
  • solutionId: The ID of the SmartSuite solution queried.

Example output snippet:

{
  "success": true,
  "data": [
    {
      "Id": "table1",
      "Name": "Projects",
      "Label": "Projects",
      "Description": "Project management table",
      "Icon": "folder"
      // ... other table metadata
    },
    {
      "Id": "table2",
      "Name": "Tasks",
      "Label": "Tasks",
      "Description": "Task tracking table",
      "Icon": "check-square"
      // ... other table metadata
    }
  ],
  "operation": "list",
  "resource": "table",
  "solutionId": "your-solution-id"
}

Dependencies

  • Requires a valid connection to the SmartSuite API via an API key credential configured in n8n.
  • The node uses the SmartSuite API endpoints to fetch solutions and tables.
  • The solutionId must be provided and valid to successfully list tables.

Troubleshooting

  • Empty or no tables returned:
    Ensure the solutionId is correct and that the solution contains tables. Also verify that the API credentials have sufficient permissions to access the solution.

  • Authentication errors:
    Check that the API key credential is correctly set up and has not expired or been revoked.

  • API request failures or timeouts:
    Network issues or SmartSuite service outages can cause failures. Retry after some time or check SmartSuite status.

  • Invalid solutionId parameter:
    If the solution ID is invalid or missing, the node will fail to retrieve tables. Use the dynamic options loading feature to select a valid solution.

Links and References

Discussion