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

Question

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 133857.png

Answer 1

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?