question

TanyaMani-7116 avatar image
0 Votes"
TanyaMani-7116 asked PrateekManocha-6456 commented

Copy data from SharePoint using ADF

Hi,

I am copying file from Sharepoint to ADLS using ADF. I have done all the steps mentioned in the below link:
https://docs.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list

1) Created the App
2) Provided access from SharePoint to the APP
3) Creates a web token
4) Copy activity

The copy activity is throwing below error:

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,'

Can someone please help on this?

azure-data-factory
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @TanyaMani-7116 ,
Thanks for the ask and using the Microsoft Q&A platform .

From the error it does look like to be an authentication issues , can you please check if bearer token if its valid and its in the correct format ?

Please do let me know how it goes .
Thanks
Himanshu

0 Votes 0 ·

Hello @TanyaMani-7116,
We haven’t received any email from you as requested in the last response and was just checking back to see if you have a resolution.In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, please respond back with the more details as requested and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

Hello @TanyaMani-7116,
We haven’t received any email from you as requested in the last response and was just checking back to see if you have a resolution.In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, please respond back with the more details as requested and we will try to help .
Thanks
Himanshu

0 Votes 0 ·
TanyaMani-7116 avatar image TanyaMani-7116 HimanshuSinha-MSFT ·

Hi Himanshu, The issue still persist . We have given the permission from SharePoint to the Service Principal. We have also give SharePoint API permission to the application.
Can you please help here?


0 Votes 0 ·

@TanyaMani-7116 If you were able to resolve this issue can you help me as well please , Thanks .

0 Votes 0 ·

HI @HimanshuSinha-MSFT I also face the exact same issue . everything seems fine from the look of it. Followed the documentation as mentioned in this question above. I am open to have a call with you and resolve this issue for good . Please let me know .

0 Votes 0 ·

0 Answers