无法使用microsoft-graph-api获取存储在sharepoint中的工作簿中的工作表列表

Question

由于某些原因，我无法获取工作簿中的工作表列表。这可能与我的另一个问题有关，那就是can't add records in a excel table

这是调用此端点时返回给我的完整错误消息：https://graph.microsoft.com/v1.0/sites/OurSiteId/drives/OurDriveId/Items/OurFileId/workbook/worksheets

{
    "error": {
        "code": "MaxRequestDurationExceeded",
        "message": "We're sorry. We couldn't finish what you asked us to do because it was taking too long.",
        "innerError": {
            "code": "gatewayTimeoutUncategorized",
            "message": "The service wasn't able to complete the request within the time limit.",
            "innerError": {
                "code": "MaxRequestDurationExceeded",
                "message": "We're sorry. We couldn't finish what you asked us to do because it was taking too long."
            },
            "date": "2020-11-24T12:55:28",
            "request-id": "c28bc40e-4ba6-4606-8c5a-ea0663cafa29",
            "client-request-id": "c28bc40e-4ba6-4606-8c5a-ea0663cafa29"
        }
    }
}

这里描述的file limit in sharepoint工作簿似乎有一个文件大小限制，但我正在处理的文件只有40mb (限制是50mb)，并且我已经遇到了访问该文件的问题。

我正在处理的文件已经有超过一百万条记录，这可能是问题的原因吗？

Answer 1

情况可能是这样，但请确保您可以在浏览器/onedrive中打开excel文件，并且可以手动写入信息。根据经验，确保它不包含任何样式、任何空单元格/列、任何宏等