HTTP connection to Sharepoint

[Barnita]

Hi all,

I am trying to connect to a Sharepoint Site from fabric using HTTP connection. For that before creating the connection, I have done the whole authentication using azure App Registration following this article

Copy data from SharePoint Online List - Azure Data Factory & Azure Synapse | Microsoft Learn

I have been able to successfully generate the access token using web activity as mentioned in the article, but stuck in copy activity.

While creating the connection in Fabric in HTTP, I am choosing anonymous as authentication type, but still its showing 'Invalid Credentials'

[NandanHegde]

Can you try using Service Principal auth directly in the conection and confirm back?
Rather than going the route of generating the OAUth token

[Barnita]

Hi,

Thank you for your reply. we dont have service principal option here. PFA

I was using anonymous so that in body i can pass the bearer token generated from a previous web activity.