Moving Excel File from SharePoint to SFTP

[skustes]

I've created an automation to dump a straight table into an Excel file on SharePoint. Sometimes we will also need to deliver this file to an SFTP destination.

The way I'm doing this is:

• Use the "Open File on Microsoft SharePoint" block to open the file that was just created
• Then "Read Data from File on Microsoft SharePoint" to extract its contents
  • Within the loop, append each item to a variable vFileContents
• Then "Write Line to File on SFTP" to write vFileContents into the file
• Save and close the file on SFTP

This method does create the file in the correct destination within our SFTP site, however, the resulting file is corrupted. Excel can repair the file and the data is correct, however, it would be nice if I could accomplish this without the final output being corrupted.

Is there a better method to accomplish such a file move from SharePoint to SFTP?

[salmankojar · Accepted solution]

Hi @skustes 

Instead of Reading data from the SharePoint file and writing it in SFTP File, you can directly Copy/Move the file from SharePoint to SFTP using Copy/Move block of SFTP.

[skustes]

Thanks @salmankojar, that's the solution I ended up arriving at, as well.