{"action":"created","issue":{"url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs/issues/2459","repository_url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs","labels_url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs/issues/2459/labels{/name}","comments_url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs/issues/2459/comments","events_url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs/issues/2459/events","html_url":"https://github.com/microsoftgraph/microsoft-graph-docs/issues/2459","id":314537365,"node_id":"MDU6SXNzdWUzMTQ1MzczNjU=","number":2459,"title":"API `GET /workbook/worksheets/{id|name}/charts` does not work","user":{"login":"dashie","id":913231,"node_id":"MDQ6VXNlcjkxMzIzMQ==","avatar_url":"https://avatars2.githubusercontent.com/u/913231?v=4","gravatar_id":"","url":"https://api.github.com/users/dashie","html_url":"https://github.com/dashie","followers_url":"https://api.github.com/users/dashie/followers","following_url":"https://api.github.com/users/dashie/following{/other_user}","gists_url":"https://api.github.com/users/dashie/gists{/gist_id}","starred_url":"https://api.github.com/users/dashie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dashie/subscriptions","organizations_url":"https://api.github.com/users/dashie/orgs","repos_url":"https://api.github.com/users/dashie/repos","events_url":"https://api.github.com/users/dashie/events{/privacy}","received_events_url":"https://api.github.com/users/dashie/received_events","type":"User","site_admin":false},"labels":[{"id":746701249,"node_id":"MDU6TGFiZWw3NDY3MDEyNDk=","url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs/labels/area:%20excel","name":"area: excel","color":"1d76db","default":false},{"id":966041279,"node_id":"MDU6TGFiZWw5NjYwNDEyNzk=","url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs/labels/awaiting%20internal%20response","name":"awaiting internal response","color":"c5def5","default":false},{"id":746701284,"node_id":"MDU6TGFiZWw3NDY3MDEyODQ=","url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs/labels/bug:%20product","name":"bug: product","color":"d83b01","default":false}],"state":"open","locked":false,"assignee":{"login":"sumurthy","id":8384457,"node_id":"MDQ6VXNlcjgzODQ0NTc=","avatar_url":"https://avatars3.githubusercontent.com/u/8384457?v=4","gravatar_id":"","url":"https://api.github.com/users/sumurthy","html_url":"https://github.com/sumurthy","followers_url":"https://api.github.com/users/sumurthy/followers","following_url":"https://api.github.com/users/sumurthy/following{/other_user}","gists_url":"https://api.github.com/users/sumurthy/gists{/gist_id}","starred_url":"https://api.github.com/users/sumurthy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sumurthy/subscriptions","organizations_url":"https://api.github.com/users/sumurthy/orgs","repos_url":"https://api.github.com/users/sumurthy/repos","events_url":"https://api.github.com/users/sumurthy/events{/privacy}","received_events_url":"https://api.github.com/users/sumurthy/received_events","type":"User","site_admin":false},"assignees":[{"login":"sumurthy","id":8384457,"node_id":"MDQ6VXNlcjgzODQ0NTc=","avatar_url":"https://avatars3.githubusercontent.com/u/8384457?v=4","gravatar_id":"","url":"https://api.github.com/users/sumurthy","html_url":"https://github.com/sumurthy","followers_url":"https://api.github.com/users/sumurthy/followers","following_url":"https://api.github.com/users/sumurthy/following{/other_user}","gists_url":"https://api.github.com/users/sumurthy/gists{/gist_id}","starred_url":"https://api.github.com/users/sumurthy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sumurthy/subscriptions","organizations_url":"https://api.github.com/users/sumurthy/orgs","repos_url":"https://api.github.com/users/sumurthy/repos","events_url":"https://api.github.com/users/sumurthy/events{/privacy}","received_events_url":"https://api.github.com/users/sumurthy/received_events","type":"User","site_admin":false}],"milestone":null,"comments":10,"created_at":"2018-04-16T07:52:44Z","updated_at":"2018-07-25T00:08:57Z","closed_at":null,"author_association":"NONE","body":"As described in the following stackoverflow question\r\n\r\n[https://stackoverflow.com/questions/49828118/microsoft-graph-api-and-excel-charts](https://stackoverflow.com/questions/49828118/microsoft-graph-api-and-excel-charts)\r\n\r\nthe API `GET /workbook/worksheets/{id|name}/charts` does not work!\r\n\r\nAny suggestion?\r\nMaybe a documentation problem?\r\n\r\n\r\n[adding content from stackoverflow]\r\n\r\nWhy Microsoft Graph API\r\n\r\n`https://graph.microsoft.com/v1.0/me/drive/root/children('GraphTest.xlsx')/workbook/worksheets('Foglio1')/charts\r\n\r\nreturns me an error\r\n\r\n```\r\n{\r\n    \"error\": {\r\n        \"code\": \"GeneralException\",\r\n        \"message\": \"There was an internal error while processing the request.\",\r\n        \"innerError\": {\r\n            \"request-id\": \"6b98e61b-2d11-4e16-8a9a-bc9568aeda10\",\r\n            \"date\": \"2018-04-14T04:56:21\"\r\n        }\r\n    }\r\n}\r\n```\r\n\r\nI'm sure that the file exists and it is correct because this call\r\n\r\n`https://graph.microsoft.com/v1.0/me/drive/root/children('GraphTest.xlsx')/workbook/worksheets('Foglio1')/names`\r\n\r\nworks\r\n\r\n```\r\n{\r\n    \"@odata.context\": \"https://graph.microsoft.com/v1.0/$metadata#users('db444526-887f-48f6-80f9-4e260297921e')/drive/root/children('GraphTest.xlsx')/workbook/worksheets('Foglio1')/names\",\r\n    \"value\": [\r\n        {\r\n            \"@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)\",\r\n            \"comment\": \"\",\r\n            \"name\": \"table1\",\r\n            \"scope\": \"Workbook\",\r\n            \"type\": \"Range\",\r\n            \"value\": \"Foglio1!$B$2:$C$5\",\r\n            \"visible\": true\r\n        }\r\n    ]\r\n}\r\n```\r\nAnd the chart exists because if I open the file both on Excel Desktop or Excel Online the chart is there.\r\nAnd you can see a screenshot of the worksheet:\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs/issues/comments/407591195","html_url":"https://github.com/microsoftgraph/microsoft-graph-docs/issues/2459#issuecomment-407591195","issue_url":"https://api.github.com/repos/microsoftgraph/microsoft-graph-docs/issues/2459","id":407591195,"node_id":"MDEyOklzc3VlQ29tbWVudDQwNzU5MTE5NQ==","user":{"login":"paylord","id":8131698,"node_id":"MDQ6VXNlcjgxMzE2OTg=","avatar_url":"https://avatars0.githubusercontent.com/u/8131698?v=4","gravatar_id":"","url":"https://api.github.com/users/paylord","html_url":"https://github.com/paylord","followers_url":"https://api.github.com/users/paylord/followers","following_url":"https://api.github.com/users/paylord/following{/other_user}","gists_url":"https://api.github.com/users/paylord/gists{/gist_id}","starred_url":"https://api.github.com/users/paylord/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paylord/subscriptions","organizations_url":"https://api.github.com/users/paylord/orgs","repos_url":"https://api.github.com/users/paylord/repos","events_url":"https://api.github.com/users/paylord/events{/privacy}","received_events_url":"https://api.github.com/users/paylord/received_events","type":"User","site_admin":false},"created_at":"2018-07-25T00:08:57Z","updated_at":"2018-07-25T00:08:57Z","author_association":"NONE","body":"@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:\r\nhttps://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')\r\n\r\nBut this does not:\r\nhttps://graph.microsoft.com/v1.0/sites/root/lists/Documents/drive/root/children('Statistics.xlsx')/workbook/worksheets/Hazards/charts\r\n\r\nThis 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.\r\n[Statistics.xlsx](https://github.com/microsoftgraph/microsoft-graph-docs/files/2225881/Statistics.xlsx)\r\n\r\nThanks\r\n\r\nDave"}}
{"actor":{"display_login":"paylord"}}