title | description | author | ms.localizationpriority | ms.subservice | doc_type |
---|---|---|---|---|---|
List TableCollection |
Retrieve a list of table objects. |
lumine2008 |
medium |
excel |
apiPageType |
Namespace: microsoft.graph
Retrieve a list of table objects.
[!INCLUDE national-cloud-support]
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. |
GET /me/drive/items/{id}/workbook/tables
GET /me/drive/root:/{item-path}:/workbook/tables
GET /me/drive/items/{id}/workbook/worksheets/{id|name}/tables
GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/tables
This method supports the OData Query Parameters to help customize the response.
Name | Description |
---|---|
Authorization | Bearer {token}. Required. Learn more about authentication and authorization. |
Workbook-Session-Id | Workbook session Id that determines if changes are persisted or not. Optional. |
Don't supply a request body for this method.
If successful, this method returns a 200 OK
response code and collection of workbookTable objects in the response body.
The following example shows a request.
GET https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/tables
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
[!INCLUDE sample-code] [!INCLUDE sdk-documentation]
The following example shows the response. Note: The response object shown here might be shortened for readability.
HTTP/1.1 200 OK
Content-type: application/json
{
"value": [
{
"id": "99",
"name": "name-value",
"showHeaders": true,
"showTotals": true,
"style": "style-value"
}
]
}
Note: Use the $top and $skip query parameters to page through large numbers of tables.
Example:
https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/tables?$top=5
https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/tables?$top=5&$skip=5