Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

HTTP connection to Sharepoint

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'

 

pipelines

2 Replies

  • NandanHegde's avatar
    NandanHegde
    Super User
    1 year ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.