Get Page 7
Endpoint to get databases
Authorized Roles : PROVIDER or ORG_ADMIN or ORG_USER
Request
URI
GET
https://{api_host}/provider/databases
COPY
Query Parameters
integer
page
Optional
Zero-based page index (0..N)
integer
size
Optional
The size of the page to be returned
string of array
sort
Optional
Sorting criteria in the format: property(,asc|desc). Default sort order is ascending. Multiple sort criteria are supported.
string
environmentId
Optional
Filter based on environment ID
string of array
namespaceId
Optional
Filter based on namespace IDs
string
tenantId
Optional
Filter based on organization ID
string
instanceName
Optional
Filter based on instance name
string of array
engines
Optional
Filter based on engines
string of array
versions
Optional
Filter based on versions
string of array
tags
Optional
Filter based on tags
string of array
roles
Optional
Filter based on roles
string of array
statuses
Optional
Filter based on statuses
integer of array
userIds
Optional
Filter based on users ids
Responses
200
OK
Returns PagedModelListViewManagedDbDTO of type(s) application/vnd.vmware.dms-v1+json
{
"links": [
{
"rel": "string",
"href": "string",
"hreflang": "string",
"media": "string",
"title": "string",
"type": "string",
"deprecation": "string",
"profile": "string",
"name": "string"
}
],
"content": [
{
"id": "string",
"instanceName": "string",
"environment": {
"environmentId": "string",
"vcHost": "string",
"vcClusterName": "string"
},
"tenantId": "string",
"dbType": "string",
"role": "string",
"version": "string",
"status": "string",
"createdTimestamp": "string",
"user": {
"id": 0,
"firstName": "string",
"lastName": "string",
"contactNumber": "string",
"email": "string",
"password": "string",
"tenantId": "string",
"companyName": "string",
"type": "string",
"roles": [
"string"
],
"forcePasswordChange": false,
"links": [
{
"rel": "string",
"href": "string",
"hreflang": "string",
"media": "string",
"title": "string",
"type": "string",
"deprecation": "string",
"profile": "string",
"name": "string"
}
]
},
"tags": [
{
"id": "string",
"orgId": "string",
"name": "string",
"createdTime": "string",
"modifiedTime": "string",
"lastModified": "string",
"assignedInstanceCount": 0
}
],
"enableProtection": false,
"namespace": {
"id": "string",
"name": "string",
"type": "string"
},
"edition": "string",
"hwConfig": {
"hdDiskSizeGB": 0,
"cpuCores": 0,
"memoryGB": 0,
"thinDisk": false
},
"links": [
{
"rel": "string",
"href": "string",
"hreflang": "string",
"media": "string",
"title": "string",
"type": "string",
"deprecation": "string",
"profile": "string",
"name": "string"
}
]
}
],
"page": {
"size": 0,
"totalElements": 0,
"totalPages": 0,
"number": 0
}
}
400
Bad Request
Operation doesn't return any data structure
Databases Operations
POST
Add Read Replica
PUT
Change Backup Storage
PUT
Change Db Options
PATCH
Change Db Owner
PUT
Change Edition
POST
Create 7
POST
Create 8
DELETE
Delete 1
POST
Disable Require Client Ssl
POST
Enable Require Client Ssl
GET
Export Db Ca Certificate
GET
Export Db Server Certificate 1
GET
Export To CSV
GET
Export To XLS
PUT
Extend Db Disk
GET
Fetch Db Disk Freespace
GET
Fetch Supported Edition Upgrades
POST
Generate Db Logs
GET
Get Database Alerts History
GET
Get Database Notifications
GET
Get Database Search Filter Values
GET
Get Db
GET
Get DB Admin Password
GET
Get Db Updates
GET
Get Db Version
GET
Get DB Vm Root Password
GET
Get Flagged Db Alert Types
GET
Get Page 7
GET
Get PITR Allowed Range By DB
GET
Get Protection Details
GET
Get Replica Deployable Namespaces
PUT
Modify Backup Config
PUT
Modify Db Config
PUT
Poweroff
PUT
Poweron
POST
Promote Read Replica
POST
Protect
PUT
Provider Disable Db Vm Ssh
PUT
Provider Enable Db Vm Ssh
PATCH
Refresh Db Certificate
PATCH
Resync Db Trusted Certificates
PUT
Scaledbconfig
POST
Submit Clone Task
POST
Submit PITR Task
POST
Submit Recover Task
POST
Submit Restore Task
PUT
Tenant Disable Db Vm Ssh
PUT
Tenant Enable Db Vm Ssh
POST
Update Alert Type As Verified
PUT
Update Database Notifications
PATCH
Update Db Engine Rpm
PATCH
Update Db Os