Azure Data Factory: Link connection Sharepoint

Question

Hello,

i'm trying to link in Data Factory a Sharepoint and i have some problems, when i try to copy data i have this

warning: The access token generated failed, status code: BadRequest, error message: {"error":"invalid_resource","error_description":"AADSTS500011: The resource principal named 00000003-0000-0ff1-ce00-000000000000/sener365.sharepoint.com was not found in the tenant named 1e43f7be-f580-486d-8ff2-d66cc5057ccd.  This can happen if the application has not been installed by the administrator of the tenant or consented to by any user in the tenant. You might have sent your authentication request to the wrong tenant.\r\nTrace ID: 2e5396bf-d060-47b7-b565-1c01558c4700\r\nCorrelation ID: 6942a4d4-33bd-4500-aee1-1e3e0cc193b7\r\nTimestamp: 2020-07-13 08:06:09Z","error_codes":[500011],"timestamp":"2020-07-13 08:06:09Z","trace_id":"2e5396bf-d060-47b7-b565-1c01558c4700","correlation_id":"6942a4d4-33bd-4500-aee1-1e3e0cc193b7","error_uri":"https://accounts.accesscontrol.windows.net/error?code=500011"}. Activity ID: 7ee1064a-cf74-4304-a35a-fafab863bd70.

Note: For the service principal ID i create an app registration an same for Service principal key, but i dont really know if it is correct and is it is linked to sharepoint or if i have to use some service principal ID from Sharepoint.

Thanks.

Answer 1

Hello @Carlos Colina ,

Thanks for the question and also for using this forum.

After reading the question , i was unable to make if you are trying to copy LIST or file from sharepint . Anyways if you are planning on sharepiont list you can use
https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list#prerequisites

or for file

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

For the Service prinicipal which you have created it it should have the "SharePoint Online site owner permission" ( this is called out in the above link .

Please do let me know how it goes .

Thanks& stay safe
Himanshu
Please do consider to click on "Accept Answer"** and **"Up-vote"**** on the post that helps you, as it can be beneficial to other community members