UnauthorizedAccessException while copying file to sharepoint using rest api post method in Web Activity of Azure Data Factory

Question

0

I have a requirement to extract data from SharePoint URL (folder:/input/current) to ADLS and once the file is loaded into ADLS,I need to archive the file into the archive folder (folder:/input/archive) in the SharePoint URL.

Here is what I tried. As per the Microsoft documentation (https://learn.microsoft.com/en-au/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#copy-file-from-sharepoint-online), I registered the application with Microsoft Identity Platform and Grant ed SharePoint Online site permission to the registered application.

I am successful till the step of extracting file from SharePoint to ADLS. But I am stuck at the step where I need to archive(move or copy) the file to different folder in SharePoint. I created a web activity and gave the following inputs

1. URL :https://sharepoint_url/_api/web/GetFileByServerRelativeUrl('file path')/copyTo(strNewUrl='new file path',bOverWrite=true)
2. Body :{}
3. Headers a. Accept :application/json;odata=verbose b. Content-Type: application/json;odata=verbose c. Authorisation :@{concat('Bearer ', activity('GetBearerToken').output.access_token)}

I am getting an error

System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Access+denied.+Before+opening+files+in+this+location%2c+you+must+first+browse+to+the+web+site+and+select+the+option+to+login+automatically"

Any Help would be highly appreciated

Answer 1

Hi Sujith S,

Thank you for posting query in Microsoft Q&A Platform.

In this documentation), which you referred, we are only granting read permissions and in your requirement, you are trying to move or copy file to different location, it needs write permissions. Since you don't gave write permissions, it is failing it.

Kindly give write permissions also and try again. Below is example code to use to give read and write permissions.

<AppPermissionRequests AllowAppOnlyPolicy="true">
    <AppPermissionRequest Scope="http://sharepoint/content/sitecollection/web" Right="Read"/>
    <AppPermissionRequest Scope="http://sharepoint/content/sitecollection/web" Right="Write"/>
</AppPermissionRequests>

Hope this helps. Please let me know how it goes.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.