Skip to main content
All CollectionsIntegrations
Integrating SmartSuite with Skyvia
Integrating SmartSuite with Skyvia

Effortlessly connect and manage your SmartSuite data using Skyvia's robust integration tools.

Nate Montgomery avatar
Written by Nate Montgomery
Updated over 2 weeks ago

Effortlessly connect and manage your SmartSuite data using Skyvia's robust integration tools.

Details

Answers

Plan Availability

All plan types

Permissions

Administrators: Can generate API keys for integration.

Related Reading


What is Skyvia?

Skyvia is a no-code cloud data integration platform offering various features, such as:

  • ETL/ELT: Extract, Transform, Load operations to handle complex data workflows.

  • Reverse ETL: Move data back from your database to other systems.

  • Data Migration: Simplify transferring data between platforms.

  • Data Synchronization: Ensure consistency across apps and databases.

With Skyvia's SmartSuite integration, you can:

  • Import/export SmartSuite data.

  • Replicate SmartSuite data into relational databases.

  • Synchronize SmartSuite with other cloud applications.

  • Query SmartSuite data using advanced tools.

Note: Skyvia Backup is not currently supported for SmartSuite.


Establishing a Connection to SmartSuite

To connect Skyvia to SmartSuite, you’ll need your Workspace ID and API Key. Follow these steps:

1. Retrieve Your Credentials

Workspace ID:

  1. Log in to your SmartSuite workspace.

  2. In your browser’s URL, find the first eight characters after https://app.smartsuite.com/.

API Key:

  1. Log in to your SmartSuite workspace.

  2. Click your user icon and select API Key from the menu.

  3. Scroll to the API Key section and click Generate API Key.

  4. Copy the generated API Key.

2. Create a Connection in Skyvia

  1. In Skyvia, navigate to Connections and select SmartSuite.

  2. Enter your Workspace ID and API Key in the required fields.

  3. Save the connection.


Connector Details and Key Features

Data Structure

Skyvia organizes SmartSuite data into different object types:

  • Solution Objects: Represent tables in SmartSuite (e.g., <SolutionName>_<TableName>).

  • System Objects: Includes System_Members and System_Teams (read-only).

  • File Objects: Created for tables with file fields.

  • Comment Objects: Specific to tables, identified by a *Comments suffix.

  • Static Objects: Includes Solutions and Applications.

Nested Objects

Skyvia supports importing and updating nested objects in SmartSuite, such as:

  • Checklist Items

  • Time Tracking Logs

These fields can be mapped directly during data import.

Filtering Capabilities

Skyvia leverages SmartSuite’s native API filters for efficient data retrieval:

  • Filter by RecordId, Date, or Status.

  • Combine filters with operators like =, IS NULL, and IS NOT NULL.

Replication and Synchronization

  • Supports incremental updates for most SmartSuite objects.

  • Handles INSERT and UPDATE operations with timestamp fields.

Supported Actions

Skyvia allows robust data manipulation using:

  • INSERT

  • UPDATE

  • DELETE


Practical Scenarios and Use Cases

1. Marketing Analytics Integration

Scenario: The marketing team wants to analyze campaign performance by integrating SmartSuite data with a business intelligence tool.

Solution: Use Skyvia to replicate SmartSuite data into a relational database that connects to BI platforms.

2. Streamlined Project Management

Scenario: A project manager needs to synchronize tasks between SmartSuite and a team collaboration app.

Solution: Skyvia’s synchronization ensures tasks and updates are consistent across both platforms.

3. Customer Data Consolidation

Scenario: A company wants to merge customer data from SmartSuite and a CRM system for a unified view.

Solution: Use Skyvia’s ETL tools to integrate and clean data between the systems.

Did this answer your question?