Azure Data Factory对SharePoint Online的OAuth身份验证失败 [英] OAuth Authentication to SharePoint Online from Azure Data Factory fails

问题描述

我正在尝试在Azure数据工厂中创建复制数据流，源是SharePoint Online文档库。根据这篇文章（https://feedback.azure.com/forums/270578-data-factory/suggestions/13872240-intergration-for-sharepoint-online-lists#{toggle_previous_statuses}）
应该是可能的。但是我被困在'授权'步骤来指定OData源。

它返回错误： 处理请求时出错，'Type = Microsoft.Data.Mashup.MashupCredentialException，Message =为OData源提供的凭据是
无效。 （来源：https：//mysharepoint.com/mysite），Source = Microsoft.Data.Mashup，'。

我也尝试过使用基本身份验证，输入我的用户名和密码，但同样的消息也失败了。

我可以连接到这个，并从中读取使用Powershell和sharepoint客户端运行时的同一站点。

任何想法为什么OAuth，甚至Basic auth都不在这里工作？

解决方案

ADF Odata源可用于读取OData源。例如，
https：//< mysite> .sharepoint.com /< mysubsite> /_vti_bin/ListData.svc。或
https：//< mysite> .sharepoint.com /< mysubsite> /_vti_bin/client.svc/web/lists 
OAuth身份验证。

您可以通过浏览器访问相同的odata供稿网址以确认凭据是否正常。

关于sharepoint的更多odata查询：https：//msdn.microsoft.com/en-us/library/office/fp142385.aspx

I'm trying to create a Copy Data flow in Azure Data Factory with the source being a SharePoint Online document library. According to this post (https://feedback.azure.com/forums/270578-data-factory/suggestions/13872240-intergration-for-sharepoint-online-lists#{toggle_previous_statuses}) it should be possible. However I am stuck at the 'Authorize' step for specifying the OData Source.

It returns an error: Error when processing request, 'Type=Microsoft.Data.Mashup.MashupCredentialException,Message=The credentials provided for the OData source are invalid. (Source at https://mysharepoint.com/mysite),Source=Microsoft.Data.Mashup,'.

I also tried using Basic Authentication, put in my username and password, and that fails with the same message as well.

I can connect to, and read from, this same site using Powershell and the sharepoint client runtimes.

Any idea why OAuth, or even Basic auth is not working here?

解决方案

Hi,

ADF Odata source could be used to read an OData feed. For example, https://<mysite>.sharepoint.com/<mysubsite>/_vti_bin/ListData.svc. or https://<mysite>.sharepoint.com/<mysubsite>/_vti_bin/client.svc/web/lists  with OAuth authentication.

You can access the same odata feed url by browser to confirm the credential is good.

More odata query about sharepoint: https://msdn.microsoft.com/en-us/library/office/fp142385.aspx

这篇关于Azure Data Factory对SharePoint Online的OAuth身份验证失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！