Forum Discussion
Copy zip files from SharePoint to Azure Blob using adf
I'm currently trying to get a zip file from a Sharepoint folder to my Azure Blob storage. The SharePoint environment belongs to a partner company. I have a personal login/password to manually access this SPO without any kind of VPN or MFA. I was trying to use Azure Data Factory to get the file daily automaticaly.
On Azure Data Factory Documentation, I got the impression that I would need to register an App on Azure AD and then, request the Sharepoint owner to give permission to my registered App so I can access it. Is my understanding is correct? And, if so, is there a easier way of doing it? Specially one that does not require me to request the Sharepoint owner to "add" me to his white list.
5 Replies
- I believe the best option is to register your app and configure your sharepoint API, then use a web activity in your ADF to send a request to sharepoint API. sharepoint generate access token that can be used in ADF to read from sharepoint. you can check this documentation
https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory - Easier to move files from sharepoint to Azure Blob Storage with Logic apps
- Thank you for the reply. I looked into that, but all the Sharepoint sites I see on Logic App are the ones from my own company. Not the partners Sharepoint. When I give a custom url for the actual Sharepoint folder/file I need, I receive a message saying I do not have permission. Searching at a few forums, people are suggesting you might need root access to the Sharepoint site you are trying to connect. The partner used my company login/password to give me access to the folders I´m supposed to see/access. He will not garant me root access for sure. Is there other way?
Hello
I had the same problem. I had access to a folder but did not have access to the entire path. I have written the path directly to JSON from Logic Apps.
