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