Blog Post

Azure Data Factory Blog
3 MIN READ

SharePoint Online Multiple Files (Folder) Copy with Http Connector

RoshnaNazir's avatar
RoshnaNazir
Icon for Microsoft rankMicrosoft
Jul 01, 2021
ADF does not directly support copying a folder/multiple files from SharePoint Online, but there are workarounds to achieve this. Two additional steps needed here as compared to single file copy are: ...
Published Jul 01, 2021
Version 1.0
azure data factory
Copy Activity
Vasantha695's avatar
Vasantha695
Copper Contributor
Sep 09, 2022

RoshnaNazir shisyu_gaku , Can you suggest me how to copy the specific files from the folder.

I tried this from below Microsoft document.

https://docs.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online 

Files are copied to blob in different format(unreadable). I guess it is xml files.

I'm using below URL in place of Base URL of source linked service

https://bat.sharepoint.com/sites/ESGDigitalizationToolSourceFiles/_api/web/GetFileByServerRelativeUrl('/sites/ESGDigitalizationToolSourceFiles/Shared%20Documents/General/sample.csv')/$valuehttps://bat.sharepoint.com/sites/ESGDigitalizationToolSourceFiles/_api/web/GetFileByServerRelativeUrl('/sites/ESGDigitalizationToolSourceFiles/Shared%20Documents/General/sample.csv')/$valuehttps://bat.sharepoint.com/sites/ESGDigitalizationToolSourceFiles/_api/web/GetFileByServerRelativeUrl('/sites/ESGDigitalizationToolSourceFiles/Shared%20Documents/General/sample.csv')/$value