Download tool error macro

karan1107

Hello community,

I need to download a file from SFTP which have dates present in the URL.. I am able to download if the file is present on SFTP, but if not, I want a loop to start and continue looking( a day before and so on) till it finds a file. The download tool gives an error "File not found" and stops the workflow. Can anybody help me to work with error handling. How can i ask Alteryx to start an iterative macro only if there is an error in the download tool. Example : the sftp does not have files for 9th and 8th Feb. if a user enters 9th Feb, since the file is not present, it should look for a day before(8th Feb), 8th feb is also not present, so it should look for 7th Feb and then give me the file.

danilang

Hi @karan1107 

If your begin your process with a call to get the list of file names in the directory in the FTP site, you can use this list as a filter to ensure that you're never trying to do download a file the doesn't exist.  Just use sftp://URL/Directory as the initial url, replacing URL and Directory with the correct values of the site name and directory path, respectively.  This will return a list of existing files.  Join this list with the list of files that you want to download and use the J output as the input to your main Download tool

Dan