Domain name for API request: sqlserver.tencentcloudapi.com.
This API is used to query the list of instances.
A maximum of 20 requests can be initiated per second for this API.
The following request parameter list only provides API request parameters and some common parameters. For the complete common parameter list, see Common Request Parameters.
Parameter Name | Required | Type | Description |
---|---|---|---|
Action | Yes | String | Common Params. The value used for this API: DescribeDBInstances. |
Version | Yes | String | Common Params. The value used for this API: 2018-03-28. |
Region | Yes | String | Common Params. For more information, please see the list of regions supported by the product. |
ProjectId | No | Integer | Project ID |
Status | No | Integer | Instance status. Valid values: |
Offset | No | Integer | Page number. Default value: 0 |
Limit | No | Integer | Number of results per page. Value range: 1-100. Default value: 100 |
InstanceIdSet.N | No | Array of String | One or more instance IDs in the format of mssql-si2823jyl |
PayMode | No | Integer | Retrieves billing type. 0: pay-as-you-go |
VpcId | No | String | Unique string-type ID of instance VPC in the format of vpc-xxx . If an empty string ("") is passed in, filtering will be made by basic network. |
SubnetId | No | String | Unique string-type ID of instance subnet in the format of subnet-xxx . If an empty string ("") is passed in, filtering will be made by basic network. |
VipSet.N | No | Array of String | The list of instance private IPs, such as 172.1.0.12 |
InstanceNameSet.N | No | Array of String | The list of instance names used for fuzzy match |
VersionSet.N | No | Array of String | The list of instance version numbers, such as 2008R2, 2012SP3 |
Zone | No | String | Instance availability zone, such as ap-guangzhou-2 |
TagKeys.N | No | Array of String | The list of instance tags |
SearchKey | No | String | Keyword used for fuzzy match, including instance ID, instance name, and instance private IP |
UidSet.N | No | Array of String | Unique Uid of an instance |
InstanceType | No | String | Instance type. Valid values: HA (high-availability), RO (read-only), SI (basic edition), BI (business intelligence service). |
Parameter Name | Type | Description |
---|---|---|
TotalCount | Integer | Total number of eligible instances. If the results are returned in multiple pages, this value will be the number of all eligible instances but not the number of instances returned according to the current values of Limit and Offset |
DBInstances | Array of DBInstance | Instance list |
RequestId | String | The unique request ID, which is returned for each request. RequestId is required for locating a problem. |
POST / HTTP/1.1
Host: sqlserver.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: DescribeDBInstances
<Common request parameters>
{
"Status": "2",
"SearchKey": "172.17.0.12",
"VpcId": "vpc-mknbt351",
"Zone": "ap-guangzhou-2",
"VersionSet": [
"2008R2"
],
"ProjectId": "0",
"Offset": "0",
"PayMode": "1",
"Limit": "3",
"InstanceIdSet": [
"mssql-3l3fgqn7"
],
"SubnetId": "subnet-f72hylo6",
"TagKeys": [
"Test tag"
],
"VipSet": [
"172.1.0.12"
],
"InstanceNameSet": [
“Data warehouse”
]
}
{
"Response": {
"DBInstances": [
{
"BackupCycle": [
1
],
"BackupCycleType": "daily",
"BackupModel": "master_pkg",
"BackupSaveDays": 7,
"BackupTime": "07:03:00",
"Collation": "Chinese_PRC_CI_AS",
"Cpu": 4,
"CreateTime": "2022-11-07 16:21:01",
"CrossBackupEnabled": "disable",
"CrossBackupSaveDays": 0,
"CrossRegions": [],
"DnsPodDomain": "",
"EndTime": "0000-00-00 00:00:00",
"HAFlag": "SINGLE",
"InstanceId": "mssql-fz80u7u1",
"InstanceNote": "",
"InstanceType": "SI",
"IsolateOperator": "",
"IsolateTime": "0000-00-00 00:00:00",
"Memory": 8,
"Model": 2,
"Name": "2008-2012-2016",
"PayMode": 0,
"Pid": 1003456,
"ProjectId": 0,
"ROFlag": "",
"Region": "ap-guangzhou",
"RegionId": 1,
"RenewFlag": 0,
"ResourceTags": null,
"IsDrZone": false,
"SlaveZones": {
"SlaveZone": "",
"SlaveZoneName": ""
},
"StartTime": "2022-11-07 16:21:01",
"Status": 2,
"Storage": 40,
"SubFlag": "",
"SubnetId": 2118677,
"TgwWanVPort": 0,
"TimeZone": "China Standard Time",
"Type": "CLOUD_PREMIUM",
"Uid": "gamedb.gz1208.cdb.db",
"UniqSubnetId": "subnet-ieianm0o",
"UniqVpcId": "vpc-o739nubl",
"UpdateTime": "2022-11-07 20:04:03",
"UsedStorage": 0,
"Version": "2019",
"VersionName": "SQL Server 2019 Enterprise",
"Vip": "10.24.12.28",
"VpcId": 5350471,
"Vport": 1433,
"Zone": "ap-guangzhou-1"
"ZoneId": 100003
}
],
"RequestId": "de641788-0565-4617-a7f4-639de128772b",
"TotalCount": 1
}
}
TencentCloud API 3.0 integrates SDKs that support various programming languages to make it easier for you to call APIs.
The following only lists the error codes related to the API business logic. For other error codes, see Common Error Codes.
Error Code | Description |
---|---|
FailedOperation.DBError | Database error. |
FailedOperation.GcsError | The operation failed or the network timed out. |
InternalError | Internal error. |
InternalError.SystemError | System error. |
InternalError.UnknownError | Unknown error. |
InvalidParameter | Invalid parameter. |
InvalidParameter.InputIllegal | Input error. |
InvalidParameter.ParamsAssertFailed | An error occurred while converting parameter assertion. |
ResourceNotFound.VpcNotExist | The VPC does not exist. |
UnauthorizedOperation.PermissionDenied | CAM authentication error. |
Was this page helpful?