# Microsoft Fabric Warehouse REST APIs API > Microsoft Fabric Warehouse REST APIs API on Apizie: 17 endpoints (Returns a list of warehouses from the specified workspace., Creates a warehouse in the specified workspace., Returns properties of the specified warehouse., Updates the properties of the specified warehouse., …) 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://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/{endpoint} or from Claude, ChatGPT and Cursor through the Apizie MCP server. Free plan: 1,000 requests a month. - Project key: `analytics:microsoft-fabric-warehouse` - Category: Analytics - Status: byok - Source: https://learn.microsoft.com/rest/api/fabric/ - Page: https://www.apizie.tech/api/analytics/microsoft-fabric-warehouse - OpenAPI: https://www.apizie.tech/api/analytics/microsoft-fabric-warehouse/openapi.json ## Endpoints ### Returns a list of warehouses from the specified workspace. `GET https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/items-list-warehouses` (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 warehouse in the specified workspace. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/items-create-warehouse` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | body | object | yes | JSON request body | ### Returns properties of the specified warehouse. `GET https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/items-get-warehouse` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse ID. | ### Updates the properties of the specified warehouse. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/items-update-warehouse` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse ID. | | body | object | yes | JSON request body | ### Deletes the specified warehouse. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/items-delete-warehouse` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse 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… | ### Gets the SQL Pools configuration in the specified workspace. `GET https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/sqlpools-get-sqlpools-configuration` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | ### Updates the SQL Pools configuration in the specified workspace. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/sqlpools-update-sqlpools-configuration` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | body | object | yes | JSON request body | ### Returns the SQL connection string of the specified warehouse. `GET https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/items-get-connection-string` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse ID. | | guestTenantId | string | no | The guest tenant ID if the end user's tenant is different from the warehouse tenant. | | privateLinkType | string | no | Indicates the type of private link this connection string uses. Additional `privateLinkType` types may be added over time. | ### Returns the settings associated with the warehouse. `GET https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/sqlaudit-settings-get-sqlaudit-settings` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | itemId | string | yes | The item ID. | ### Update settings associated with the warehouse. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/sqlaudit-settings-update-sqlaudit-settings` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | itemId | string | yes | The item ID. | | body | object | yes | JSON request body | ### Update the audit actions and groups for this warehouse. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/sqlaudit-settings-set-audit-actions-and-groups` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | itemId | string | yes | The item ID. | | body | object | yes | JSON request body | ### Returns all restore points for a warehouse. `GET https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/restore-points-list-restore-points` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse ID. | | continuationToken | string | no | A token for retrieving the next page of results. | ### Creates a restore point for a warehouse at the current timestamp. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/restore-points-create-restore-point` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse ID. | | body | object | yes | JSON request body | ### Returns the properties of a restore point specified for a warehouse. `GET https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/restore-points-get-restore-point` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse ID. | | restorePointId | string | yes | The restore point ID. | ### Updates an existing restore point by renaming the name or description of it. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/restore-points-update-restore-point` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse ID. | | restorePointId | string | yes | The restore point ID. | | body | object | yes | JSON request body | ### Deletes a restore point specified for a warehouse. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/restore-points-delete-restore-point` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse ID. | | restorePointId | string | yes | The restore point ID. | ### Restores a warehouse in-place to the restore point specified. `POST https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/restore-points-restore-to-restore-point` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | workspaceId | string | yes | The workspace ID. | | warehouseId | string | yes | The warehouse ID. | | restorePointId | string | yes | The restore point ID. | ## Example ``` curl "https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/items-list-warehouses" \ -H "x-api-key: $APIZIE_KEY" \ -H "x-upstream-key: $PROVIDER_KEY" ``` ## FAQ ### How do I call the Microsoft Fabric Warehouse REST APIs API? Create a free Apizie key, then send GET https://www.apizie.tech/v1/analytics:microsoft-fabric-warehouse/items-list-warehouses with the header x-api-key. Every endpoint returns { project, data, timestamp }. ### Is the Microsoft Fabric Warehouse 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 Warehouse REST APIs itself also needs your own key from fabric.microsoft.com. ### Can AI agents use the Microsoft Fabric Warehouse REST APIs API? Yes. Add the Apizie MCP server (https://www.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-warehouse. ### What is the status of the Microsoft Fabric Warehouse REST APIs API? Needs your own provider key (bring your own key)