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:
Log in to your SmartSuite workspace.
In your browser’s URL, find the first eight characters after
https://app.smartsuite.com/
.Example: For
https://app.smartsuite.com/abc01cba/home
, the Workspace ID isabc01cba
.
API Key:
Log in to your SmartSuite workspace.
Click your user icon and select API Key from the menu.
Scroll to the API Key section and click Generate API Key.
Copy the generated API Key.
2. Create a Connection in Skyvia
In Skyvia, navigate to Connections and select SmartSuite.
Enter your Workspace ID and API Key in the required fields.
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
andSystem_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
andApplications
.
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
, orStatus
.Combine filters with operators like
=
,IS NULL
, andIS NOT NULL
.
Replication and Synchronization
Supports incremental updates for most SmartSuite objects.
Handles
INSERT
andUPDATE
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.