SSIS Components for Smartsheet

Build 24.0.9062

MoveRowsToAnotherSheet

Move rows form to another sheet.

Input

Name Type Required Description
SheetId String False Id of the sheet to be moved from.
RowIds String False Array of rows to move. Comma separated values. Required if RowIdsFilePath is not specified.
RowIdsFilePath String False The full path to the local text file which stores the comma separated list of Row Id-s to be moved. Required if RowIds is not specified.
DestinationSheetId String False Id of the destination sheet.
Include String False Optional. A comma-separated list of row elements to move in addition to the cell data: attachments, discussions (attachments, discussions).
IgnoreRowsNotFound String False Optional. True or False: default is False. If set to true, specifying row Ids that do not exist within the source sheet does not cause an error response. If omitted or set to false, specifying row Ids that do not exist within the source sheet causes an error response (and no rows are moved).

Result Set Columns

Name Type Description
Success String Whether or not the rows was moved successfully.
AffectedRows String The number of moved rows.

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