Copy files from Sharepoint

Hi Krishnamohan Nadimpalli

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://video2.skills-academy.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.

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 "/".

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.

Hi @Harishga

I tried adding / at baseurl but is not working.

Hi @Krishnamohan Nadimpalli

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.