# Azure Sql management API > Azure Sql management API on Apizie: 400 endpoints (Gets a database's short term retention policy., Gets a database's short term retention policy., Updates a database's short term retention policy., Updates a database's short term retention policy., …) 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/cloud:azure-arm-sql/{endpoint} or from Claude, ChatGPT and Cursor through the Apizie MCP server. Free plan: 1,000 requests a month. - Project key: `cloud:azure-arm-sql` - Category: Cloud - Status: byok - Source: https://learn.microsoft.com/rest/api/azure/ - Page: https://www.apizie.tech/api/cloud/azure-arm-sql - OpenAPI: https://www.apizie.tech/api/cloud/azure-arm-sql/openapi.json Azure Resource Manager API for Sql: manage these Azure resources in your subscription with a Microsoft Entra access token. ## Endpoints ### Gets a database's short term retention policy. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/backup-short-term-retention-policies-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets a database's short term retention policy. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/backup-short-term-retention-policies-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | policyName | string | yes | The policy name. Should always be default. | ### Updates a database's short term retention policy. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/backup-short-term-retention-policies-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | policyName | string | yes | The policy name. Should always be default. | | body | object | yes | JSON request body | ### Updates a database's short term retention policy. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/backup-short-term-retention-policies-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | policyName | string | yes | The policy name. Should always be default. | | body | object | yes | JSON request body | ### Lists auditing settings of a server. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/server-blob-auditing-policies-list-by-server` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | ### Gets a server's blob auditing policy. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/server-blob-auditing-policies-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | blobAuditingPolicyName | string | yes | The name of the blob auditing policy. | ### Creates or updates a server's blob auditing policy. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/server-blob-auditing-policies-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | blobAuditingPolicyName | string | yes | The name of the blob auditing policy. | | body | object | yes | JSON request body | ### Lists auditing settings of a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-blob-auditing-policies-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets a database's blob auditing policy. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-blob-auditing-policies-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | blobAuditingPolicyName | string | yes | The name of the blob auditing policy. | ### Creates or updates a database's blob auditing policy. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-blob-auditing-policies-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | blobAuditingPolicyName | string | yes | The name of the blob auditing policy. | | body | object | yes | JSON request body | ### Lists extended auditing settings of a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/extended-database-blob-auditing-policies-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets an extended database's blob auditing policy. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/extended-database-blob-auditing-policies-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | blobAuditingPolicyName | string | yes | The name of the blob auditing policy. | ### Creates or updates an extended database's blob auditing policy. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/extended-database-blob-auditing-policies-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | blobAuditingPolicyName | string | yes | The name of the blob auditing policy. | | body | object | yes | JSON request body | ### Lists extended auditing settings of a server. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/extended-server-blob-auditing-policies-list-by-server` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | ### Gets an extended server's blob auditing policy. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/extended-server-blob-auditing-policies-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | blobAuditingPolicyName | string | yes | The name of the blob auditing policy. | ### Creates or updates an extended server's blob auditing policy. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/extended-server-blob-auditing-policies-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | blobAuditingPolicyName | string | yes | The name of the blob auditing policy. | | body | object | yes | JSON request body | ### Gets the database data masking policy. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/data-masking-policies-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | dataMaskingPolicyName | string | yes | The name of the database for which the data masking policy applies. | ### Creates or updates a database data masking policy. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/data-masking-policies-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | dataMaskingPolicyName | string | yes | The name of the database for which the data masking policy applies. | | body | object | yes | JSON request body | ### Gets a list of database data masking rules. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/data-masking-rules-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | dataMaskingPolicyName | string | yes | The name of the database for which the data masking policy applies. | ### Creates or updates a database data masking rule. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/data-masking-rules-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | dataMaskingPolicyName | string | yes | The name of the database for which the data masking policy applies. | | dataMaskingRuleName | string | yes | The name of the data masking rule. | | body | object | yes | JSON request body | ### List the user activities of a data warehouse which includes running and suspended queries `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/data-warehouse-user-activities-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets the user activities of a data warehouse which includes running and suspended queries `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/data-warehouse-user-activities-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | dataWarehouseUserActivityName | string | yes | The activity name of the data warehouse. | ### Gets a list of database's Advanced Threat Protection states. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-advanced-threat-protection-settings-list-by-databas` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets a database's Advanced Threat Protection state. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-advanced-threat-protection-settings-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | advancedThreatProtectionName | string | yes | The name of the Advanced Threat Protection state. | ### Creates or updates a database's Advanced Threat Protection state. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-advanced-threat-protection-settings-create-or-updat` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | advancedThreatProtectionName | string | yes | The name of the Advanced Threat Protection state. | | body | object | yes | JSON request body | ### Gets a list of database advisors. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-advisors-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | $expand | string | no | The child resources to include in the response. | ### Gets a database advisor. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-advisors-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | advisorName | string | yes | The name of the Database Advisor. | ### Updates a database advisor. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-advisors-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | advisorName | string | yes | The name of the Database Advisor. | | body | object | yes | JSON request body | ### Gets a database's automatic tuning. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-automatic-tuning-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Update automatic tuning properties for target database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-automatic-tuning-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | body | object | yes | JSON request body | ### List database columns `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-columns-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | schema | array | no | | | table | array | no | | | column | array | no | | | orderBy | array | no | | | $skiptoken | string | no | An opaque token that identifies a starting point in the collection. | ### List database columns `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-columns-list-by-table` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | schemaName | string | yes | The name of the schema. | | tableName | string | yes | The name of the table. | | $filter | string | no | An OData filter expression that filters elements in the collection. | ### Get database column `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-columns-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | schemaName | string | yes | The name of the schema. | | tableName | string | yes | The name of the table. | | columnName | string | yes | The name of the column. | ### Revalidates an existing encryption protector for a particular database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-encryption-protectors-revalidate` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | encryptionProtectorName | string | yes | The name of the encryption protector to be updated. | ### Reverts an existing encryption protector for a particular database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-encryption-protectors-revert` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | encryptionProtectorName | string | yes | The name of the encryption protector to be updated. | ### List database extension. This will return an empty list as it is not supported. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-extensions-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets a database extension. This will return resource not found as it is not supported. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-extensions-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | extensionName | string | yes | | ### Perform a database extension operation, like database import, database export, or polybase import `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-extensions-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | extensionName | string | yes | | | body | object | yes | JSON request body | ### Gets a list of operations performed on the database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-operations-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Cancels the asynchronous operation on the database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-operations-cancel` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | operationId | string | yes | The operation identifier. | ### Gets list of Database Recommended Actions. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-recommended-actions-list-by-database-advisor` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | advisorName | string | yes | The name of the Database Advisor. | ### Gets a database recommended action. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-recommended-actions-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | advisorName | string | yes | The name of the Database Advisor. | | recommendedActionName | string | yes | The name of Database Recommended Action. | ### Updates a database recommended action. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-recommended-actions-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | advisorName | string | yes | The name of the Database Advisor. | | recommendedActionName | string | yes | The name of Database Recommended Action. | | body | object | yes | JSON request body | ### List database schemas `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-schemas-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | $filter | string | no | An OData filter expression that filters elements in the collection. | ### Get database schema `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-schemas-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | schemaName | string | yes | The name of the schema. | ### Gets a list of database's security alert policies. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-security-alert-policies-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets a database's security alert policy. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-security-alert-policies-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | securityAlertPolicyName | string | yes | The name of the security alert policy. | ### Creates or updates a database's security alert policy. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-security-alert-policies-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | securityAlertPolicyName | string | yes | The name of the security alert policy. | | body | object | yes | JSON request body | ### Gets a list of database's sql vulnerability assessment rule baselines. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-baselines-list-by-sql` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | ### Gets a list of database's sql vulnerability assessment rule baselines. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-baselines-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | baselineName | string | yes | | ### Add a database's vulnerability assessment rule baseline list. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-baselines-create-or-up` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | baselineName | string | yes | | | body | object | yes | JSON request body | ### Executes a Vulnerability Assessment database scan. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-execute-scan-execute` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | ### Gets a list of database's sql vulnerability assessment rule baselines. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-rule-baselines-list-by` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | baselineName | string | yes | | ### Gets a database's sql vulnerability assessment rule baseline. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-rule-baselines-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | baselineName | string | yes | | | ruleId | string | yes | The vulnerability assessment rule ID. | ### Creates or updates a database's vulnerability assessment rule baseline. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-rule-baselines-create` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | baselineName | string | yes | | | ruleId | string | yes | The vulnerability assessment rule ID. | | body | object | yes | JSON request body | ### Removes the database's vulnerability assessment rule baseline. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-rule-baselines-delete` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | baselineName | string | yes | | | ruleId | string | yes | The vulnerability assessment rule ID. | ### Gets a vulnerability assessment scan record of a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-scan-result-list-by-sc` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the SQL Vulnerability Assessment. | | scanId | string | yes | The scan id of the SQL Vulnerability Assessment scan to retrieve result from. | ### Gets a vulnerability assessment scan record of a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-scan-result-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the SQL Vulnerability Assessment. | | scanId | string | yes | The scan id of the SQL Vulnerability Assessment scan to retrieve result from. | | scanResultId | string | yes | The scan result id of the specific result to retrieve. | ### Lists the vulnerability assessment scans of a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-scans-list-by-sql-vuln` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | ### Get a database vulnerability assessment scan result. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessment-scans-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | scanId | string | yes | The vulnerability assessment scan Id of the scan to retrieve. | ### Lists SQL Vulnerability Assessment policies associated with a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessments-settings-list-by-data` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets SQL Vulnerability Assessment policy for database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-sql-vulnerability-assessments-settings-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | ### List database tables `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-tables-list-by-schema` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | schemaName | string | yes | The name of the schema. | | $filter | string | no | An OData filter expression that filters elements in the collection. | ### Get database table `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-tables-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | schemaName | string | yes | The name of the schema. | | tableName | string | yes | The name of the table. | ### Gets database usages. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-usages-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets a database's vulnerability assessment rule baseline. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessment-rule-baselines-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database for which the vulnerability assessment rule baseline is defined. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | ruleId | string | yes | The vulnerability assessment rule ID. | | baselineName | string | yes | The name of the vulnerability assessment rule baseline (default implies a baseline on a database level rule and master for server level… | ### Creates or updates a database's vulnerability assessment rule baseline. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessment-rule-baselines-create-or-u` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database for which the vulnerability assessment rule baseline is defined. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | ruleId | string | yes | The vulnerability assessment rule ID. | | baselineName | string | yes | The name of the vulnerability assessment rule baseline (default implies a baseline on a database level rule and master for server level… | | body | object | yes | JSON request body | ### Removes the database's vulnerability assessment rule baseline. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessment-rule-baselines-delete` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database for which the vulnerability assessment rule baseline is defined. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | ruleId | string | yes | The vulnerability assessment rule ID. | | baselineName | string | yes | The name of the vulnerability assessment rule baseline (default implies a baseline on a database level rule and master for server level… | ### Lists the vulnerability assessment scans of a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessment-scans-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | ### Gets a vulnerability assessment scan record of a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessment-scans-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | scanId | string | yes | The vulnerability assessment scan Id of the scan to retrieve. | ### Convert an existing scan result to a human readable format. If already exists nothing happens `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessment-scans-export` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | scanId | string | yes | The vulnerability assessment scan Id of the scan to retrieve. | ### Executes a Vulnerability Assessment database scan. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessment-scans-initiate-scan` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | scanId | string | yes | The vulnerability assessment scan Id of the scan to retrieve. | ### Lists the vulnerability assessment policies associated with a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessments-list-by-database` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database for which the vulnerability assessment is defined. | ### Gets the database's vulnerability assessment. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessments-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database for which the vulnerability assessment is defined. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | ### Creates or updates the database's vulnerability assessment. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessments-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database for which the vulnerability assessment is defined. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | | body | object | yes | JSON request body | ### Removes the database's vulnerability assessment. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/database-vulnerability-assessments-delete` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database for which the vulnerability assessment is defined. | | vulnerabilityAssessmentName | string | yes | The name of the vulnerability assessment. | ### Gets a list of databases. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-list-by-server` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | $skipToken | string | no | | ### Gets a database. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | $expand | string | no | The child resources to include in the response. | | $filter | string | no | An OData filter expression that filters elements in the collection. | ### Creates a new database or updates an existing database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | body | object | yes | JSON request body | ### Updates an existing database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | body | object | yes | JSON request body | ### Deletes the database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-delete` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Exports a database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-export` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | body | object | yes | JSON request body | ### Failovers a database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-failover` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | replicaType | string | no | The type of replica to be failed over. | ### Imports a bacpac into a new database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-import` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | body | object | yes | JSON request body | ### Renames a database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-rename` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | | body | object | yes | JSON request body | ### Pauses a database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-pause` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Resumes a database. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-resume` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Upgrades a data warehouse. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-upgrade-data-warehouse` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | databaseName | string | yes | The name of the database. | ### Gets a list of databases in an elastic pool. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-list-by-elastic-pool` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | elasticPoolName | string | yes | The name of the elastic pool. | ### Gets a list of inaccessible databases in a logical server `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/databases-list-inaccessible-by-server` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | ### Gets a list of all deleted servers in a subscription. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/deleted-servers-list` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | ### Gets a list of deleted servers for a location. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/deleted-servers-list-by-location` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | locationName | string | yes | The name of the region where the resource is located. | ### Gets a deleted server. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/deleted-servers-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | locationName | string | yes | The name of the region where the resource is located. | | deletedServerName | string | yes | The name of the deleted server. | ### Recovers a deleted server. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/deleted-servers-recover` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | locationName | string | yes | The name of the region where the resource is located. | | deletedServerName | string | yes | The name of the deleted server. | ### Gets a list of a distributed availability groups in instance. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/distributed-availability-groups-list-by-instance` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | managedInstanceName | string | yes | The name of the managed instance. | ### Gets a distributed availability group info. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/distributed-availability-groups-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | managedInstanceName | string | yes | The name of the managed instance. | | distributedAvailabilityGroupName | string | yes | The distributed availability group name. | ### Creates a distributed availability group between Sql On-Prem and Sql Managed Instance. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/distributed-availability-groups-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | managedInstanceName | string | yes | The name of the managed instance. | | distributedAvailabilityGroupName | string | yes | The distributed availability group name. | | body | object | yes | JSON request body | ### Updates a distributed availability group replication mode. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/distributed-availability-groups-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | managedInstanceName | string | yes | The name of the managed instance. | | distributedAvailabilityGroupName | string | yes | The distributed availability group name. | | body | object | yes | JSON request body | ### Drops a distributed availability group between Sql On-Prem and Sql Managed Instance. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/distributed-availability-groups-delete` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | managedInstanceName | string | yes | The name of the managed instance. | | distributedAvailabilityGroupName | string | yes | The distributed availability group name. | ### Performs requested failover type in this distributed availability group. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/distributed-availability-groups-failover` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | managedInstanceName | string | yes | The name of the managed instance. | | distributedAvailabilityGroupName | string | yes | The distributed availability group name. | | body | object | yes | JSON request body | ### Sets the role for managed instance in a distributed availability group. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/distributed-availability-groups-set-role` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | managedInstanceName | string | yes | The name of the managed instance. | | distributedAvailabilityGroupName | string | yes | The distributed availability group name. | | body | object | yes | JSON request body | ### Gets a list of operations performed on the elastic pool. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/elastic-pool-operations-list-by-elastic-pool` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | elasticPoolName | string | yes | The name of the elastic pool. | ### Cancels the asynchronous operation on the elastic pool. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/elastic-pool-operations-cancel` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | elasticPoolName | string | yes | The name of the elastic pool. | | operationId | string | yes | The operation identifier. | ### Gets all elastic pools in a server. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/elastic-pools-list-by-server` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | $skip | integer | no | The number of elements in the collection to skip. | ### Gets an elastic pool. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/elastic-pools-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | elasticPoolName | string | yes | The name of the elastic pool. | ### Creates or updates an elastic pool. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/elastic-pools-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | elasticPoolName | string | yes | The name of the elastic pool. | | body | object | yes | JSON request body | ### Updates an elastic pool. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/elastic-pools-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | elasticPoolName | string | yes | The name of the elastic pool. | | body | object | yes | JSON request body | ### Deletes an elastic pool. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/elastic-pools-delete` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | elasticPoolName | string | yes | The name of the elastic pool. | ### Failovers an elastic pool. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/elastic-pools-failover` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | elasticPoolName | string | yes | The name of the elastic pool. | ### Gets a list of server encryption protectors `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/encryption-protectors-list-by-server` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | ### Gets a server encryption protector. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/encryption-protectors-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | encryptionProtectorName | string | yes | The name of the encryption protector to be retrieved. | ### Updates an existing encryption protector. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/encryption-protectors-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | encryptionProtectorName | string | yes | The name of the encryption protector to be retrieved. | | body | object | yes | JSON request body | ### Revalidates an existing encryption protector. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/encryption-protectors-revalidate` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | encryptionProtectorName | string | yes | The name of the encryption protector to be retrieved. | ### List certificates used on endpoints on the target instance. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/endpoint-certificates-list-by-instance` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | managedInstanceName | string | yes | The name of the managed instance. | ### Gets a certificate used on the endpoint with the given id. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/endpoint-certificates-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | managedInstanceName | string | yes | The name of the managed instance. | | endpointType | string | yes | Type of the endpoint whose certificate the customer is looking for. | ### Lists the failover groups in a server. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/failover-groups-list-by-server` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | ### Gets a failover group. `GET https://www.apizie.tech/v1/cloud:azure-arm-sql/failover-groups-get` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | failoverGroupName | string | yes | The name of the failover group. | ### Creates or updates a failover group. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/failover-groups-create-or-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | failoverGroupName | string | yes | The name of the failover group. | | body | object | yes | JSON request body | ### Updates a failover group. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/failover-groups-update` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | failoverGroupName | string | yes | The name of the failover group. | | body | object | yes | JSON request body | ### Deletes a failover group. `POST https://www.apizie.tech/v1/cloud:azure-arm-sql/failover-groups-delete` (byok) | Parameter | Type | Required | Description | |---|---|---|---| | api-version | string | no | The API version to use for this operation. | | subscriptionId | string | yes | The ID of the target subscription. The value must be an UUID. | | resourceGroupName | string | yes | The name of the resource group. The name is case insensitive. | | serverName | string | yes | The name of the server. | | failoverGroupName | string | yes | The name of the failover group. | …and 280 more. See the OpenAPI spec. ## Example ``` curl "https://www.apizie.tech/v1/cloud:azure-arm-sql/backup-short-term-retention-policies-list-by-database" \ -H "x-api-key: $APIZIE_KEY" \ -H "x-upstream-key: $PROVIDER_KEY" ``` ## FAQ ### How do I call the Azure Sql management API? Create a free Apizie key, then send GET https://www.apizie.tech/v1/cloud:azure-arm-sql/backup-short-term-retention-policies-list-by-database with the header x-api-key. Every endpoint returns { project, data, timestamp }. ### Is the Azure Sql management API free on Apizie? Yes. The Free plan includes 1,000 requests a month at 100 requests a minute, no credit card. Azure Sql management itself also needs your own key from azure.com. ### Can AI agents use the Azure Sql management 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 cloud:azure-arm-sql. ### What is the status of the Azure Sql management API? Needs your own provider key (bring your own key)