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": "154",
"doClientSideSortingAndPaging": false,
"session": {
"sessionId": "1711370398-154"
},
"browseResult": {
"queryId": "0",
"dataResultSet": [
{
"displayName": "pguser",
"path": "/TblView/pguser",
"name": "pguser",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201848,
"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": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201848,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "somedb",
"path": "/TblView/somedb",
"name": "somedb",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201851,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "somedb1",
"path": "/TblView/somedb1",
"name": "somedb1",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201851,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "somedb10",
"path": "/TblView/somedb10",
"name": "somedb10",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201852,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "somedb11",
"path": "/TblView/somedb11",
"name": "somedb11",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201853,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "somedb12",
"path": "/TblView/somedb12",
"name": "somedb12",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201854,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "somedb2",
"path": "/TblView/somedb2",
"name": "somedb2",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201855,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "somedb3",
"path": "/TblView/somedb3",
"name": "somedb3",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201856,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "sp27tabletest2",
"path": "/TblView/sp27tabletest2",
"name": "sp27tabletest2",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201857,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "space trial aws",
"path": "/TblView/space trial aws",
"name": "space trial aws",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201858,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "space try",
"path": "/TblView/space try",
"name": "space try",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201859,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "ssl_del",
"path": "/TblView/ssl_del",
"name": "ssl_del",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201860,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "ssl_del2",
"path": "/TblView/ssl_del2",
"name": "ssl_del2",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201861,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "testdb",
"path": "/TblView/testdb",
"name": "testdb",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201862,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "testdb2",
"path": "/TblView/testdb2",
"name": "testdb2",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201863,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
},
{
"displayName": "testdb_aws",
"path": "/TblView/testdb_aws",
"name": "testdb_aws",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218435,
"offset": 1,
"archiveGroupId": 12,
"archiveFileId": 201864,
"advConfig": {
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 140488650
}
},
"browseMetaData": {
"indexing": {}
}
}
}
]
}
},
{
"respType": 5,
"workerId": "154",
"doClientSideSortingAndPaging": false,
"session": {
"sessionId": "1711370398-154"
}
}
]
}
Bad Request
Loading...