List charts
7/2/2019
2 minutes to read
In this article
Retrieve a list of chart objects.
Permissions
One of the following permissions is required to call this API. To learn more, including how to choose permissions, see Permissions .
Permission type
Permissions (from least to most privileged)
Delegated (work or school account)
Files.ReadWrite
Delegated (personal Microsoft account)
Not supported.
Application
Not supported.
HTTP request
GET /workbook/worksheets/{id|name}/charts
Optional query parameters
This method supports the OData Query Parameters to help customize the response.
Name
Description
Authorization
Bearer {token}. Required.
Workbook-Session-Id
Workbook session Id that determines if changes are persisted or not. Optional.
Request body
Do not supply a request body for this method.
Response
If successful, this method returns a 200 OK response code and collection of WorkbookChart objects in the response body.
Example
Request
Here is an example of the request.
GET https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/worksheets/{id|name}/charts
GraphServiceClient graphClient = new GraphServiceClient( authProvider );
var charts = await graphClient.Me.Drive.Items["{id}"].Workbook.Worksheets["{id|name}"].Charts
.Request()
.GetAsync();
Read the SDK documentation for details on how to add the SDK to your project and create an authProvider instance.
const options = {
authProvider,
};
const client = Client.init(options);
let res = await client.api('/me/drive/items/{id}/workbook/worksheets/{id|name}/charts')
.get();
Read the SDK documentation for details on how to add the SDK to your project and create an authProvider instance.
MSHTTPClient *httpClient = [MSClientFactory createHTTPClientWithAuthenticationProvider:authenticationProvider];
NSString *MSGraphBaseURL = @"https://graph.microsoft.com/v1.0/";
NSMutableURLRequest *urlRequest = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:[MSGraphBaseURL stringByAppendingString:@"/me/drive/items/{id}/workbook/worksheets/{id|name}/charts"]]];
[urlRequest setHTTPMethod:@"GET"];
MSURLSessionDataTask *meDataTask = [httpClient dataTaskWithRequest:urlRequest
completionHandler: ^(NSData *data, NSURLResponse *response, NSError *nserror) {
NSError *jsonError = nil;
NSDictionary *jsonFinal = [NSJSONSerialization JSONObjectWithData:data options:0 error:&jsonError];
NSMutableArray *workbookChartList = [[NSMutableArray alloc] init];
workbookChartList = [jsonFinal valueForKey:@"value"];
MSGraphWorkbookChart *workbookChart = [[MSGraphWorkbookChart alloc] initWithDictionary:[workbookChartList objectAtIndex: 0] error:&nserror];
}];
[meDataTask execute];
Read the SDK documentation for details on how to add the SDK to your project and create an authProvider instance.
Response
Here is an example of the response. Note: The response object shown here may be truncated for brevity. All of the properties will be returned from an actual call.
HTTP/1.1 200 OK
Content-type: application/json
Content-length: 93
{
"value": [
{
"id": "id-value",
"height": 99,
"left": 99
}
]
}
