Azure SQL: Sql Core
Provides create, read, update and delete functionality for Azure SQL Database resources including recommendations and operations.
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
Provides create, read, update and delete functionality for Azure SQL Database resources including recommendations and operations.
Endpoints 7
ElasticPools
- GETElasticPoolActivities_ListByElasticPool
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/elasticPools/:elasticPoolName/elasticPoolActivityReturns elastic pool activities. - GETElasticPoolDatabaseActivities_ListByElasticPool
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/elasticPools/:elasticPoolName/elasticPoolDatabaseActivityReturns activity on databases inside of an elastic pool.
ServiceTierAdvisors
- GETServiceTierAdvisors_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/serviceTierAdvisors/:serviceTierAdvisorNameGets a service tier advisor. - GETServiceTierAdvisors_ListByDatabase
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/serviceTierAdvisorsReturns service tier advisors for specified database.
TransparentDataEncryption
- GETTransparentDataEncryptions_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/transparentDataEncryption/:transparentDataEncryptionNameGets a database's transparent data encryption configuration. - PUTTransparentDataEncryptions_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/transparentDataEncryption/:transparentDataEncryptionNameCreates or updates a database's transparent data encryption configuration. - GETTransparentDataEncryptionActivities_ListByConfiguration
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/transparentDataEncryption/:transparentDataEncryptionName/operationResultsReturns a database's transparent data encryption operation result.
API details
- Base URL
https://management.azure.com- Authentication
- OAuth 2.0 (implicit flow) with 1 scope
- Operations
- 7 operations on 6 pathsGET 6PUT 1
- Main resources
- TransparentDataEncryption 3ElasticPools 2ServiceTierAdvisors 2
- Response formats
application/json- Description format
- Swagger 2.0, API version
2014-04-01 - Links
- OpenAPI document
How to test the Azure SQL: Sql Core 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: Sql Core 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 “ElasticPoolActivities_ListByElasticPool” (GET /subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/elasticPools/:elasticPoolName/elasticPoolActivity), and press Send. Check the response, add tests and run the whole collection with the runner.
Frequently asked questions
What is the Azure SQL: Sql Core?
Provides create, read, update and delete functionality for Azure SQL Database resources including recommendations and operations. It is listed under Data & analytics and has 7 endpoints.
Who publishes the Azure SQL: Sql Core?
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: Sql Core?
Requests go to https://management.azure.com. Endpoint paths are added to this base URL.
How do I authenticate with the Azure SQL: Sql Core?
With OAuth 2.0 (implicit flow) with 1 scope.
How many endpoints does the Azure SQL: Sql Core have?
7 operations on 6 paths (6 GET, 1 PUT). The largest groups are TransparentDataEncryption, ElasticPools, ServiceTierAdvisors.
Is forking the Azure SQL: Sql Core free?
Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.