# Microsoft Fabric Lakehouse REST APIs API > Microsoft Fabric Lakehouse REST APIs API on Apizie: 23 endpoints (Returns a list of lakehouses from the specified workspace., Creates a lakehouse in the specified workspace., Returns properties of the specified lakehouse., Updates the properties of the specified lakehouse., …) returned as clean JSON through one API key. Send your own provider key in the x-upstream-key header. Call it over REST at https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/{endpoint} or from Claude, ChatGPT and Cursor through the Apizie MCP server. Free plan: 1,000 requests a month. - Project key: `analytics:microsoft-fabric-lakehouse` - Category: Analytics - Status: byok - Source: https://learn.microsoft.com/rest/api/fabric/ - Page: https://apizie.tech/api/analytics/microsoft-fabric-lakehouse - OpenAPI: https://apizie.tech/api/analytics/microsoft-fabric-lakehouse/openapi.json ## Endpoints ### Returns a list of lakehouses from the specified workspace. `GET https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/items-list-lakehouses` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | recursive | boolean | no | Lists items in a folder and its nested folders, or just a folder only. True - All items in the folder and its nested folders are listed,… | | rootFolderId | string | no | This parameter allows users to filter items based on a specific root folder. If not provided, the workspace is used as the root folder. | | continuationToken | string | no | A token for retrieving the next page of results. | ### Creates a lakehouse in the specified workspace. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/items-create-lakehouse` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | body | object | yes | JSON request body | ### Returns properties of the specified lakehouse. `GET https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/items-get-lakehouse` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | ### Updates the properties of the specified lakehouse. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/items-update-lakehouse` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | body | object | yes | JSON request body | ### Deletes the specified lakehouse. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/items-delete-lakehouse` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | hardDelete | boolean | no | Specifies whether to perform a hard delete. When set to `true`, the item is permanently deleted and cannot be recovered. When set to… | ### Returns a list of lakehouse Tables. `GET https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/tables-list-tables` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | maxResults | integer | no | The maximum number of results per page to return. | | continuationToken | string | no | Token to retrieve the next page of results, if available. | ### Starts a load table operation and returns the operation status URL in the response location header. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/tables-load-table` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse item ID. | | tableName | string | yes | The table name. | | body | object | yes | JSON request body | ### Starts a load table operation for a table within a schema enabled lakehouse and returns the operation status… `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/tables-load-schema-table-beta` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse item ID. | | schemaName | string | yes | The schema name. | | tableName | string | yes | The table name. | | beta | boolean | yes | This required parameter must be set to `true` to access this API, which is currently in beta. | | body | object | yes | JSON request body | ### Run on-demand [table maintenance](/fabric/data-engineering/lakehouse-table-maintenance) job instance. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/background-jobs-run-on-demand-table-maintenance` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The Lakehouse item ID. | | body | object | yes | JSON request body | ### Create a new Refresh MaterializedLakeViews schedule for a lakehouse. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/background-jobs-create-refresh-materialized-lake-views-sched` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | body | object | yes | JSON request body | ### Returns a list of livy sessions from the specified item identifier. `GET https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/livy-sessions-list-livy-sessions` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace identifier. | | lakehouseId | string | yes | The lakehouse ID. | | continuationToken | string | no | Token to retrieve the next page of results, if available. | ### Returns a list of livy sessions from the specified item identifier (beta). `GET https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/livy-sessions-list-livy-sessions-beta` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace identifier. | | lakehouseId | string | yes | The lakehouse ID. | | beta | boolean | yes | This required parameter must be set to `true` to access this API, which is currently in beta. | | submittedDateTime | string | no | Submitted date time filter. Filter the sessions based on the submitted date time in UTC, using the YYYY-MM-DDTHH:mm:ssZ format. | | endDateTime | string | no | Ended date time filter. Filter the sessions based on the ended date time in UTC, using the YYYY-MM-DDTHH:mm:ssZ format. | | submitter.Id | string | no | The GUID value of the user who submitted the session. | | state | string | no | The state of the session. Possible values are: `NotStarted`, `InProgress`, `Cancelled`, `Failed`, `Succeeded`, `Unknown`. This value maps… | | continuationToken | string | no | Token to retrieve the next page of results, if available. | ### Returns properties of the specified livy session. `GET https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/livy-sessions-get-livy-session` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace identifier. | | lakehouseId | string | yes | The lakehouse ID. | | livyId | string | yes | The session identifier. | ### Run on-demand [Refresh… `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/background-jobs-run-on-demand-refresh-materialized-lake-view` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | ### Update an existing Refresh MaterializedLakeViews schedule for a lakehouse. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/background-jobs-update-refresh-materialized-lake-views-sched` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | scheduleId | string | yes | The lakehouse schedule ID. | | body | object | yes | JSON request body | ### Delete an existing Refresh MaterializedLakeViews schedule for a lakehouse. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/background-jobs-delete-refresh-materialized-lake-views-sched` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | scheduleId | string | yes | The lakehouse schedule ID. | ### Returns the specified lakehouse public definition. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/items-get-lakehouse-definition` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | format | string | no | The format of the lakehouse public definition. | ### Overrides the definition for the specified lakehouse. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/items-update-lakehouse-definition` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | updateMetadata | boolean | no | When set to true and the .platform file is provided as part of the definition, the item's metadata is updated using the metadata in the… | | body | object | yes | JSON request body | ### Returns a list of materialized lake views execution definitions for a lakehouse. `GET https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/materialized-lake-views-list-mlv-execution-definitions` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | continuationToken | string | no | A token for retrieving the next page of results. | ### Creates a materialized lake views execution definition. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/materialized-lake-views-create-mlv-execution-definition` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | body | object | yes | JSON request body | ### Returns the specified materialized lake views execution definition. `GET https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/materialized-lake-views-get-mlv-execution-definition` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | mlvExecutionDefinitionId | string | yes | The materialized lake views execution definition ID. | ### Updates the specified materialized lake views execution definition. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/materialized-lake-views-update-mlv-execution-definition` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | mlvExecutionDefinitionId | string | yes | The materialized lake views execution definition ID. | | body | object | yes | JSON request body | ### Deletes the specified materialized lake views execution definition. `POST https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/materialized-lake-views-delete-mlv-execution-definition` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | lakehouseId | string | yes | The lakehouse ID. | | mlvExecutionDefinitionId | string | yes | The materialized lake views execution definition ID. | ## Example ``` curl "https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/items-list-lakehouses" \ -H "x-api-key: $APIZIE_KEY" \ -H "x-upstream-key: $PROVIDER_KEY" ``` ## FAQ ### How do I call the Microsoft Fabric Lakehouse REST APIs API? Create a free Apizie key, then send GET https://apizie.tech/v1/analytics:microsoft-fabric-lakehouse/items-list-lakehouses with the header x-api-key. Every endpoint returns { project, data, timestamp }. ### Is the Microsoft Fabric Lakehouse REST APIs API free on Apizie? Yes. The Free plan includes 1,000 requests a month at 100 requests a minute, no credit card. Microsoft Fabric Lakehouse REST APIs itself also needs your own key from fabric.microsoft.com. ### Can AI agents use the Microsoft Fabric Lakehouse REST APIs API? Yes. Add the Apizie MCP server (https://apizie.tech/mcp) to Claude, ChatGPT, Cursor or VS Code, then ask in plain language. The agent calls run_scraper with project key analytics:microsoft-fabric-lakehouse. ### What is the status of the Microsoft Fabric Lakehouse REST APIs API? Needs your own provider key (bring your own key)