Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
13,489 questions
Issue with Graph API PATCH Request to Update Excel Range: HTTP 405 Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 99%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jagapathi Seemakurthy
0
Reputation points
We are encountering an issue when attempting to update a range in an Excel worksheet using the Microsoft Graph API. The request fails with the following error:
405 - HTTP verb used to access this page is not allowed.
Request Details:
- URL:
https://graph.microsoft.com/v1.0/me/drive/items/01BQLIGHUFYSJCUP7JRNGIIWTK4EN77TIG/workbook/worksheets/%7B37CC9684-A622-4277-9481-105A62D56E47%7D/range(address='A32003:H34002') - Method:
PATCH - Headers:
-
Authorization: Bearer ********-
Content-Type: application/json-
Accept: application/json - Body: (trimmed for brevity)
-
-
-
Observations:
- The error suggests that the HTTP verb (
PATCH) is not allowed. - We suspect there might be a redirect happening during the call, as we see the following URL in the logs:
https://pus13-excel.officeapps.live.com/x/_layouts/xlrestinternal.aspx?ui=en-US&rs=en-US&WOPISrc=https%3a%2f%2f{{domain}}.sharepoint.com%2fpersonal%2f{{user-id}}%2f_vti_bin%2fwopi.ashx%2ffiles%2f92c60b80b9814e66960f6ea3571decab&wdEnableRoaming=1&mscc=1&wdODB=1&hid=8d6f90a1-20c3-4000-e90b-e480f15ecfcb&wdRestPart=_api%2fworksheets(%27%257B37CC9684-A622-4277-9481-105A62D56E47%257D%27)%2frange(address%3d%27A32003%3aH34002%27) - This issue does not happen every time. We write data in batches of 1000 rows, and while most batches succeed, one of the batches occasionally fails with this error.
Questions:
- Is there a known issue with
PATCHRequests for updating Excel ranges via the Graph API? - Could the redirect to the
pus13-excel.officeapps.live.comdomain be causing the issue? If so, how can we handle this? - Are there any additional configurations or headers required to ensure the request is processed correctly?
- Could this be related to inconsistencies when processing large batches?
Any guidance or suggestions to resolve this issue would be greatly appreciated. Thank you!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 7.000000000000001%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC3%3C/text%3E%3C/svg%3E)
Carolyne-3676 216 Reputation points2025-04-04T11:43:40.25+00:00 Proposing the following troubleshooting steps for a start:
Check the item's permissions: Ensure the access token you're using has the necessary permissions to perform the operation. TheFiles.ReadWritepermission is necessary for updating an Excel range using Microsoft Graph API.- Issue with redirects: The Microsoft Graph API should handle redirects automatically. It's possible that the redirect to the
pus13-excel.officeapps.live.comdomain might be causing the issue, but it's hard to be sure without more information. - Batch size: If the issue is occurring sporadically during large batch operations, it might be a throttling issue. Microsoft Graph API has certain limitations and might throttle requests if they are too frequent or the payload is too large. You might want to consider reducing the batch size or adding some delay between requests.
- Keep-alive header: The
Connection: keep-aliveheader could be added to ensure the TCP connection remains open for multiple requests. - Content-Length header: Ensure the
Content-Lengthheader is correct. An incorrectContent-Lengthmight cause the server to reject the request.
- Issue with redirects: The Microsoft Graph API should handle redirects automatically. It's possible that the redirect to the
-
Jagapathi Seemakurthy 0 Reputation points
2025-04-04T12:12:15.4066667+00:00 Thank you @Carolyne-3676 for your inputs. We did evaluate the points you shared, and here are our findings
- We are 100% sure the permissions are correct, as many calls are succeeding for the same resource, and randomly a few are failing
- Regarding redirects, let me know if there is a way to capture more details. I will share them here
- Batch size is not too high, we did see this for very small datasets also sometimes
- Keep-alive and Content-Length headers are set properly
Sign in to comment
Sign in to answer