Export Collection Azure SQL Database

In this article

    You can export a list of Azure SQL databases to a CSV or an XML file and download the file. To specify the required type of the file, use the Accept request header.

    Request

    To retrieve a representation of a collection of Azure SQL databases, send the HTTP POST request to the /databases/export endpoint.

    HTTP Request

    POST https://<hostname>/api/v3/databases/export

    Request Headers

    The request contains the following headers.

    Header

    Required/Optional

    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.

    Accept

    Optional

    • text/scv
    • application/xml

    Specifies a media type of representation of the exported data. The default value is text/csv media type.

    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 link to download the file with the exported list of Azure SQL databases.

    Export Collection Azure SQL DatabaseExample

    The following request exports a full list of Azure SQL databases.

    Request:

    POST https://51.11.247.127/api/v3/databases/export

     

    Request Header:

    Authorization: Bearer <Access-Token>

    Accept: text/scv

     

    Response:

    200

     

    Response Body:

    Download file