Logic App - How can I SFTP all files within a blob storage folder?

Question

I am new to logic apps and I am working on one that is scheduled to run once a week. It calls a function that writes files to blob storage. I have just received the SFTP credentials and am trying to add the SFTP steps to the logic app. I've found a lot of examples of SFTPing to blob storage, but no examples showing from blob storage. I've tried the following example which gives me no file name and I've also tried "List of Blobs" which gives me a name, but no file content. Any help would be greatly appreciated!

Answer 1

@Chris and Nancy Proctor You are off the right start. You need to use both List blobs and Get blob content to achieve what you are trying.

Here is what you would have to do

1. Get the list of blobs
2. Loop over the list of blobs and for each blob
3. Get its content
4. Create file in SFTP

Note that there are limits for the blob connector and sftp connector (and your SFTP server too). Since the for each loop runs concurrently by default, you could set it to run sequentially or a limit that works each (must be less than 150 since that's the limit for the SFTP connector).