sharepoint - 通过 Graph API 获取 Sharepoint 列表的列信息：得到冲突的结果

问题描述

我想通过 Graph API 检索 SharePoint 列表的列（字段）名称。根据文档，我可以通过expand请求中的查询来做到这一点：

GET https://graph.microsoft.com/v1.0/sites/xxx/lists/yyy?expand=columns

在我的站点中使用一个小型自动生成的列表进行测试（并在使用删除列之后columnGroup == "_Hidden"），我得到以下信息：

 [1] "Title"                     "ComplianceAssetId"        
 [3] "wikiCanvasId"              "wikiPageId"
 [5] "wikiTitle"                 "wikiContent"
 [7] "wikiUser"                  "wikiTimestamp"
 [9] "wikiDeleted"               "wikiSession"
[11] "wikiSpare1"                "wikiSpare2"
[13] "wikiSpare3"                "wikiConversationId"       
[15] "wikiMetadata"              "wikiOrder"
[17] "ID"                        "Modified"
[19] "Created"                   "Author"
[21] "Editor"                    "_UIVersionString"
[23] "Attachments"               "Edit"
[25] "LinkTitleNoMenu"           "LinkTitle"
[27] "DocIcon"                   "ItemChildCount"
[29] "FolderChildCount"          "_ComplianceFlags"
[31] "_ComplianceTag"            "_ComplianceTagWrittenTime"
[33] "_ComplianceTagUserId"      "_IsRecord"
[35] "AppAuthor"                 "AppEditor"

然后我根据请求获取此列表的实际项目

GET https://graph.microsoft.com/v1.0/sites/xxx/lists/yyy/items?expand=fields

当我检查这些项目时，它们在下面有以下字段名称fields：

 [1] "@odata.etag"               "Title"
 [3] "wikiTitle"                 "wikiOrder"
 [5] "id"                        "ContentType"
 [7] "Modified"                  "Created"
 [9] "AuthorLookupId"            "EditorLookupId"
[11] "_UIVersionString"          "Attachments"
[13] "Edit"                      "LinkTitleNoMenu"
[15] "LinkTitle"                 "ItemChildCount"
[17] "FolderChildCount"          "_ComplianceFlags"
[19] "_ComplianceTag"            "_ComplianceTagWrittenTime"
[21] "_ComplianceTagUserId"      "AppAuthorLookupId"
[23] "AppEditorLookupId"         "wikiCanvasId"
[25] "wikiUser"                  "wikiTimestamp"
[27] "wikiDeleted"               "wikiMetadata"
[29] "wikiPageId"

大多数列名匹配，但有些不匹配。它们不应该是相同的吗？

有问题的列表是“频道 {some-id}@thread.skype 的画布项目”，如果重要的话。

标签： sharepointmicrosoft-graph-apisharepoint-list

sharepoint - 通过 Graph API 获取 Sharepoint 列表的列信息：得到冲突的结果

问题描述

解决方案

推荐阅读