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
mode integerDefault value:
3
options object required
tableViewBrowse booleanDefault value:
true
hideUserHidden booleanDefault value:
true
restoreIndex booleanDefault value:
true
timeRange object required
toTime integerJob end time
queries object[] required
type integerqueryId stringDefault value:
0
advOptions object
copyPrecedence integerCopy precedence to browse
paths object[] required
path stringSet to /TblView
entity object required
instanceName stringName of the instance
appName stringDefault value:
PostgreSQL
clientName stringName of the cloud account
backupsetName stringDefault value:
DumpBasedBackupSet
subclientName stringName of the database group
Responses
- 200
- 400
OK
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
browseResponses object[]
respType integerworkerId stringdoClientSideSortingAndPaging booleansession object
sessionId stringbrowseResult object
queryId stringdataResultSet object[]
displayName stringpath stringname stringflags object
isPseudo booleandirectory booleanisFake booleansnap booleanadvancedData object
backupJobId integeroffset integerarchiveGroupId integerarchiveFileId integeradvConfig object
recallRequest booleanbrowseAdvancedConfigResp object
commcellNumber integerbrowseMetaData object
indexing 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
Loading...