Azure SQL: Managed Instances
The Azure SQL Database management API provides a RESTful set of web APIs that interact with Azure SQL Database services to manage your databases. The API…
Data & analytics#openapi#cloud
Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.
Overview
The Azure SQL Database management API provides a RESTful set of web APIs that interact with Azure SQL Database services to manage your databases. The API enables users to create, retrieve, update, and delete databases, servers, and other entities.
Endpoints 15
ManagedInstances
- GETManagedInstances_List
/subscriptions/:subscriptionId/providers/Microsoft.Sql/managedInstances?$expand=stringGets a list of all managed instances in the subscription. - GETManagedInstances_ListByInstancePool
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/instancePools/:instancePoolName/managedInstances?$expand=stringGets a list of all managed instances in an instance pool. - GETManagedInstances_ListByResourceGroup
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances?$expand=stringGets a list of managed instances in a resource group. - GETManagedInstances_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceName?$expand=stringGets a managed instance. - PUTManagedInstances_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceNameCreates or updates a managed instance. - DELETEManagedInstances_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceNameDeletes a managed instance. - PATCHManagedInstances_Update
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceNameUpdates a managed instance. - POSTManagedInstances_Failover
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceName/failover?replicaType=PrimaryFailovers a managed instance. - GETManagedInstances_ListOutboundNetworkDependenciesByManagedInstance
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceName/outboundNetworkDependenciesEndpointsGets the collection of outbound network dependencies for the given managed instance. - POSTManagedInstances_ReevaluateInaccessibleDatabaseState
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceName/reevaluateInaccessibleDatabaseStateReevaluates the inaccessibility state of all managed databases. - POSTManagedInstances_RefreshStatus
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceName/refreshExternalGovernanceStatusRefresh external governance enablement status. - POSTManagedInstances_Start
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceName/startStarts the managed instance. - POSTManagedInstances_Stop
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceName/stopStops the managed instance. - GETManagedInstances_ListByManagedInstance
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceName/topqueries?numberOfQueries=0&databases=string&startTime=string&endTime=string&interval=PT1H&aggregationFunction=avg&observationMetric=cpuGet top resource consuming queries of a managed instance. - POSTManagedInstances_ValidateAzureKeyVaultEncryptionKey
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/managedInstances/:managedInstanceName/validateAzureKeyVaultEncryptionKeyValidates customer managed key.
API details
- Base URL
https://management.azure.com- Authentication
- OAuth 2.0 (implicit flow) with 1 scope
- Operations
- 15 operations on 12 pathsGET 6POST 6PUT 1PATCH 1DELETE 1
- Main resources
- ManagedInstances 15
- Response formats
application/json- Description format
- Swagger 2.0, API version
2025-01-01 - Links
- OpenAPI document
How to test the Azure SQL: Managed Instances in Swastik Codes
- Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
- Fork it into your workspaceChoose a workspace. You get your own copy of the Azure SQL: Managed Instances collection, without the publisher's secrets.
- Add your credentialsThis API uses OAuth 2.0 (implicit flow) with 1 scope. Add yours in the collection's variables or an environment; the requests already reference it.
- Send a requestPick an endpoint, for example “ManagedInstances_List” (GET /subscriptions/:subscriptionId/providers/Microsoft.Sql/managedInstances?$expand=string), and press Send. Check the response, add tests and run the whole collection with the runner.
Frequently asked questions
What is the Azure SQL: Managed Instances?
The Azure SQL Database management API provides a RESTful set of web APIs that interact with Azure SQL Database services to manage your databases. The API… It is listed under Data & analytics and has 15 endpoints.
Who publishes the Azure SQL: Managed Instances?
It is listed from Microsoft Azure's public API description (an OpenAPI document), not published by Microsoft Azure on Swastik Codes. Anyone who controls azure.com can claim the profile by adding a DNS TXT record.
What is the base URL of the Azure SQL: Managed Instances?
Requests go to https://management.azure.com. Endpoint paths are added to this base URL.
How do I authenticate with the Azure SQL: Managed Instances?
With OAuth 2.0 (implicit flow) with 1 scope.
How many endpoints does the Azure SQL: Managed Instances have?
15 operations on 12 paths (6 GET, 6 POST, 1 PUT, 1 PATCH, 1 DELETE). The largest groups are ManagedInstances.
Is forking the Azure SQL: Managed Instances free?
Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.