Failed to copy data from sharepoint in azure data factory pipeline using copy job

Anonymous
2022-06-14T12:55:00.87+00:00

I tried to copy files from sharepoint shared document into data factory with OAUTH2 token, I have successfully get the access token by sending "POST" request to https://accounts.accesscontrol.windows.net/xxxxxx/tokens/OAuth/2. I set up a copy activity by sending "GET" request to sharepoint, putting the following statement as the "Additional headers".
@{concat('Authorization: Bearer ',activity('Get Token').output.access_token)}
I also received "Connection successful" in link service connection test, but the following error occurred after executing the copy activity.
211268-image.png

I have checked that the permission "Sites.Read.All" has been granted to my registered application, does anyone run into the same problem?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Microsoft 365 and Office SharePoint Development
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.