Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Advanced Excel Tables API

Excel table management

Advanced Excel Tables API is one of 5 APIs that Advanced Excel publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

This API exposes 2 JSON Schema definitions.

Tagged areas include Tables. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, a JSON-LD context, and 2 JSON Schemas.

This API exposes 1 operation across 1 path, and defines 3 schemas. It is described by OpenAPI 3.0.3, at version v1.0.

Requests are made against a single base URL, https://graph.microsoft.com/v1.0.

1 operations 1 paths 3 schemas 1 GET

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.0.3
API Version
v1.0
Base URL
https://graph.microsoft.com/v1.0
Authentication
OAuth 2.0
Terms of Service
Resource Areas
1

Authentication & Security 1

Advanced Excel Tables API declares 1 security scheme for authenticating requests. It supports OAuth 2.0 (oauth2) using the authorizationCode flow, exposing 2 scopes. By default, every request must be authenticated.

Paths & Operations 1

Across 1 path, the API surfaces 1 operation — 1 GET. Each is listed below with its method, path, parameters, and response codes.

Tables 1

Excel table management

GET
/me/drive/items/{driveItemId}/workbook/worksheets/{worksheetId}/tables
Microsoft Excel List Worksheet Tables
listTables 2 params → 200401

Schemas 3

The contract defines 3 schemas that model the data the API accepts and returns. The most detailed are Table (4 properties), TableList (1 property), ErrorResponse (1 property). Each schema is shown below with its type and property counts.

ErrorResponse
object
Microsoft Graph API error response.
1 property
Table
object
An Excel table.
4 properties
TableList
object
List of tables.
1 property

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

advanced-excel-tables-api-openapi.yml Raw ↑

Other APIs Advanced Excel publishes across the network.

Advanced Excel Charts API
Advanced Excel Ranges API
Advanced Excel Workbooks API
Advanced Excel Worksheets API