What is Skyvia?
Skyvia is a no-code cloud data integration platform that offers a wide range of capabilities, including ETL, ELT, Reverse ETL, data migration, and synchronization. It enables seamless data exchange between apps, databases, and cloud services, empowering organizations to streamline workflows and enhance data visibility.
Skyvia's support for SmartSuite includes:
Data Integration: Import/export SmartSuite data, replicate it to relational databases, and synchronize with other cloud apps.
Query: Access SmartSuite data with powerful querying tools.
Note: Skyvia Backup does not currently support SmartSuite.
Establishing a Connection to SmartSuite
To connect Skyvia to SmartSuite, you'll need your Workspace ID and API Key. Here's how to get started:
1. Retrieve Your Credentials
Workspace ID:
Log in to your SmartSuite workspace.
In your browser URL, locate the first eight characters after
https://app.smartsuite.com/.For example, in
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, navigate to the connection settings for SmartSuite.
Enter your Workspace ID and API Key in the corresponding fields.
Save the connection.
Connector Details and Key Features
Data Structure
Skyvia organizes SmartSuite data into several object types:
Solution Objects: Represent tables in your SmartSuite workspace, displayed with the format
<SolutionName>_<TableName>.System Objects: Includes
System_MembersandSystem_Teams(read-only).File Objects: Created for solution tables with file fields.
Comment Objects: Available for each solution table with a
*Commentssuffix.Static Objects: Includes
SolutionsandApplications.
Nested Objects
Skyvia supports importing and updating nested objects within SmartSuite. For example, fields like Checklist Items or Time Tracking Logs can be directly mapped during data import.
Filtering Capabilities
Use SmartSuite's native API filters to optimize data retrieval, such as:
Filtering by
RecordId,Date, orStatus.Combining filters with supported operators like
=,IS NULL, andIS NOT NULL.
Replication and Synchronization
Incremental updates are supported for most SmartSuite objects, ensuring efficient data replication and synchronization.
Synchronization includes support for INSERT and UPDATE operations with timestamp fields.
Supported Actions
Skyvia supports standard DML operations for SmartSuite objects, such as INSERT, UPDATE, and DELETE, ensuring robust data manipulation capabilities.
Learn More
Dive deeper into SmartSuite and Skyvia's integration capabilities by visiting SmartSuite’s Help Center or Skyvia’s Documentation.