Share via

How to fix Sharepoint ErrorCode=HttpRequestFailedWithUnauthorizedError, Unauthorized, usually this is caused by invalid credentials, while downloading data from sharepoint online to blob using ADF

Prashant Joshi 0 Reputation points
2023-10-12T08:10:39.31+00:00

Hi Everyone

Hope your doing good.

Iam facing an issue while downloading files from sharepoint online using ADF..

for this process I registred app in azure and then grant the application access to the sharepoint online site ..after this i created pipeline in azure using web activity connected parallel with copy data using sink HTTPS ..but as a result iam unable to download file from sharepoint ... the error was given by copy activity

ErrorCode=HttpRequestFailedWithUnauthorizedError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with status code 401 Unauthorized, usually this is caused by invalid credentials, please check your activity settings.

Request URL: https://chiacon.sharepoint.com/sites/Powerautomate/_api/web/GetFileByServerRelativeUrl('/sites/Powerautomate/Shared Documents/Test/Test.csv')/$value.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (401) Unauthorized.,Source=System,'Screenshot 2023-10-12 134020

Screenshot 2023-10-12 133857.png

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Dimpy Kumari 0 Reputation points
    2025-02-10T15:06:31.8433333+00:00

    ErrorCode=HttpRequestFailedWithUnauthorizedError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Http request failed with status code 401 Unauthorized, usually this is caused by invalid credentials, please check your activity settings.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (401) Unauthorized.,Source=System,'

    I'm also facing the same issue, anyone able to fix this?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.