How to copy File from SFTP to Azure blob using logic app

Sharad Gawade 0

I have to create workflow which will copy file from SFTP to Azure blob storage using logic app.

2 answers

LiJia Liu 170 Reputation points MVP

2023-03-13T09:06:55.38+00:00

Please try to create a Logic app that listens to a folder on an FTP server and will copy it to an Azure Blob container. You can add an additional triggers or actions to customize it to your needs

https://learn.microsoft.com/en-us/samples/azure/azure-quickstart-templates/logic-app-ftp-to-blob/
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Sumarigo-MSFT 43,561 Reputation points Microsoft Employee

2023-03-13T10:34:20.5966667+00:00

@Sharad Gawade Welcome to Microsoft Q&A Thread, Thank you for posting your query here!

There is as similar thread discussion in the Q&A Forum, please refer to "How to move files from SFPT to Azure Blob storage using Logic Apps"

Connect to an SFTP file server from workflows in Azure Logic Apps

If you have any additional questions or need further clarification, please let me know.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.
Please sign in to rate this answer.
Sharad Gawade 0 Reputation points

2023-03-17T02:51:42.13+00:00

Hi @Sumarigo-MSFT,

Thanks for your reply.

I have followed given steps but while writing data at blob I am getting below error.

Key 'token' not found in connection profile

Sumarigo-MSFT 43,561 Reputation points Microsoft Employee

2023-03-30T17:13:37.1733333+00:00

@Sharad Gawade It seems like you are encountering an error while creating a Logic App workflow to copy a file from SFTP to Azure Blob Storage. The error message "Key 'token' not found in connection profile" indicates that there is an issue with the connection profile you are using.

To resolve this issue, you need to make sure that the connection profile you are using has the correct credentials and settings. Specifically, you need to check if the connection profile has a valid token for authentication.

Here are the steps you can follow to check and update the connection profile:

Open the Logic App workflow in the Azure portal.

Click on the "SFTP" connector and select "Edit".

In the "Connection" section, select the connection profile you want to use.

Click on the "Edit" button next to the connection profile.

Check if the connection profile has a valid token for authentication. If not, you need to update the connection profile with the correct credentials and settings.

Once you have updated the connection profile, save the changes and try running the Logic App workflow again.

If you continue to encounter issues, please let me know and I will try to assist you further.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Sharad Gawade 0 Reputation points

2023-03-31T17:27:51.2733333+00:00

Sumarigo-MSFT,

Thanks for providing steps for making a connection. Now I am able to resolve the connection-related error.

Can you please provide the steps for copying the file from sftp to blob & once done with copy need to delete it from sftp

Regards,

Sharad Gawade
Sign in to comment