Microsoft Azure

Azure SQL: Table Auditing

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 8

TableAuditing

  • GETServerTableAuditingPolicies_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/auditingPolicies/:tableAuditingPolicyNameDeprecated. Gets a server's table auditing policy. Table auditing is deprecated, use blob auditing instead.
  • PUTServerTableAuditingPolicies_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/auditingPolicies/:tableAuditingPolicyNameDeprecated. Creates or updates a server's table auditing policy. Table auditing is deprecated, use blob auditing instead.
  • GETServerTableAuditingPolicies_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/auditingPoliciesDeprecated. Lists a server's table auditing policies. Table auditing is deprecated, use blob auditing instead.
  • GETDatabaseTableAuditingPolicies_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/auditingPolicies/:tableAuditingPolicyNameDeprecated. Gets a database's table auditing policy. Table auditing is deprecated, use blob auditing instead.
  • PUTDatabaseTableAuditingPolicies_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/auditingPolicies/:tableAuditingPolicyNameDeprecated. Creates or updates a database's table auditing policy. Table auditing is deprecated, use blob auditing instead.
  • GETDatabaseTableAuditingPolicies_ListByDatabase/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/auditingPoliciesDeprecated. Lists a database's table auditing policies. Table auditing is deprecated, use blob auditing instead.
  • GETDatabaseConnectionPolicies_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/connectionPolicies/:connectionPolicyNameDeprecated. Gets a database's connection policy, which is used with table auditing. Table auditing is deprecated, use blob auditing instead.
  • PUTDatabaseConnectionPolicies_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/connectionPolicies/:connectionPolicyNameDeprecated. Creates or updates a database's connection policy, which is used with table auditing. Table auditing is deprecated, use blob auditing instead.

API details

Base URL
https://management.azure.com
Authentication
OAuth 2.0 (implicit flow) with 1 scope
Operations
8 operations on 5 pathsGET 5PUT 3
8 marked deprecated
Main resources
TableAuditing 8
Response formats
application/json
Description format
Swagger 2.0, API version 2014-04-01

How to test the Azure SQL: Table Auditing in Swastik Codes

  1. Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
  2. Fork it into your workspaceChoose a workspace. You get your own copy of the Azure SQL: Table Auditing collection, without the publisher's secrets.
  3. 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.
  4. Send a requestPick an endpoint, for example “ServerTableAuditingPolicies_Get” (GET /subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/auditingPolicies/:tableAuditingPolicyName), and press Send. Check the response, add tests and run the whole collection with the runner.

Frequently asked questions

What is the Azure SQL: Table Auditing?

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 8 endpoints.

Who publishes the Azure SQL: Table Auditing?

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: Table Auditing?

Requests go to https://management.azure.com. Endpoint paths are added to this base URL.

How do I authenticate with the Azure SQL: Table Auditing?

With OAuth 2.0 (implicit flow) with 1 scope.

How many endpoints does the Azure SQL: Table Auditing have?

8 operations on 5 paths (5 GET, 3 PUT). The largest groups are TableAuditing.

Is forking the Azure SQL: Table Auditing free?

Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.

Suggest an API

Tell us which public API is missing. We check it, then add it here with its endpoints when it has an OpenAPI (Swagger) description.