Logic App Blob trigger to SFTP-SSH Connector - create multiple files efficiently

Question

Hi,

I've built a PoC logic app which is triggered by a Blob storage add trigger.

Once triggered the logic app reads the blob, does some conversion and uses the create file connector action on SFTP-SSH connector to create the same file on an SFTP server. All good.

I will have multiple files to upload each time from Blob, the logic app takes 5-7 seconds to run.

I'd like to bulk create files on the SFTP server (the blob connector can return up to 100 blobs), at least reuse the SFTP connection.

I haven't tried it yet, but is my best option looping round and calling the SFTP connector's create file action for each blob ? I'm concerned about the overhead of the SFTP connection.

Many thanks

Matt

Answer 1

@MattT There are no action in SFTP-SSH connectors that can create multiple files on your SFTP server on the signal call/action.
You need to loop in and create the the file using Create File action. To speed up the creation of files when you use for loop you can enable the "Concurrency Control" and specify the Degree of parallelism so multiple file can be created at the same time. In logic app you only define the API connection and internally whenever there are action called/trigger it will creates the request and use the API connection that you have define with the authentication.