Move/renaming files on SFTP server
I’m designing a pipeline to get a data file from an sftp server, use the data, and then rename the file to a filename with date and time and move it to an archive subfolder. I am attempting to use the pipeline from the showcase at: Move/rename script on SFTP via script Designing Pipelines Here is a pipeline that renames/moves to a different location on the same SFTP location. This uses script snap. SFTPMoveFileScript_2017_11_09.slp (8.2 KB) Is there a better way to do it now? In the sample pipeline from the showcase it includes the username and password as variables rather than snaplogics authentications as used by the File Writer snap. Is there a way I can get this pipeline to use snapalogic authentication? If not, I see that the password is encrypted (obfuscated)… What is the best way to securely pass the password into the script? Thanks, Scott
SFTP file reader for daily pulls
Hello All, We are going to start receiving delta files to a data warehouse and this is the format that our vendor specified that they will be sent over. Company_Data_Storage_TITLE_YYYYMMDD_HHMM_YYYYMMDD_HHMM.txt My question, in the file reader how would I format it so that it’ll be able to pull every day without having any issues.
