Error 'ApiNotFound' trying standard update workbook table row endpoint

Craig Blowfield 0 Reputation points
2024-05-17T10:53:21.87+00:00

Based on the documentation I was trying to update a workbook table row

https://graph.microsoft.com/v1.0/drives/{drive-id}/items/{drive-item_id}/workbook/tables/{table-name}/rows/{index}

with body

{
"index": 5
"values: ...
}

Which fails with

{
    "error": {
        "code": "ApiNotFound",
        "message": "The API you are trying to use could not be found. It may be available in a newer version of Excel. Please refer to the documentation: \"https://docs.microsoft.com/office/dev/add-ins/reference/requirement-sets/excel-api-requirement-sets\".",
        "innerError": {
            "code": "apiNotFound",
            "message": "The API you are trying to use could not be found. It may be available in a newer version of Excel. Please refer to the documentation: \"https://docs.microsoft.com/office/dev/add-ins/reference/requirement-sets/excel-api-requirement-sets\".",
            "date": "2024-05-16T10:43:54",
            "request-id": "e16d020f-d381-40e0-a93b-84d14ae96988",
            "client-request-id": "bdfa2156-beb5-7cd1-261a-2392d83beff0"
        }
    }
}

But using ItemAt works

https://graph.microsoft.com/v1.0/drives/{drive-id}/items/{drive-item_id}/workbook/tables/{table-name}/rows/$/ItemAt(index=5)

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
12,468 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CharanyaB-MSFT 1,891 Reputation points Microsoft Vendor
    2024-05-27T15:07:36.4633333+00:00

    Hello @Craig Blowfield,

    Thanks for reaching Microsoft.

    I attempted to replicate the issue and observed similar behavior in this scenario.

    I would recommend you to raise a support case with Microsoft Graph, a dedicated Support Engineer will be able to look into the issue and assist you better. You can raise support ticket from New support request - Microsoft Entra admin center or https://admin.microsoft.com/#/support/requests.

    Hope this helps.

    If the answer is helpful, please click Accept Answer and kindly upvote it. If you have any further questions about this answer, please click Comment.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.