Not able to read All charts through graph Api

Question

Hi Team,

So, I have query related to get chart Api.

Currently I am saving my workbook data in bytes from Add-in to my server side location through Aspose conversion tool and from server location's I am taking bytes and save it to my one drive location.
In my workbook there are certain charts in worksheets. Now when are save data into one drive and check it by opening the excel file its showing data properly with all charts. But when I am trying to open the same charts using graph Api its showing only first charts data. others chart data is replaced by first chart only.

As you see in attached screenshot there are total 2 charts in one worksheet but graph api showing only first charts data for both of chart.

Note : I am not able to load my excel file here as there is no option to upload excel or zip file. Quick help will be appreciated.

Api : https://graph.microsoft.com/v1.0/me/drive/items/xxx/workbook/worksheets('Sheet1')/charts

Below is my chart Api response.

{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#users('XXX')/drive/items('XXX')/workbook/worksheets('Sheet1')/charts",
"value": [
{
"@odata.id": "/users('XXX')/drive/items('XXX)/workbook/worksheets(%27%7B00000000-0001-0000-0000-000000000000%7D%27)/charts(%27%7B00000000-0000-0000-0000-000000000000%7D%27)",
"height": 213.75,
"id": "{00000000-0000-0000-0000-000000000000}",
"top": 434.25,
"left": 9,
"name": "Chart 1",
"width": 360
},
{
"@odata.id": "/users('XXX')/drive/items('XXX')/workbook/worksheets(%27%7B00000000-0001-0000-0000-000000000000%7D%27)/charts(%27%7B00000000-0000-0000-0000-000000000000%7D%27)",
"height": 213.75,
"id": "{00000000-0000-0000-0000-000000000000}",
"top": 434.25,
"left": 9,
"name": "Chart 1",
"width": 360
}
]
}

Thanks,

Answer 1

Hello @office 365

I'm unable to reproduce this behavior using my test tenant. I'm getting expected set of results in response i.e., chart ID is unique for both of the charts. I would recommend you raise a support case with Microsoft Graph, a Support Engineer will be able to assist you better. You can raise support ticket from http://aad.portal.azure.com/ or https://admin.microsoft.com/#/support/requests.

Hope this helps.

If the answer is helpful, please click Accept Answer and kindly upvote. If you have any further questions about this answer, please click Comment.