Write to Excel File and then upload that file to an SFTP folder

[stvnhdmpa]

I have a use case where I need to get data, transform it, write it to an excel template, and then upload that template to an SFTP folder.  My question is how can I ensure that the write stage is complete on the excel file before I do the SFTP upload through the "Download" tool?

Thanks in advance.

[PeterA1]

Hi @stvnhdmpa  you could use a Block Until Done Tool to achieve this orchestration. This tool mastery article also explains how you use this function. So you would have the output tool running off the "1" anchor and then the download tool off of the "2" for example. 

Let me know if this helps!

[stvnhdmpa]

Thanks @PeterA1 .  What if there is an error in the first anchor.  I've used the block until done quite a bit and I've not been able to figure out how to get the second flow to stop if there is an error in the first.  any ideas?

[PeterA1]

@stvnhdmpa You absolutely can! If you click on the canvas and go to "Runtime" settings in the configuration panel, you can set the workflow to "cancel running workflow on error" (highlighted in screenshot):

[stvnhdmpa]

@PeterA1 I have tried to use that before and it still wrote the file in the second anchor.  I'll give it another try.

[PeterA1 · Accepted solution]

@stvnhdmpa something else I thought of which might be good for this situation is using a batch macro as a blocking mechanism. It has been called the "ultimate block until done." So the idea is, your output would be contained within the batch macro, you could have an unrelated or even dummy output anchor which then flows into your download tool. Here is a post with an example workflow of this process. I can attest to this method myself. Nothing downstream will process until everything within the macro is finished.