Querying Version Information About a DB Engine

Function

This API is used to query the database version information of a specified DB engine.

Before calling an API, you need to understand the API in Authentication.

URI

URI format
GET /v3/{project_id}/datastores/{database_name}

Parameter description

**Table 1** Parameter description
Name	Mandatory	Description
project_id	Yes	Project ID of a tenant in a region. For details about how to obtain the project ID, see Obtaining a Project ID.
database_name	Yes	Specifies the DB engine. Its value can be any of the following and is case-insensitive: MySQL PostgreSQL SQLServer

Request

Request parameters
None

URI example
GET https://{endpoint}/v3/619d3e78f61b4be68bc5aa0b59edcf7b/datastores/mysql

Response

Normal response

**Table 2** Parameter description
Name	Type	Description
dataStores	Array of objects	Indicates the list of database versions. For details, see Table 3.

**Table 3** dataStores field data structure description
Name	Type	Description
id	String	Indicates the database version ID. Its value is unique.
name	String	Indicates the database version number. For MySQL, the minor version number can be returned. For example, if the DB engine version is MySQL 5.6.51, 5.6.51 is returned. For PostgreSQL and Microsoft SQL Server, only the major version number (two digits) is returned. For example, if the DB engine version is PostgreSQL 9.6.X, only 9.6 is returned.

Example normal response

{
	"dataStores": [{
		"id": "87620726-6802-46c0-9028-a8785e1f1921",
		"name": "8.0.21"
	}, {
		"id": "87620726-6802-46c0-9028-a8785e1f1922",
		"name": "5.7.33"
	}, {
		"id": "e8a8b8cc-63f8-4fb5-8d4a-24c502317a62",
		"name": "5.6.51"
	}]
}