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 this API, learn how to authenticate it.
Before calling this API, learn about request header parameters.

URI

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

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Description
project_id	Yes	Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID. Constraints N/A Range N/A Default Value N/A
database_name	Yes	Definition DB engine. Constraints N/A Range The value can be any of the following and is case-insensitive: MySQL PostgreSQL SQLServer Default Value N/A

Request

Request parameters
None

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

Response

Normal response

**Table 2** Parameters
Parameter	Type	Description
dataStores	Array of objects	Definition Database versions. For details, see Table 3.

**Table 3** dataStores field data structure description
Parameter	Type	Description
id	String	Definition Database version ID. The value is unique. Range N/A
name	String	Definition Database version number. Range 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"
	}]
}