Microsoft-graph-docs: API `GET /workbook/worksheets/{id|name}/charts` does not work

[dashie]

As described in the following stackoverflow question

https://stackoverflow.com/questions/49828118/microsoft-graph-api-and-excel-charts

the API GET /workbook/worksheets/{id|name}/charts does not work!

Any suggestion?
Maybe a documentation problem?

[adding content from stackoverflow]

Why Microsoft Graph API

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

returns me 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:

[jthake-msft]

@sumurthy can you help here?

[cuongn265]

Any update? Do you have any plan to solve this? I have the same issue with Update chart. Thank you

[dashie]

no update unfortunately

[cuongn265]

@dashie thank you for responding me, do you know any channels to report bugs or finding help? I tried on Stackoverflow but no luck

[sumurthy]

Unable to re-produce the issue. Chart retrieval is working fine for the files that I'm testing with. What's the HTTP error code you are receiving?

[dashie]

Can you share your worksheet?

—
Maurizio Merli

Il giorno 05 lug 2018, alle ore 19:58, Sudhi Ramamurthy [e-mail] ha scritto:

Unable to re-produce the issue. Chart retrieval is working fine for the files that I'm testing with. What's the HTTP error code you are receiving?

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or mute the thread.

[cuongn265]

@sumurthy Can you have a look at my worksheet? asset-model I tried to update an Chart 5 in Asset Overview sheet but no luck.

Thank you

[cuongn265]

@dashie @sumurthy I have investigated the issue for some days and found that the API only raised error on a chart which uses data from another worksheet in a workbook. If the chart only uses data from same worksheet where it is in, nothing happen

[davrous]

Hi, I'm running into the same error with a very simple chart in the same worksheet. Repro file is there: http://david.blob.core.windows.net/tests/Hackathon.xlsx . I've tested from the Graph Explorer web app.

[jthake-msft]

@sumurthy could you maybe see @davrous repro this as he's internal that would be super useful to this thread...

[paylord]

@jthake-msft Hey Jeremy, I have the same issue with the charts endpoint but interestingly it works if you go further down that chain. This this works:
https://graph.microsoft.com/v1.0/sites/root/lists/Documents/drive/root/children('Statistics.xlsx')/workbook/worksheets/Hazards/charts('Hazards')/Image(width=400,height=250,fittingMode='fit')

But this does not:
https://graph.microsoft.com/v1.0/sites/root/lists/Documents/drive/root/children('Statistics.xlsx')/workbook/worksheets/Hazards/charts

This is using a simple mocked up spreadsheet with 3 worksheets, 1 chart on each with no external nor crossover data. I have attached in case it is useful.
Statistics.xlsx

Thanks

Dave

[jthake-msft]

I've had an internal convo with @sumurthy who's confirmed they can repro this and are now investigating...

[jthake-msft]

@sumurthy what was the result of this?

[KKica]

@sumurthy @jthake-msft No update on this yet?