Microsoft Fabric Tables API
The Tables API from Microsoft Fabric — 3 operation(s) for tables.
Work with this as data
Every API here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for apis
7 MCP tools reach this
find_apisBrowse and filter every API in the catalog.get_api_artifactsOne API's artifacts, grouped by type.get_openapiThe primary OpenAPI for this API.find_similar_apisAPIs that look like this one.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This API
curl "https://apis.io/api/v1/apis/microsoft-fabric:microsoft-fabric-tables-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.
OpenAPI Specification
openapi: 3.2.0
info:
title: Microsoft Fabric Workload Items REST Tables API
version: v1
x-source: 'https://github.com/microsoft/fabric-rest-api-specs (bundled from openapi/_original/fabric-rest-api-specs: anomalyDetector/swagger.json, apacheAirflowJob/swagger.json, appBackend/swagger.json, azureDatabricksStorage/swagger.json, copyJob/swagger.json, cosmosDbDatabase/swagger.json, dashboard/swagger.json, dataAgent/swagger.json, dataBuildToolJob/swagger.json, dataPipeline/swagger.json, dataflow/swagger.json, datamart/swagger.json, deploymentPlan/swagger.json, digitalTwinBuilder/swagger.json, digitalTwinBuilderFlow/swagger.json, environment/swagger.json, eventSchemaSet/swagger.json, eventhouse/swagger.json, eventstream/swagger.json, graphModel/swagger.json, graphQLApi/swagger.json, graphQuerySet/swagger.json, kqlDashboard/swagger.json, kqlDatabase/swagger.json, kqlQueryset/swagger.json, lakehouse/swagger.json, map/swagger.json, mirroredAzureDatabricksCatalog/swagger.json, mirroredCatalog/swagger.json, mirroredDatabase/swagger.json, mirroredWarehouse/swagger.json, mlExperiment/swagger.json, mlModel/swagger.json, monitoring/swagger.json, mountedDataFactory/swagger.json, notebook/swagger.json, ontology/swagger.json, operationsAgent/swagger.json, orgApp/swagger.json, orgAppAudience/swagger.json, paginatedReport/swagger.json, plan/swagger.json, policySet/swagger.json, realTimeIntelligence/swagger.json, reflex/swagger.json, report/swagger.json, semanticModel/swagger.json, snowflakeDatabase/swagger.json, spark/swagger.json, sparkjobdefinition/swagger.json, sqlDatabase/swagger.json, sqlEndpoint/swagger.json, userDataFunction/swagger.json, variableLibrary/swagger.json, warehouse/swagger.json)'
servers:
- url: https://api.fabric.microsoft.com/v1
security: []
tags:
- name: Tables
paths:
/workspaces/{workspaceId}/lakehouses/{lakehouseId}/tables:
get:
summary: Returns a list of lakehouse Tables
description: '> [!NOTE]
> This API is part of a Preview release and is provided for evaluation and development purposes only. It may change based on feedback and is not recommended for production use.
This API supports pagination.
## Required Delegated Scopes
Lakehouse.Read.All or Lakehouse.ReadWrite.All
## Microsoft Entra supported identities
This API supports the Microsoft identities listed in this section.
| Identity | Support |
|-|-|
| User | Yes |
| Service principal and Managed identities | Yes |
## Interface'
tags:
- Tables
operationId: Tables_ListTables
x-ms-pageable:
nextLinkName: continuationUri
itemName: data
parameters:
- in: path
name: workspaceId
description: The workspace ID.
required: true
schema:
type: string
format: uuid
- in: path
name: lakehouseId
description: The lakehouse ID.
required: true
schema:
type: string
format: uuid
- in: query
name: maxResults
description: The maximum number of results per page to return.
required: false
schema:
type: integer
format: int32
default: 100
maximum: 100
minimum: 1
- in: query
name: continuationToken
description: Token to retrieve the next page of results, if available.
required: false
schema:
type: string
responses:
'200':
description: Request completed successfully.
content:
application/json:
schema:
$ref: '#/components/schemas/Tables'
'429':
description: The service rate limit was exceeded. The server returns a `Retry-After` header indicating, in seconds, how long the client must wait before sending additional requests.
x-ms-error-response: true
headers:
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
default:
description: 'Common error codes:
* UnknownError - An error occurred.'
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
/workspaces/{workspaceId}/lakehouses/{lakehouseId}/tables/{tableName}/load:
post:
summary: Starts a load table operation and returns the operation status URL in the…
description: '> [!NOTE]
> This API is part of a Preview release and is provided for evaluation and development purposes only. It may change based on feedback and is not recommended for production use.
This API supports long running operations (LRO).
## Permissions
Write permission to the lakehouse item.
## Required Delegated Scopes
Lakehouse.ReadWrite.All
## Microsoft Entra supported identities
This API supports the Microsoft identities listed in this section.
| Identity | Support |
|-|-|
| User | Yes |
| Service principal and Managed identities | Yes |
## Interface'
tags:
- Tables
operationId: Tables_LoadTable
x-ms-fabric-sdk-long-running-operation: true
parameters:
- name: workspaceId
in: path
description: The workspace ID.
required: true
schema:
type: string
format: uuid
- name: lakehouseId
in: path
description: The lakehouse item ID.
required: true
schema:
type: string
format: uuid
- name: tableName
in: path
description: The table name.
required: true
schema:
type: string
pattern: ^(?=[0-9]*[a-zA-Z_])[a-zA-Z0-9_]{1,256}$
responses:
'202':
description: Request accepted, load table operation is in progress.
headers:
Location:
description: The URL of the operation status, which can be used to track the operation state.
schema:
type: string
x-ms-operation-id:
description: The operation ID which can be used with long running operations (LRO) APIs to track the operation state and get the result.
schema:
type: string
format: uuid
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
'429':
description: The service rate limit was exceeded. The server returns a `Retry-After` header indicating, in seconds, how long the client must wait before sending additional requests.
x-ms-error-response: true
headers:
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
default:
description: 'Common error codes:
* UnknownError - An error occurred.'
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
requestBody:
content:
application/json:
schema:
$ref: '#/components/schemas/LoadTableRequest'
description: The load table request payload.
required: true
/workspaces/{workspaceId}/lakehouses/{lakehouseId}/schemas/{schemaName}/tables/{tableName}/load?beta=true:
post:
summary: Starts a load table operation for a table within a schema enabled lakehouse and…
description: '> [!NOTE]
> This API is part of a Beta release and is provided for evaluation and development purposes only. It may change based on feedback and is not recommended for production use.
**When calling this API, callers must specify `true` as the value for the query parameter `beta`.**
This API supports long running operations (LRO).
## Permissions
Write permission to the lakehouse item.
## Required Delegated Scopes
Lakehouse.ReadWrite.All
## Microsoft Entra supported identities
This API supports the Microsoft identities listed in this section.
| Identity | Support |
|-|-|
| User | Yes |
| Service principal and Managed identities | Yes |
## Interface'
tags:
- Tables
operationId: Tables_Load_Schema_Table_(beta)
x-ms-fabric-sdk-long-running-operation: true
parameters:
- name: workspaceId
in: path
description: The workspace ID.
required: true
schema:
type: string
format: uuid
- name: lakehouseId
in: path
description: The lakehouse item ID.
required: true
schema:
type: string
format: uuid
- name: schemaName
in: path
description: The schema name.
required: true
schema:
type: string
pattern: ^[a-zA-Z0-9_]{1,128}$
- name: tableName
in: path
description: The table name.
required: true
schema:
type: string
pattern: ^(?=[0-9]*[a-zA-Z_])[a-zA-Z0-9_]{1,256}$
- in: query
name: beta
description: This required parameter must be set to `true` to access this API, which is currently in beta.
required: true
schema:
type: boolean
responses:
'202':
description: Request accepted, load table operation is in progress.
headers:
Location:
description: The URL of the operation status, which can be used to track the operation state.
schema:
type: string
x-ms-operation-id:
description: The operation ID which can be used with long running operations (LRO) APIs to track the operation state and get the result.
schema:
type: string
format: uuid
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
'429':
description: The service rate limit was exceeded. The server returns a `Retry-After` header indicating, in seconds, how long the client must wait before sending additional requests.
x-ms-error-response: true
headers:
Retry-After:
description: The number of seconds to wait before retrying the request.
schema:
type: integer
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
default:
description: 'Common error codes:
* UnknownError - An error occurred.'
content:
application/json:
schema:
$ref: '#/components/schemas/ErrorResponse'
requestBody:
content:
application/json:
schema:
$ref: '#/components/schemas/LoadTableRequest'
description: The load table request payload.
required: true
components:
schemas:
ErrorResponse:
description: The error response.
required:
- message
- errorCode
allOf:
- $ref: '#/components/schemas/ErrorResponseDetails'
properties:
requestId:
type: string
format: uuid
description: ID of the request associated with the error.
readOnly: true
moreDetails:
description: List of additional error details.
type: array
items:
$ref: '#/components/schemas/ErrorResponseDetails'
readOnly: true
isRetriable:
type: boolean
description: When true, the request can be retried. Use the `Retry-After` response header to determine the delay, if available.
readOnly: true
FileFormatOptions:
type: object
description: Abstract type of data file format options.
discriminator:
propertyName: format
required:
- format
properties:
format:
type: string
description: Data file format name. Additional file format types may be added over time.
enum:
- Csv
- Parquet
x-ms-enum:
name: FileFormat
modelAsString: true
values:
- value: Csv
description: CSV format name.
- value: Parquet
description: Parquet format name.
LoadTableRequest:
type: object
description: Represents a load table operation request.
required:
- relativePath
- pathType
properties:
relativePath:
pattern: ^Files(\/[\p{L}\w]{1}([ \p{L}\w\.-]*[\p{L}\w\.-]{1})*)*$
type: string
description: The relative path of the data file or folder.
pathType:
type: string
description: The type of `relativePath`, either file or folder. Additional `PathType` types may be added over time.
enum:
- File
- Folder
x-ms-enum:
name: PathType
modelAsString: true
values:
- value: File
description: load table from file.
- value: Folder
description: load table from folder.
fileExtension:
pattern: ^[a-zA-Z0-9_-]{1,16}$
type: string
description: The file extension of the data file.
mode:
type: string
description: The load table operation mode, overwrite or append. Additional mode types may be added over time.
enum:
- Overwrite
- Append
x-ms-enum:
name: ModeType
modelAsString: true
values:
- value: Overwrite
description: load table in overwrite mode.
- value: Append
description: load table in append mode.
recursive:
type: boolean
description: Indicates whether to search data files recursively or not, when loading a table from a folder.
formatOptions:
$ref: '#/components/schemas/FileFormatOptions'
Table:
required:
- type
- name
- location
- format
description: Table information.
type: object
properties:
type:
$ref: '#/components/schemas/TableType'
name:
type: string
description: Table name.
location:
type: string
description: Table location.
format:
type: string
description: Table format.
TableType:
type: string
description: The table type. Additional `TableType` types may be added over time.
enum:
- Managed
- External
x-ms-enum:
name: TableType
modelAsString: true
values:
- value: Managed
description: Managed table.
- value: External
description: External table.
ErrorResponseDetails:
description: The error response details.
type: object
required:
- message
- errorCode
properties:
errorCode:
type: string
description: A specific identifier that provides information about an error condition, allowing for standardized communication between our service and its users.
readOnly: true
message:
type: string
description: A human readable representation of the error.
readOnly: true
relatedResource:
$ref: '#/components/schemas/ErrorRelatedResource'
parameters:
description: Structured parameters providing additional machine-readable context about the error.
type: array
items:
$ref: '#/components/schemas/ErrorParameter'
readOnly: true
ErrorRelatedResource:
description: The error related resource details object.
type: object
required:
- resourceId
- resourceType
properties:
resourceId:
type: string
description: The resource ID that's involved in the error.
readOnly: true
resourceType:
type: string
description: The type of the resource that's involved in the error.
readOnly: true
Tables:
required:
- data
description: A paginated list of tables.
type: object
properties:
continuationToken:
description: Token to get the next page of results.
type: string
continuationUri:
description: The URI of the next chunk in the result set.
type: string
data:
description: List of tables.
type: array
items:
$ref: '#/components/schemas/Table'
ErrorParameter:
description: A structured parameter providing additional machine-readable context about an error.
type: object
properties:
name:
type: string
description: The parameter identifier.
readOnly: true
value:
type: string
description: The parameter value.
readOnly: true
message:
type: string
description: A human-readable description of the parameter's meaning.
readOnly: true