offsetRange Not Functioning In Microsoft Graph API

Anthony Robinson 0 Reputation points
2024-08-20T14:49:49.78+00:00

I am using the Microsoft Graph API to retrieve Excel data from a SharePoint site. I am running into an issue when trying to leverage the OffsetRange option.

When using this method, I am getting the following error when passing the following URI and body:

https://graph.microsoft.com/v1.0/sites/xxxxxxx.sharepoint.com,6d9de46d-72e2-4bcb-a4c8-0f262bfd6ac9,d492f0e0-fa92-40d1-a441-b7fd751fc26a/drive/items/1f673d68-c5cb-4b56-a2b8-fd7e3f236087/workbook/worksheets/BargeFreightContractsUpload/range(address='A2:102')/offsetRange

{

"rowOffset": 3,

"columnOffset": 5

}

I've followed the documentation exactly, but cannot get this to return the expected results.

According to CoPilot, the Excel Services API doesn't support this method, which in turn means Microsoft GRaph API doesn't support it. If this is the case, then why is the method listed in the "official" documentation for Graph API??

"error": {
        "code": "BadRequest",
        "message": "Resource not found for the segment 'offsetRange'.",
        "innerError": {
            "date": "2024-08-20T14:08:44",
            "request-id": "3356bb0d-79e6-4a12-af5d-6332c473fc65",
            "client-request-id": "3356bb0d-79e6-4a12-af5d-6332c473fc65"
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,773 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,808 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

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.