This is an archive version of the document. To get the most up-to-date information, see the current version.

Get Collection of Protected Items

You can get a list of all protected Azure SQL databases.

Request

To retrieve a representation of a collection of protected databases, send the HTTP GET request to the /protectedItem/sql endpoint.

HTTP Request

GET https://<hostname>/api/v3/protectedItem/sql

Query Parameters

To control the amount and order of data in the response, you can use Offset, Limit, SearchPattern and the following query parameters:

Query Parameter

Value

Description

ServerId

string

Returns only databases located on an SQL Server with the specified ID.

DatabaseIds

array[string]

Returns only specific databases.

Sync

boolean

Defines whether Veeam Backup for Microsoft Azure database is synchronized with Azure resources.

Request Headers

The request contains the following headers.

Header

Required

Value

Description

Authorization

Required

Bearer <Access-Token>

Authenticates a client who sends the request to the server. Must contain the access token for the current logon session in the Bearer <Access-Token> format.

Response

The server returns the following response to the client.

Response Codes

A successfully completed operation returns a response code 200 (OK).

Response Headers

The response to this request contains the following headers. The response may also include additional standard HTTP headers.

Header

Value

Description

Content-length

integer

Identifies the length of the response body message, in bytes.

Content-type

  • application/json
  • application/problem+json

Identifies the media type of the response body message.

Response Body

In the response body, Veeam Backup for Microsoft Azure returns a representation of the /protectedItem/sql collection. The ProtectedDatabaseV3 schema is used for the collection representation.

Get Collection of Protected ItemsExample

The following request returns a full list of protected databases.

Request:

GET https://51.11.247.127/api/v3/protectedItem/sql

 

Request Header:

Authorization: Bearer <Access-Token>

 

Response:

200

 

Response Body:

{

 "offset": 0,

 "limit": 200,

 "totalCount": 2,

 "results": [

   {

     "id": "aii53ntfg1mw6zckcq354cmq1u1m31kfka3k9kbrji86efz6unuo",

     "azureId": "/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/jf_uk/providers/microsoft.sql/managedinstances/jf-uk-sql-managedinstance/databases/uk-server-db17-replicafromarchive",

     "name": "uk-server-db-matrix17-replicaFromArchive",

     "sqlServer": {

       "id": "yt9o7xc9b5ien885b89px1pnknia6qa7jyeuba8kdf3y7y4r5nzo",

       "name": "jf-uk-sql-managedinstance",

       "serverType": "Managed"

     },

     "azureEnvironment": "Global",

     "sizeInMb": 3,

     "subscriptionId": "280921a2-220d-45c9-92dd-82b6d5a3a78f",

     "lastBackup": "2021-09-14T16:07:28Z",

     "subscription": {

       "id": "280921a2-220d-45c9-92dd-82b6d5a3a78f",

       "environment": "Global",

       "tenantId": "97438793-c913-4a51-8485-d33056db7b9b",

       "tenantName": "Veeam Software Group GmbH",

       "name": "Enterprise - QA",

       "status": "Active"

     },

     "region": {

       "id": "uksouth",

       "name": "uksouth"

     },

     "resourceGroup": {

       "id": "6k9q3biyjy5nm174uzkng5skd56e91agxi81gwru4hfecdd6a9my",

       "resourceId": "/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/jf_uk",

       "name": "jf_uk",

       "azureEnvironment": "Global",

       "subscriptionId": "280921a2-220d-45c9-92dd-82b6d5a3a78f",

       "regionId": "uksouth"

     },

     "_links": {

       "restorepoint": {

         "href": "https://51.11.247.127/api/v3/restorePoints/sql/2cbecb3e-93fc-41a7-bdb2-3a81133d45d6"

       },

       "subscription": {

         "href": "https://51.11.247.127/api/v3/cloudInfrastructure/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f"

       },

       "resourcegroup": {

         "href": "https://51.11.247.127/api/v3/cloudInfrastructure/resourceGroups/6k9q3biyjy5nm174uzkng5skd56e91agxi81gwru4hfecdd6a9my"

       }

     }

   },

   {

     "id": "ktrn48t517racaj543nagwknyw34or51dqfwwi1ywrjo9jantzdo",

     "azureId": "/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/jf_uk/providers/microsoft.sql/servers/jf-uk-sqlserver-alternative/databases/jf-uk-db-alternative",

     "name": "jf-uk-db-alternative",

     "sqlServer": {

       "id": "snyxx7356c6t6bfutntc9k8gme6nj1uw6za6npen1yjp54j3kn5o",

       "name": "jf-uk-sqlserver-alternative",

       "serverType": "Unmanaged"

     },

     "azureEnvironment": "Global",

     "sizeInMb": 3,

     "subscriptionId": "280921a2-220d-45c9-92dd-82b6d5a3a78f",

     "lastBackup": "2021-07-29T14:10:37Z",

     "subscription": {

       "id": "280921a2-220d-45c9-92dd-82b6d5a3a78f",

       "environment": "Global",

       "tenantId": "97438793-c913-4a51-8485-d33056db7b9b",

       "name": "Enterprise - QA",

       "status": "Active"

     },

     "region": {

       "id": "uksouth",

       "name": "uksouth"

     },

     "resourceGroup": {

       "id": "6k9q3biyjy5nm174uzkng5skd56e91agxi81gwru4hfecdd6a9my",

       "resourceId": "/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f/resourcegroups/jf_uk",

       "name": "jf_uk",

       "azureEnvironment": "Global",

       "subscriptionId": "280921a2-220d-45c9-92dd-82b6d5a3a78f",

       "regionId": "uksouth"

     },

     "_links": {

       "restorepoint": {

         "href": "https://13.67.57.233/api/v3/restorePoints/sql/e9cb98a3-a005-41fc-83d2-e9be2dc02a1d"

       },

       "subscription": {

         "href": "https://51.11.247.127/api/v3/cloudInfrastructure/subscriptions/280921a2-220d-45c9-92dd-82b6d5a3a78f"

       },

       "resourcegroup": {

         "href": "https://51.11.247.127/api/v3/cloudInfrastructure/resourceGroups/6k9q3biyjy5nm174uzkng5skd56e91agxi81gwru4hfecdd6a9my"

       }

     }

   }

 ],

 "_links": {

   "self": {

     "href": "https://51.11.247.127/api/v3/protectedItem/sql?offset=0&limit=200"

   }

 }

}