List the databases backed up with a backup job
Select
Customer Managed
This operation returns list of postgres databases that are backed up as part of a backup job.
Fetch the Job start and end time from Job Summary API.
- application/json
Request Body
- opType integer required
mode object required
options object required
timeRange object required
queries object[] required
advOptions object
paths object[] required
entity object required
Responses
- 200
- 400
OK
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
browseResponses object[]
{
"browseResponses": [
{
"respType": 0,
"workerId": "string",
"doClientSideSortingAndPaging": true,
"session": {
"sessionId": "string"
},
"browseResult": {
"queryId": "string",
"dataResultSet": [
{
"displayName": "string",
"path": "string",
"name": "string",
"flags": {
"isPseudo": true,
"directory": true,
"isFake": true,
"snap": true
},
"advancedData": {
"backupJobId": 0,
"offset": 0,
"archiveGroupId": 0,
"archiveFileId": 0,
"advConfig": {
"recallRequest": true,
"browseAdvancedConfigResp": {
"commcellNumber": 0
}
},
"browseMetaData": {
"indexing": {}
}
}
}
]
}
}
]
}
{
"browseResponses": [
{
"respType": 0,
"workerId": "71",
"doClientSideSortingAndPaging": false,
"session": {
"sessionId": "1707055206-71"
},
"browseResult": {
"queryId": "0",
"dataResultSet": [
{
"displayName": "database10",
"path": "/TblView/database10",
"name": "database10",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "database5",
"path": "/TblView/database5",
"name": "database5",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 23,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "database9",
"path": "/TblView/database9",
"name": "database9",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 47,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "database6",
"path": "/TblView/database6",
"name": "database6",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 71,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "database4",
"path": "/TblView/database4",
"name": "database4",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 95,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "database7",
"path": "/TblView/database7",
"name": "database7",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 119,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "database2",
"path": "/TblView/database2",
"name": "database2",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 143,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "database3",
"path": "/TblView/database3",
"name": "database3",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 167,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "database1",
"path": "/TblView/database1",
"name": "database1",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 191,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "db3",
"path": "/TblView/db3",
"name": "db3",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 215,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "postgres",
"path": "/TblView/postgres",
"name": "postgres",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 239,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "db2",
"path": "/TblView/db2",
"name": "db2",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 243,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "db1",
"path": "/TblView/db1",
"name": "db1",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 249,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "gcp10",
"path": "/TblView/gcp10",
"name": "gcp10",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 259,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "database8",
"path": "/TblView/database8",
"name": "database8",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 147704,
"offset": 263,
"archiveGroupId": 12,
"archiveFileId": 124966,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
}
]
}
},
{
"respType": 5,
"workerId": "71",
"doClientSideSortingAndPaging": false,
"session": {
"sessionId": "1707055206-71"
}
}
]
}
Bad Request
POST /dobrowse
Authorization
type: apiKeyname: Authtokenin: header
Request
Request
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/dobrowse' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"opType": 0,
"mode": {
"mode": 3
},
"options": {
"tableViewBrowse": true,
"hideUserHidden": true,
"restoreIndex": true
},
"timeRange": {
"toTime": 0
},
"queries": [
{
"type": 0,
"queryId": "0"
}
],
"advOptions": {
"copyPrecedence": 0
},
"paths": [
{
"path": "string"
}
],
"entity": {
"instanceName": "string",
"appName": "PostgreSQL",
"clientName": "string",
"backupsetName": "DumpBasedBackupSet",
"subclientName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/dobrowse' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"opType": 0,
"mode": {
"mode": 3
},
"options": {
"tableViewBrowse": true,
"hideUserHidden": true,
"restoreIndex": true
},
"timeRange": {
"toTime": 0
},
"queries": [
{
"type": 0,
"queryId": "0"
}
],
"advOptions": {
"copyPrecedence": 0
},
"paths": [
{
"path": "string"
}
],
"entity": {
"instanceName": "string",
"appName": "PostgreSQL",
"clientName": "string",
"backupsetName": "DumpBasedBackupSet",
"subclientName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/dobrowse' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"opType": 0,
"mode": {
"mode": 3
},
"options": {
"tableViewBrowse": true,
"hideUserHidden": true,
"restoreIndex": true
},
"timeRange": {
"toTime": 0
},
"queries": [
{
"type": 0,
"queryId": "0"
}
],
"advOptions": {
"copyPrecedence": 0
},
"paths": [
{
"path": "string"
}
],
"entity": {
"instanceName": "string",
"appName": "PostgreSQL",
"clientName": "string",
"backupsetName": "DumpBasedBackupSet",
"subclientName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/dobrowse' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"opType": 0,
"mode": {
"mode": 3
},
"options": {
"tableViewBrowse": true,
"hideUserHidden": true,
"restoreIndex": true
},
"timeRange": {
"toTime": 0
},
"queries": [
{
"type": 0,
"queryId": "0"
}
],
"advOptions": {
"copyPrecedence": 0
},
"paths": [
{
"path": "string"
}
],
"entity": {
"instanceName": "string",
"appName": "PostgreSQL",
"clientName": "string",
"backupsetName": "DumpBasedBackupSet",
"subclientName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/dobrowse' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"opType": 0,
"mode": {
"mode": 3
},
"options": {
"tableViewBrowse": true,
"hideUserHidden": true,
"restoreIndex": true
},
"timeRange": {
"toTime": 0
},
"queries": [
{
"type": 0,
"queryId": "0"
}
],
"advOptions": {
"copyPrecedence": 0
},
"paths": [
{
"path": "string"
}
],
"entity": {
"instanceName": "string",
"appName": "PostgreSQL",
"clientName": "string",
"backupsetName": "DumpBasedBackupSet",
"subclientName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/dobrowse' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"opType": 0,
"mode": {
"mode": 3
},
"options": {
"tableViewBrowse": true,
"hideUserHidden": true,
"restoreIndex": true
},
"timeRange": {
"toTime": 0
},
"queries": [
{
"type": 0,
"queryId": "0"
}
],
"advOptions": {
"copyPrecedence": 0
},
"paths": [
{
"path": "string"
}
],
"entity": {
"instanceName": "string",
"appName": "PostgreSQL",
"clientName": "string",
"backupsetName": "DumpBasedBackupSet",
"subclientName": "string"
}
}'
curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/dobrowse' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
"opType": 0,
"mode": {
"mode": 3
},
"options": {
"tableViewBrowse": true,
"hideUserHidden": true,
"restoreIndex": true
},
"timeRange": {
"toTime": 0
},
"queries": [
{
"type": 0,
"queryId": "0"
}
],
"advOptions": {
"copyPrecedence": 0
},
"paths": [
{
"path": "string"
}
],
"entity": {
"instanceName": "string",
"appName": "PostgreSQL",
"clientName": "string",
"backupsetName": "DumpBasedBackupSet",
"subclientName": "string"
}
}'