CopyRowsToAnotherSheet
Copy rows from one Smartsheet to another, streamlining data reorganization.
Input
| Name | Type | Required | Description |
| SheetId | String | False | The unique identifier of the source sheet from which rows will be copied. |
| RowIds | String | False | A comma-separated list of row IDs to copy from the source sheet. Required unless 'RowIdsFilePath' is provided. |
| RowIdsFilePath | String | False | The full file path to a local text file containing a comma-separated list of row IDs to be copied. Use this if 'RowIds' is not directly specified. |
| DestinationSheetId | String | False | The unique identifier of the destination sheet where rows will be copied. |
| Include | String | False | Optional. Specifies additional row elements to copy beyond cell data. Can include 'attachments', 'discussions', 'children', or 'all' to copy all elements. |
| IgnoreRowsNotFound | String | False | Optional parameter. Specifies whether to ignore missing row IDs in the source sheet. The option 'true' skips errors for missing IDs, while 'false' (the default) causes the operation to fail if any row IDs are not found. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicates whether the operation to copy rows completed successfully (true or false). |
| AffectedRows | String | The total number of rows successfully copied to the destination sheet. |