Copy files from sharepoint to azure blob storage using logic apps

Anonymous
2022-06-22T06:18:33.647+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,306 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
1,821 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,415 questions
No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Nandan Hegde 21,626 Reputation points
    2022-06-22T06:31:50.613+00:00

    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


  2. Kamlesh Kumar 3,766 Reputation points
    2022-06-22T11:23:45.437+00:00

    Hi,

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

    213837-image.png

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


  3. Ravi Kanth Koppala 2,746 Reputation points Microsoft Employee
    2022-12-19T17:28:21.11+00:00

    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.

    No comments