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

1
votes

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://docs.microsoft.com/en-us/azure/data-factory/connector-odata

https://docs.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??

1
azuresharepointazure-data-factoryazure-blob-storage
Instead of adding too many external links you should show some code and or error. – Atul Dwivedi
@Atul Dwivedi we are using azure portal for creating pipelines so there is no code. – Hassan Akhlaq
@Atul Dwivedi I have also added the screen shot of an error – Hassan Akhlaq

1 Answers

2
votes

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://docs.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azuread