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
Krishnamohan18371837's avatar
Krishnamohan18371837
Copper Contributor
Aug 16, 2022

Hi RoshnaNazir 

 

I am unable to get output for the second activity. I am getting error as "Details{"odata.error":{"code":"-2147024891, System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Attempted to perform an unauthorized operation."}}}"

I suspect problem is the URL.

Below are my settings in second pipeline

URL

https://{site_url}/_api/web/GetFolderByServerRelativeUrl('sites/AsahixCUBDataAnalytics/Shared Documents')/Files

 

My files reside in the following sharepoint site. How exactly do I need to give URL in above settings.

https://{site_url}/sites/AsahixCUBDataAnalytics/Shared%20Documents/Forms/AllItems.aspx?csf=1&web=1&e=XBe00O&cid=3470fede%2Dc551%2D4331%2Db917%2Dca88e6b17c84&RootFolder=%2Fsites%2FAsahixCUBDataAnalytics%2FShared%20Documents%2FGeneral%2FMeeting%20Slides&FolderCTID=0x012000FA928A448CE5CB4C97374671C2247D52

 

I tried the following

https://{site_url}/_api/web/GetFolderByServerRelativeUrl('sites/AsahixCUBDataAnalytics/Shared Documents')/Files

https://{site_url}/_api/web/GetFolderByServerRelativeUrl('sites/AsahixCUBDataAnalytics/Shared Documents/General/Meeting Slides')/Files

https://{site_url}/_api/web/GetFolderByServerRelativeUrl('Shared Documents/General/Meeting Slides')/Files.

 

 

Anyone in the group can let me know.