CODEWITHSUNDEEP
azuresharepointazure-data-factoryazure-blob-storage
Hassan Akhlaq
Hassan Akhlaq

Reputation: 21

How to copy files from sharepoint into blob storage azure data factory v2 using Odata linked service

Can any one help in understanding procedure of copying excel file from share point to azure Blob storage through Azure Data Factory pipelines. I am struggling while creating Odata linked service. What is service url in odata linked service? I am using rest apis provided in link here as a service url :https://xxxxx.sharepoint.com/sites/xxx/_api/web/

authentication type: basic

when I test connection I outputs a weird error: here

I have tried the following articles so far. https://learn.microsoft.com/en-us/azure/data-factory/connector-odata

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-rest

Note: when I try these rest api urls from browser they work fine I can download files and so on. is there any other way of achieving this goal??

Upvotes: 1

Views: 3832

Answers (1)

Bo Xiao
Bo Xiao

Reputation: 816

Sharepoint online is supported by OData linked service through AAD SPN with Cert authentication type.

A cert using by OData connector can be created and configured by following the below article, which will guide you to connect the cert to an AAD app for invoking SPO Online with an app only access token.

https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azuread

Upvotes: 2

Related Questions