SSIS Components for Smartsheet

Build 25.0.9434

DownloadAttachment

Download attachments directly from Smartsheet for offline access.

Input

Name Type Required Description
SheetID String True The unique identifier of the sheet from which the attachment will be downloaded. Required for locating the desired attachment.
AttachmentID String True A unique identifier assigned to the attachment to be downloaded. This ensures the correct file is retrieved.
Location String False The file system path where the downloaded attachment will be saved. Leave empty to use FileStream instead.
FileName String False An optional new name for the downloaded file. If not provided, the original attachment name will be used.
Override String False Determines whether an existing file with the same name at the specified Location should be overwritten. If set to false, a unique name will be generated for the downloaded file.

The default value is true.

Result Set Columns

Name Type Description
Success String Indicates whether the attachment download operation was successful (True) or encountered an error (False).
URL String A temporary URL that provides access to download the attachment directly. Note: The URL expires in 120 seconds (2 minutes).
Content String The Base64-encoded data of the downloaded file, returned when neither Location nor FileStream is provided. Useful for in-memory processing.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434