Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 89%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Hi, I have the same error. Does somebody already have the solution?
Copy data from SharePoint using ADF
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 24%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tanya Mani
21
Reputation points
Hi,
I am copying file from Sharepoint to ADLS using ADF. I have done all the steps mentioned in the below link:
https://learn.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
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator2021-05-05T19:47:58.507+00:00 Hello @Tanya Mani ,
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 -
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
2021-05-10T17:43:05.25+00:00 Hello @Tanya Mani ,
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 -
HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
2021-05-11T18:31:10.11+00:00 Hello @Tanya Mani ,
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 -
Tanya Mani 21 Reputation points
2021-05-13T16:23:27.997+00:00 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? -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 44%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Prateek Manocha 1 Reputation point2021-09-21T14:39:40.473+00:00 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 .
-
Prateek Manocha 1 Reputation point
2021-09-21T14:40:39.013+00:00 @Tanya Mani If you were able to resolve this issue can you help me as well please , Thanks .
Sign in to comment
2 answers
Sort by: Most helpful
-
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 48%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nico Deunk | Bliksems! 1 Reputation point2022-06-14T12:22:32.48+00:00 Same problem over here.
Followed the steps from : connector-sharepoint-online-list
-
Nico Deunk | Bliksems! 1 Reputation point
2022-06-14T14:12:04.377+00:00 Solved on our side, it works now.
There was a typo in our Bearer-token retreival. ':)
So in our case, this guide worked: copy-files-from-sharepoint-into-azure-data-lake-st.html
Sign in to comment -