以编程方式访问文档库中的CSV内容 [英] Programmatic access to CSV contents in a document library

问题描述

问题:

"我在文档库中有一个CSV文件.是否可以运行REST API/OData查询以返回< contents>文件的名称(不是文件的元数据/属性)? client.svc是我的最佳猜测，但是我不知道如何制定URL.的SharePoint 在线(Office 365)"

"I have a CSV file in a document library. Is it possible to run an REST API / OData query to return the <contents> of the file (not the file's metadata / properties)? client.svc is my best guess, but I don't know how to formulate the URL. SharePoint online (Office 365)"

我最终希望使用Azure数据工厂将SharePoint文档库中CSV文件的内容移动到SQL Azure.唯一受支持的oAuth接口适用于oData.

I'm ultimately looking to use Azure Data Factory to move the contents of CSV files in SharePoint document library to SQL Azure. The only supported oAuth interface is for oData.

指针将不胜感激.

Seth Sanusi

Seth Sanusi

推荐答案

您可以尝试以下方法:

https://yourtenant.sharepoint.com/sites/Developer/_api/web/getfilebyserverrelativeurl('/sites/Developer/MyDoc/testdata.csv')/

https://yourtenant.sharepoint.com/sites/Developer/_api/web/getfilebyserverrelativeurl('/sites/Developer/MyDoc/testdata.csv')/

值

这篇关于以编程方式访问文档库中的CSV内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！