copy data from sharepoint using adf

prathap adicherla 1

Failure happened on 'Sink' side. ErrorCode=UserErrorInvalidCredentialToReadHttpFile,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The credential to read http file is invalid.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The remote server returned an error: (401) Unauthorized.,Source=System,'

MartinJaffer-MSFT 26,061 Reputation points

2020-12-24T02:24:38.213+00:00

Hello @prathap adicherla and welcome to Microsoft Q&A.

Are you following https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list#copy-file-from-sharepoint-online

Are there any other details you can provide?
prathap adicherla 1 Reputation point

2020-12-29T06:23:52.34+00:00

Hey Martin yes following the same link created app registration and supplied required permissions
when i run the pipeline i was getting above error.
MartinJaffer-MSFT 26,061 Reputation points

2021-01-06T00:40:42.573+00:00

Sorry for the delay @prathap adicherla .

Are you trying to load from the Sharepoint online list,
or
are you trying to load a file from sharepoint online?

They have different requirements.

One possibility is if the secure output and secure input option do not match, the token would not be the expected value. This would result in unauthorized.
MartinJaffer-MSFT 26,061 Reputation points

2021-01-12T22:06:46.503+00:00

@prathap adicherla are you still facing the issue?
MartinJaffer-MSFT 26,061 Reputation points

2021-01-13T19:12:34.29+00:00

If you found a solution, could you please share it here with the community?
PVTV 1 Reputation point

2021-08-18T14:14:15.52+00:00

Hi Martin,
I am getting same error. I am trying to read a file from sharepoint online, could you please help ?

Share via

copy data from sharepoint using adf