如何使用Odata链接服务将文件从Sharepoint复制到Blob存储Azure数据工厂v2 [英] How to copy files from sharepoint into blob storage azure data factory v2 using Odata linked service

问题描述

任何人都可以帮助您了解通过Azure Data Factory管道将excel文件从共享点复制到Azure Blob存储的过程.创建Odata链接服务时，我很挣扎. odata链接服务中的服务URL是什么? 我正在使用链接此处作为服务网址: https ://xxxxx.sharepoint.com/sites/xxx/_api/web/

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/

身份验证类型:基本

当我测试连接时，我输出一个奇怪的错误:在这里

when I test connection I outputs a weird error: here

到目前为止，我已经尝试了以下文章. https://docs.microsoft.com/zh-cn/天蓝色/数据工厂/连接器数据

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

注意:当我从浏览器尝试这些剩余api网址时，它们可以正常工作，我可以下载文件等等. 还有其他方法可以实现这个目标吗?

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??

推荐答案

OData链接服务通过具有Cert身份验证类型的AAD SPN支持联机共享点.

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

可以通过遵循以下文章来创建和配置由OData连接器使用的证书，该指南将指导您将证书连接到AAD应用程序，以便使用仅应用程序访问令牌来调用SPO Online.

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/zh-CN/sharepoint/dev/solution-guidance/security-apponly-azuread

这篇关于如何使用Odata链接服务将文件从Sharepoint复制到Blob存储Azure数据工厂v2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！