SSIS Components for Smartsheet

Build 24.0.9062

CopySheet

Copy sheets form to another folder/home/workplace.

Input

Name Type Required Description
SheetId String False Id of the sheet to be copied from.
DestinationType String False Type of the destination container (when copying or moving a folder or a sheet). One of the following values: folder, home, workspace.
DestinationId String False Id of the destination container (when copying or moving a folder or a sheet). Required if destinationType is 'folder' or 'workspace' If destinationType is 'home', this value must be null.
NewName String False Name of the newly created object (when creating a copy of a dashboard, folder, sheet, or workspace). This attribute is not supported for 'move' operations (that is, a moved dashboard, folder, sheet, or workspace retains its original name).
Include String False Optional. A comma-separated list of row elements to copy in addition to the sheet data: attachments, cellLinks - includes cross-sheet references, data - includes formatting, discussions - includes comments, filters, forms, ruleRecipients - includes notification recipients(must also include rules when using this attribute), rules - includes notifications and workflow rules, shares. NOTE: Cell history is not copied, regardless of which include parameter values are specified. Allowed values: attachments, cellLinks, data, discussions, filters, forms, ruleRecipients, rules, shares.
Exclude String False Optional. When specified with a value of sheetHyperlinks, excludes this category from the response.

Result Set Columns

Name Type Description
Success String Whether or not the Sheet was copied successfully.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062