list - 为什么无法使用 REST API 从 Sharepoint 2013 库文件夹中获取文件

Question

我正在尝试使用 REST api 从 SharePoint 库中获取文件列表。为此，我使用了这个查询:

https://[Site]/_api/web/GetFolderByServerRelativeUrl('[Folder]')?$expand=Files,Folders

SharePoint 给我以下 json:

{
  "d": {
    "__metadata": {
      "id": "https://[Site]/_api/Web/GetFolderByServerRelativeUrl('[Folder]')",
      "uri": "https://[Site]/_api/Web/GetFolderByServerRelativeUrl('[Folder]')",
      "type": "SP.Folder"
    },
    "Files": { "results": [] },
    "ListItemAllFields": { "__deferred": { "uri": "https://[Site]/_api/Web/GetFolderByServerRelativeUrl('[Folder]')/ListItemAllFields" } },
    "ParentFolder": { "__deferred": { "uri": "https://[Site]/_api/Web/GetFolderByServerRelativeUrl('[Folder]')/ParentFolder" } },
    "Properties": { "__deferred": { "uri": "https://[Site]/_api/Web/GetFolderByServerRelativeUrl('[Folder]')/Properties" } },
    "StorageMetrics": { "__deferred": { "uri": "https://[Site]/_api/Web/GetFolderByServerRelativeUrl('[Folder]')/StorageMetrics" } },
    "Folders": { "results": [] },
    "Exists": true,
    "IsWOPIEnabled": false,
    "ItemCount": 4,
    "Name": "TEST",
    "ProgID": null,
    "ServerRelativeUrl": "[Folder]",
    "TimeCreated": "2016-12-01T10:50:22Z",
    "TimeLastModified": "2016-12-21T10:14:43Z",
    "UniqueId": "144967f1-512f-4180-b4a8-be8d0bfe90d9",
    "WelcomePage": ""
  }
}

如您所见，此文件夹中有 4 个项目(查看“ItemCount”属性)，但"file"字段和“文件夹”字段中均显示空结果。

我知道这个文件夹中确实有 4 个文件，因为我可以使用与 REST API 查询相同的登录名和密码直接在网站上看到它们。

我也试试这个查询:

https://[Site]/_api/web/GetFolderByServerRelativeUrl('[Folder]')/Files

答案是

{"d":{"results":[]}}

从 REST api 列出文件和文件夹是否有任何特殊的授权或需要了解的事情？

Answer 1

请使用以下 API:

https://sites.sharepoint.com/sites/test/forms/_api/Web/GetFolderByServerRelativePath(decodedurl='/sites/site or subsite URL/name Document List/name of folder')/Files

如果 JSON 显示 {"d":{"results":[]}}，则表示您选择的文件夹为空。