topic HTTP connection to Sharepoint in Pipelines

HTTP connection to Sharepoint

Anonymous — Wed, 04 Sep 2024 09:11:38 GMT

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'

Re: HTTP connection to Sharepoint

NandanHegde — Wed, 04 Sep 2024 10:19:22 GMT

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

Re: HTTP connection to Sharepoint

Anonymous — Wed, 04 Sep 2024 10:22:19 GMT

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.