無法獲取 Excel 工作表詳細信息
我在用一個網上平台收集資訊,它收集每天員工填寫的資訊然後傳到One Drive的excel入面,可是用了半年,突然要authenticate,但當我authenticated,他沒任何動作,然後就一直什麼資訊都傳不過去,當我移除再重新連接,結果不知連到那個帳號去. 但其他圖片或是表格都能儲存在正確的one drive入面,只有excel 出問題
API Url : https://graph.microsoft.com/v1.0/me/drive/items/{drive-item-id}/workbook/worksheets
Status : 401
Microsoft graph error message :
{
"error": {
"code": "FileOpenUserUnauthorized",
"innerError": {
"date": "2024-06-07T07:00:03",
"code": "unauthorizedUncategorized",
"client-request-id": "<client-request-id>",
"innerError": {
"code": "FileOpenUserUnauthorized",
"message": "You do not have permissions to open this file in the browser."
},
"message": "Required authentication information for the resource is either missing or invalid.",
"request-id": "<request-id>"
},
"message": "You do not have permissions to open this file in the browser."
}
}