Copy files from sharepoint to azure blob storage using logic apps

Question

How to copy files from sharepoint to azure blob storage using azure logic apps in azure data factory.

Answer 1

Hi,

Without using ADF you can achieve this, Please try to create the Logicapp like below screenshot,

Similar Question: https://learn.microsoft.com/en-us/answers/questions/898856/how-to-copy-files-from-sharepoint-to-azure-blob-st.html

Answer 2

Hey,
you can use the below blogs:

1: transfer files from logicapp
https://www.mssqltips.com/sqlservertip/5893/transfer-files-from-sharepoint-to-blob-storage-with-azure-logic-apps/

2.trigger logic app from adf
https://www.mssqltips.com/sqlservertip/6264/how-to-call-logic-app-synchronously-from-azure-data-factory/

but why use logic app when you can use ADF directly:
learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online

Answer 3

To copy files from SharePoint to Azure Blob Storage using Azure Logic Apps in Azure Data Factory, you can follow these steps:

1. Navigate to the Azure portal and sign in with your Azure account.
2. In the search bar, type "Logic Apps" and select the "Logic Apps" service.
3. Click the "Add" button to create a new logic app.
4. On the "Create logic app" blade, enter a name for your logic app and select a resource group.
5. Click the "Create" button to create the logic app.
6. In the logic app designer, click the "When a HTTP request is received" trigger to start the workflow.
7. Add an "HTTP request" action by clicking the "New step" button and selecting the "Add an action" option.
8. In the "Choose an action" blade, search for "HTTP" and select the "HTTP" action.
9. In the "HTTP" action, enter the URL of the SharePoint file you want to copy and specify the HTTP method as "GET".
10. Add a "Parse JSON" action by clicking the "New step" button and selecting the "Add an action" option.
11. In the "Choose an action" blade, search for "Parse JSON" and select the "Parse JSON" action.
12. In the "Parse JSON" action, select the output of the "HTTP" action as the content to be parsed and provide a sample JSON payload that matches the structure of the output. This will allow the logic app to parse the output of the "HTTP" action correctly.
13. Add a "Create blob" action by clicking the "New step" button and selecting the "Add an action" option.
14. In the "Choose an action" blade, search for "Create blob" and select the "Create blob" action.
15. In the "Create blob" action, specify the name of the blob to be created and select the storage account and container where the blob will be stored.
16. In the "Create blob" action, select the output of the "Parse JSON" action as the content of the blob.
17. Click the "Save" button to save your logic app.
18. After saving the logic app, you can trigger the logic app by sending an HTTP request to the logic app's URL. This will cause the logic app to execute the workflow and copy the file from SharePoint to Azure Blob Storage.

Alternatively, you can use Azure Data Factory to automate the execution of the logic app. To do this, you can create a pipeline in Azure Data Factory and add a "Logic App" activity to the pipeline. In the "Logic App" activity, you can specify the logic app that you created above and configure the input and output parameters for the logic app. You can then schedule the pipeline to run repeatedly or trigger it manually to copy the files from SharePoint to Azure Blob Storage.