Forum Discussion
new link creation in azure data factory to SharePoint online for copying data is failing
We have set the SharePoint url, setup the app registration with site. Selected permission and generated certificate to key vault and trying to create new link for copying the data from SharePoint to data factory but at first place it;s successful while taking bearer token and while copying the data it showing below we have not passed client secret. please suggest what can be done in this case.
Message": "Failure happened on 'Source' side. ErrorCode=UserErrorFailedToGetAccessTokenByServicePrincipal,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to get access token by using service principal. Error: invalid_client, Error Message: A configuration issue is preventing authentication - check the error message from the server for details. You can modify the configuration in the application registration portal. See https://aka.ms/msal-net-invalid-client for details. Original exception: AADSTS7000215: Invalid client secret provided. Ensure the secret being sent in the request is the client secret value, not the client secret ID, for a secret added to app '\r\nTimestamp: 2023-08-02 11:14:16Z .,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.Identity.Client.MsalServiceException,Message=A configuration issue is preventing authentication - check the error message from the server for details. You can modify the configuration in the application registration portal. See https://aka.ms/msal-net-invalid-client for details. Original exception: AADSTS7000215: Invalid client secret provided. Ensure the secret being sent in the request is the client secret value, not the client secret ID, for a secret added to app '.\r\nTrace ID: \r\nCorrelation ID: 01ebcfaa-1b19-4e6c-b386-9ffb767b1292\r\nTimestamp: 2023-08-02 11:14:16Z,Source=Microsoft.Identity.Client,'",