Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,682 questions
Copy files from Sharepoint
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 73%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
Krishnamohan Nadimpalli
406
Reputation points
Hi
I am trying to copy file from Sharepoint to ADLS account using the below document.
I am able to get the access token but it says file not found. I have implemented this in the past for other project (other domain) successfully. But here it is displaying following error.
"ErrorCode=HttpRequestFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with client error, status code 403 Forbidden, please check your activity settings. If you configured a baseUrl that includes path, please make sure it ends with '/'.
Request URL: https://<domain-name>.sharepoint.com/teams/MDHDataManagementSync/_api/web/GetFileByServerRelativeUrl('/teams/MDHDataManagementSync/Shared Documents/DQC/Test_File.xlsx')/$value.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (403) Forbidden.,Source=System,'"
URL Link to Sharepoint is following
https://<domain-name>.sharepoint.com/teams/MDHDataManagementSync/Shared%20Documents/Forms/AllItems.aspx
Sharepoint Admin has set Permissions according to above document
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga 6,005 Reputation points Microsoft External Staff2023-12-22T10:12:38.13+00:00 Welcome to Microsoft Q&A platform and thanks for posting your question here.
The error message you are receiving indicates that the HTTP request failed with a client error, status code 403 Forbidden. This error message suggests that the user account you are using to access the file does not have the necessary permissions to access the file.To resolve this issue, you should check the following:
- Ensure that the user account you are using to access the file has the necessary permissions to access the file. You can check this with your SharePoint administrator.
- Check if the base URL that includes the path ends with '/'. If it does not, add it to the end of the URL.
- Verify that the file exists in the specified location.
- Check if there are any special characters in the file name or path that may be causing the issue.
- Ensure that the access token you are using is valid and has not expired.
Reference link:
https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#troubleshoot-common-issues
I hope this information helps you. Let me know if you have any further questions or concerns. -
Krishnamohan Nadimpalli 406 Reputation points
2023-12-22T10:55:30.82+00:00 Hi @Harishga
Thanks for taking up this. Permissions are available and file does exists in the path. Access Token is retrived on fly and the same is used.
Base URL : https://<domain-name>.sharepoint.com
Relative URL : /teams/MDHDataManagementSync/_api/web/GetFileByServerRelativeUrl('/teams/MDHDataManagementSync/Shared Documents/DQC/Test_File.xlsx')/$value
Please do let me know where do you want me to add "/".
-
Harishga 6,005 Reputation points Microsoft External Staff
2023-12-26T08:36:19.3333333+00:00 Hi Krishnamohan Nadimpalli
To resolve this issue, can you please add slash (/) at the end of the base URL and try once. The updated base URL should look like this: https://<domain-name>. sharepoint.com/Please note that the forward slash (/) should be added at the end of the base URL, not the relative URL.
After making this change, try running the code again and see if the issue is resolved. Let me know if you have any further questions or concerns.
-
Krishnamohan Nadimpalli 406 Reputation points
2023-12-26T08:49:48.9833333+00:00 -
Harishga 6,005 Reputation points Microsoft External Staff
2023-12-27T10:13:56.8133333+00:00 To resolve the issue with accessing the file on SharePoint, you can try the following steps:
Clear your browser cache and cookies and try again. Try to access the file from a different browser or device. If the issue still persists, contact your SharePoint administrator for further assistance or raise a Microsoft support ticket.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 84%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
asnth 0 Reputation points2024-07-17T23:03:29.45+00:00 Hi, were you able to get a solution for this?
Sign in to comment
Sign in to answer