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

Hi Everyone

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.

User's image

Please, help me.

BhargavaGunnam-MSFT 26,136 Reputation points Microsoft Employee

2024-03-25T16:40:54.5133333+00:00

Hello Jean Pierre Patric Cid Bustos,

Welcome to the Microsoft Q&A forum.

Per the error message "Http request failed with status code 401 Unauthorized, usually this is caused by invalid credentials,"

the credentials used to access the SharePoint site are invalid or not authorized to access the requested resource.

Please verify that the credentials used to access the SharePoint site are correct(test the linked service connection) and have the necessary permissions to access the requested resource. You can check the Azure AD app registration and SharePoint site permissions to ensure that they are set up correctly.

You can also use postman to test the same to make sure the credentials provided are correct and have access.
BhargavaGunnam-MSFT 26,136 Reputation points Microsoft Employee

2024-03-26T15:09:11.77+00:00

Hello Jean Pierre Patric Cid Bustos,

I am checking to see if you had a chance to look into the above response.
Jean Pierre Patric Cid Bustos 0 Reputation points

2024-03-26T15:17:23.7366667+00:00

@BhargavaGunnam-MSFT I validated everything and I still have the same problem.
BhargavaGunnam-MSFT 26,136 Reputation points Microsoft Employee

2024-03-28T18:29:15.0033333+00:00

Hello Jean Pierre Patric Cid Bustos,

If everything looks good from your end, I suggest opening a support case so that a support engineer can further troubleshoot the issue. In case you don't have a support plan, please let me know so I can provide a one-time free support request to work on this case.