How to retrieve an SQL Database database information

Learn how to retrieve an SQL Database database information.

View as Markdown

This guide demonstrates how to use Azion SQL Database to retrieve a database’s information using the Azion API.

Retrieving a database’s information

Run the following GET request in your terminal, replacing [TOKEN VALUE] with your personal token and [DB_ID] with the ID of the database:

curl --location 'https://api.azion.com/v4/edge_sql/databases/[DB_ID]' \
--header 'Accept: application/json' \
--header 'Authorization: Token <token_value>'

You should receive the following response:

{
"data": {
"id": [DB_ID],
"name": "dbname",
"client_id": "",
"status": "created",
"created_at": "2024-06-17T14:35:33.430878Z",
"updated_at": "2024-06-17T14:36:00.083526Z",
"deleted_at": null,
"is_active": true
}
}