Get usedrange of Microsoft Graph API doesn't w

2019-07-29 06:13发布

问题:

I am trying to get values that are stored in Excel cells using the method Get usedrange (see the page below), but it doesn't work.

https://developer.microsoft.com/en-us/graph/docs/api-reference/v1.0/api/worksheet_usedrange

The following error response is returned.

{
"error": {
    "code": "InvalidArgument",
    "message": "引数が正しくない、不足している、または形式が不適切です。", //The argument is incorrect, missing, or the format is inappropriate.
    "innerError": {
        "request-id": "dcff76b5-9bc6-4a01-b99f-853b9430ef0d",
        "date": "2017-05-01T09:01:15"
    }
}

}

I tried GET (as opposed to POST) with the same request URL on a trial ......it is mysterious that sometimes were time out, but sometimes all cell data was returned without timeout (result, the browser hung up).

I'd be very appreciated it if I could get any advise from anyone who encounters the same phenomenon or knows how to avoid it.

--

Additional Notes:

-Excel Data

-Execution result in Graph Explorer (original method, POST) https://graph.microsoft.com/v1.0/me/drive/items/01PYKTZAO2B65SCU2UDJCKMKFWJEEDRNLQ/workbook/worksheets('Sheet1')/UsedRange()

-Additional Information - Result when use GET in the same URL