2

Why Microsoft Graph API

https://graph.microsoft.com/v1.0/me/drive/root/children('GraphTest.xlsx')/workbook/worksheets('Foglio1')/charts

throws an error

{
    "error": {
        "code": "GeneralException",
        "message": "There was an internal error while processing the request.",
        "innerError": {
            "request-id": "6b98e61b-2d11-4e16-8a9a-bc9568aeda10",
            "date": "2018-04-14T04:56:21"
        }
    }
}

I'm sure that the file exists and it is correct because this call

https://graph.microsoft.com/v1.0/me/drive/root/children('GraphTest.xlsx')/workbook/worksheets('Foglio1')/names

works

{
    "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('db444526-887f-48f6-80f9-4e260297921e')/drive/root/children('GraphTest.xlsx')/workbook/worksheets('Foglio1')/names",
    "value": [
        {
            "@odata.id": "/users('db444526-887f-48f6-80f9-4e260297921e')/drive/root/children('GraphTest.xlsx')/workbook/worksheets(%27%7B00000000-0001-0000-0000-000000000000%7D%27)/names(%27table1%27)",
            "comment": "",
            "name": "table1",
            "scope": "Workbook",
            "type": "Range",
            "value": "Foglio1!$B$2:$C$5",
            "visible": true
        }
    ]
}

And the chart exists because if I open the file both on Excel Desktop or Excel Online the chart is there.

And you can see a screenshot of the worksheet:

enter image description here

kkica
  • 4,034
  • 1
  • 20
  • 40
dash1e
  • 7,677
  • 1
  • 30
  • 35
  • Is this a problem with the service at present? This seems to keep popping up again and again at present. Have you had a look at some of the related questions here? I remember finding something on one of the dedicated Graph forums and posting the link in the comments in a similar question. – QHarr Apr 14 '18 at 06:13
  • https://stackoverflow.com/questions/49549502/ms-graph-excel-list-charts-in-worksheet-not-working#comment86106371_49549502 Was where I commented before and there have been a number of similar posts since – QHarr Apr 14 '18 at 07:10
  • What kind of chart element is on the sheet? – Marc LaFleur Apr 14 '18 at 22:08
  • I've just attached a screenshot of the worksheet – dash1e Apr 15 '18 at 11:30
  • Any update? I have same problem here – eugene Jun 20 '18 at 07:11
  • No one, I'm still waiting for the answer... – dash1e Jun 25 '18 at 09:01
  • Unable to produce the issue. What is the HTTP error code? Is this happening on all workbooks you are trying with? – Sudhi Ramamurthy Jul 05 '18 at 17:57
  • No, sorry, I havn't find any solution. I change company and MS subscription, and I'm not able to access that sheet anymore. – dash1e Aug 08 '19 at 03:04

0 Answers0