Smartsheet

Smartsheet is a cloud service for work management and collaboration.

Data integration: Skyvia supports importing data to and from Smartsheet, exporting Smartsheet data to CSV files, replicating Smartsheet data to relational databases, and synchronizing Smartsheet data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support Smartsheet.

Query: Skyvia Query supports Smartsheet.

Establishing Connection

When creating a connection, log in with Smartsheet. Skyvia stores only the OAuth authentication token. Skyvia does not store Smartsheet credentials.

Creating Connection

To connect to Smartsheet, perform the following steps:

connection

  1. Click Sign In with Smartsheet in the connection editor in Skyvia.

    login

  2. Enter your Smartsheet credentials or select another available service to log in.

    permission

  3. Give Skyvia permission to perform actions in Smartsheet.
  4. Click Create Connection when the token is generated.

Additional Connection Parameters

Suppressing Extended Requests

Smartsheet API returns only part of the fields for some objects when querying multiple records. To query the values of additional fields, Skyvia performs additional extended requests for each record of such an object. However, this can decrease performance and significantly increase the number of API calls.

To reduce the number of API calls, select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in Smartsheet because its API does not return them without extended requests.

Connector Specifics

Sheets

To insert data into the Sheets table, you must map either the FromId or the Columns field in addition to the required field Name.

Reports

The Start column is used for filtering and does not return any data when selecting data from it. Thus, it is not necessary to add this column to the selection. If you set the filter by the Start column, the result will contain data modified on the specified date or later.

UpdateRequests and SentUpdateRequests

The planned update requests are stored in the UpdateRequests table. After the update requests are sent, they are displayed in the SentUpdateRequests table.

When inserting into the UpdateRequests table, specify the Schedule_StartAt field value in the DateTime format with the time value 00:00:00. For example 11/23/2022 00:00:00.

Events

When selecting data from the Since and StreamPosition, the returned result is empty for these columns,

When querying data from the Events table, set the filter by one of these fields, not by both. Only the =(equal to) operator is supported.

Columns

There is a limitation for the INSERT/UPDATE operations against the Columns table. when mapping the Validation field by the Constant, use the True value only. Do not map this field if the record must have the False value.

Stored Procedures

A part of the Smartsheet functionality is implemented in Skyvia as stored procedures:

Use call DeactivateUser(:userId) to deactivate the user. The specified user cannot access Smartsheet after the procedure execution.

Use call ReactivateUser(:userId) to reactivate the specified user. The user becomes able to access Smartsheet after the procedure execution.

Use call MakeAlternateEmailPrimary(:userId,:alternatEmailId) to make the existing alternative email the primary email for the specified user.

DML Operations

Operations Objects
INSERT, UPDATE, DELETE Columns, Groups, Sheets, UpdateRequests, Users, Workspaces
INSERT, DELETE AlternateEmails, Discussions
UPDATE, DELETE Proofs, SheetShares, WorkspaceShares
INSERT CrossSheetReferences, HomeFolders, ProofDiscussions, WorkspaceFolders
DELETE Attachments

Incremental Replication and Synchronization

Skyvia supports the Replication with Incremental Updates for the following Smartsheet objects:

WorkspaceShares, Sheets, SheetShares, SheetSummaryFields, Attachments, UpdateRequests, Groups, ProofAtttachments, Reports.

Incremental Replication considers only the new records for the Attachments and ProofAttachments tables. These tables contain only the CreatedDate field, and there is no UpdatedDate field which would have allowed considering the updated records.

Skyvia supports Synchronization for the Sheets, UpdateRequests, Groups tables.

Supported Actions

Skyvia supports all the common actions for Smartsheet.