Offloading with Data Shuttle and using powershell to retrieve the csv file

The ID of the csv file changes every time you run the offload. How do I pull the attachments I want to move them to a network location if the ID keeps changing?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Joann Pendleton

    Currently DataShuttle offload workflows replace files completely every time, using versioning. This means that the three cloud sources (OneDrive, Google Drive, Box) create a new version of the file using their own versioning system, or there's a new version of the CSV attached in Smartsheet.

    Please let the Product team know about your use-case and feedback by filling in this form, here!

    Cheers,

    Genevieve

  • It works fine for Google Drive, One Drive, Box and replaces the file. That is what I ultimately ended up using then used a file sync to bring it down to a network drive. But when using the API, you would need to use code to pull the most recent version because the Attachment ID changes every time, which is unnecessarily complicated... (for me)