Get Page 7

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


Authentication
This operation uses the following authentication methods.
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",
                "vcResourcePoolName": "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
            },
            "rootPasswordExpiryInfo": {
                "expiryDate": "string",
                "noOfDaysToWarn": 0,
                "noOfDaysToExpire": 0,
                "warning": false,
                "expired": false,
                "status": "string"
            },
            "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
    }
}
array of Link
links
Optional

links

content
Optional

content

page
Optional

page


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
POST
Create Db Cluster
DELETE
Delete 1
DELETE
Delete Db Cluster
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
Modify Member Settings
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
PUT
Update Alert Rule Set 1
POST
Update Alert Type As Verified
PUT
Update Database Notifications
PATCH
Update Db Engine Rpm
PATCH
Update Db Os