Discover databases on the DB server using instance id
Select
SaaS
Customer Managed
This operation returns the list of databases on the server that are not backed up part of database group.
Applicable for GCP MySQL, PostgreSQL.
Path Parameters
- instanceId integer required
Id of the instance
- application/json
Request Body
- path string required
set to "/"
entity object
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
mysqlContent object[]
error object
{
"mysqlContent": [
{
"databaseName": "string",
"creationTime": 0,
"databaseSize": 0,
"associatedSC": {
"_type_": 0,
"subclientId": 0
}
}
],
"error": {}
}
{
"mysqlContent": [
{
"databaseName": "/aashdemo",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/amazondb1",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/azuredb1",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/db1",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/mydatabase",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/mytestdb",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/mytestdb28",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/sp22winsub",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/sp22winsub1",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/test",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/test1",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/test2p24db",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/test_db",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/testdata",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/testdata10",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/testdata2",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/testdata3",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/testdata4",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/testdata5",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/testdb",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
},
{
"databaseName": "/testdb1",
"creationTime": 1711448487,
"databaseSize": 0,
"associatedSC": {
"_type_": 7,
"subclientId": 0
}
}
],
"error": {}
}
POST /instance/dbbrowse/:instanceid
Authorization
type: apiKeyname: Authtokenin: header
Request
Request
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/instance/dbbrowse/:instanceId' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"path": "string",
"entity": {
"clientName": "string",
"applicationId": 104,
"instanceName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/instance/dbbrowse/:instanceId' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"path": "string",
"entity": {
"clientName": "string",
"applicationId": 104,
"instanceName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/instance/dbbrowse/:instanceId' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"path": "string",
"entity": {
"clientName": "string",
"applicationId": 104,
"instanceName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/instance/dbbrowse/:instanceId' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"path": "string",
"entity": {
"clientName": "string",
"applicationId": 104,
"instanceName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/instance/dbbrowse/:instanceId' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"path": "string",
"entity": {
"clientName": "string",
"applicationId": 104,
"instanceName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/instance/dbbrowse/:instanceId' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"path": "string",
"entity": {
"clientName": "string",
"applicationId": 104,
"instanceName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/instance/dbbrowse/:instanceId' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"path": "string",
"entity": {
"clientName": "string",
"applicationId": 104,
"instanceName": "string"
}
}'