Select Database Instance
Select
SaaS
Customer Managed
This API returns list of instances for the selected cloud account.
Query Parameters
- regionId integer
Id of the region, Use select region to get ID. Application for SaaS
- cloudAccountId integer required
Id of the cloud Account
- backupGateways string
Comma separated backupGateway Client IDs. Not needed for directCloudBackup
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
rdsDBInstances object[]
allocatedStorage integerdbName stringregionName stringreadReplicaSourceDBInstanceIdentifier stringavailabilityZone stringpreferredBackupWindow stringdbInstanceStatus stringsecondaryAvailabilityZone stringengine stringiops integerpubliclyAccessible booleanengineVersion stringmasterUsername stringisMultAZ booleandbInstanceIdentifier stringvpcSecurityGroup stringcharacterSetName stringinstanceCreateTime integerdBInstanceClass stringdbSecurityGroup stringendPoint stringport integerlicenseModel stringpreferredMaintenanceWindow stringbackupRetentionPeriod integerdbSubnetGroup stringautoMinorVersionUpgrade booleanlatestRestorableTime integer
{
"rdsDBInstances": [
{
"allocatedStorage": 0,
"dbName": "string",
"regionName": "string",
"readReplicaSourceDBInstanceIdentifier": "string",
"availabilityZone": "string",
"preferredBackupWindow": "string",
"dbInstanceStatus": "string",
"secondaryAvailabilityZone": "string",
"engine": "string",
"iops": 0,
"publiclyAccessible": true,
"engineVersion": "string",
"masterUsername": "string",
"isMultAZ": true,
"dbInstanceIdentifier": "string",
"vpcSecurityGroup": "string",
"characterSetName": "string",
"instanceCreateTime": 0,
"dBInstanceClass": "string",
"dbSecurityGroup": "string",
"endPoint": "string",
"port": 0,
"licenseModel": "string",
"preferredMaintenanceWindow": "string",
"backupRetentionPeriod": 0,
"dbSubnetGroup": "string",
"autoMinorVersionUpgrade": true,
"latestRestorableTime": 0
}
]
}
{
"rdsDBInstances": [
{
"allocatedStorage": 102400,
"dbName": "jah-mariadb",
"regionName": "eastus",
"readReplicaSourceDBInstanceIdentifier": "",
"availabilityZone": "eastus",
"preferredBackupWindow": "",
"dbInstanceStatus": "Ready",
"secondaryAvailabilityZone": "",
"engine": "mysql",
"iops": -1237422264,
"publiclyAccessible": false,
"engineVersion": "10.3",
"masterUsername": "joelhoward",
"isMultAZ": true,
"dbInstanceIdentifier": "mariadb/jah-mariadb",
"vpcSecurityGroup": "",
"characterSetName": "",
"instanceCreateTime": 4294967294,
"dBInstanceClass": "",
"dbSecurityGroup": "",
"endPoint": "jah-mariadb.mariadb.database.azure.com",
"port": 3306,
"licenseModel": "",
"preferredMaintenanceWindow": "",
"backupRetentionPeriod": 7,
"dbSubnetGroup": "",
"autoMinorVersionUpgrade": true,
"latestRestorableTime": 3056332224
},
{
"allocatedStorage": 102400,
"dbName": "mariadb103",
"regionName": "eastus",
"readReplicaSourceDBInstanceIdentifier": "",
"availabilityZone": "eastus",
"preferredBackupWindow": "",
"dbInstanceStatus": "Ready",
"secondaryAvailabilityZone": "",
"engine": "mysql",
"iops": -1237422264,
"publiclyAccessible": false,
"engineVersion": "10.3",
"masterUsername": "test",
"isMultAZ": true,
"dbInstanceIdentifier": "mariadb/mariadb103",
"vpcSecurityGroup": "",
"characterSetName": "",
"instanceCreateTime": 4294967294,
"dBInstanceClass": "",
"dbSecurityGroup": "",
"endPoint": "mariadb103.mariadb.database.azure.com",
"port": 3306,
"licenseModel": "",
"preferredMaintenanceWindow": "",
"backupRetentionPeriod": 7,
"dbSubnetGroup": "",
"autoMinorVersionUpgrade": true,
"latestRestorableTime": 3056332224
}
]
}
Loading...