List all dataset/tables backed up
This operation fetches the list of dataset/tables that are backedup.
- application/json
Request Body
- opType integer required
queries object[]
type integerqueryId stringdataParam object
sortParam object
ascending booleansortBy integer[]paging object
firstNode integerpageSize integerskipNode integeraggrParam object
field integeraggrType integerpaths object[]
path stringBigQuery Project ID
options object
restoreIndex booleanskipIndexRestore booleanhideUserHidden booleanshowDeletedFiles booleanadvOptions object
stubAsData booleantimeRange object
fromTime integerStart time from when to browse Content
toTime integerEnd time from when to browse content
entity object
applicationId integer requiredDefault value:
134backupsetId integerclientId integer requiredClient ID
instanceId integer requiredInstance ID
websession object
subscriptionId integerrequestId string
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
browseResponses object[]
respType integerworkerId stringdoClientSideSortingAndPaging booleansession object
sessionId stringbrowseResult object
hasMoreData booleanuseLazyPaginationMode booleanqueryId stringdataResultSet object[]
displayName stringdisplayPath stringpath stringsize integermodificationTime integername stringflags object
isPseudo booleandirectory booleanisFake booleansnap booleanadvancedData object
backupJobId integerjobFlags integerreferenceTime integerjobType integeroffset integerarchiveGroupId integerobjectGuid stringbackupTime integerarchiveFileId integersubclient object
_type_ integer_SubclType_ integerapplicationId integersourceCommServer object
_type_ integercommCellId integeradvConfig object
recallByPathRequest booleandoCrossComponentBrowseNarrowing booleanrecallRequest booleanbrowseAdvancedConfigResp object
commcellNumber integerbrowseMetaData object
indexing object
folderSize integerbigQueryMetadata object
datasetMetadataJson stringdmStubData object
guid stringaggrResultSet object[]
result integergroupbyValue stringcount integer
{
"browseResponses": [
{
"respType": 0,
"workerId": "string",
"doClientSideSortingAndPaging": true,
"session": {
"sessionId": "string"
},
"browseResult": {
"hasMoreData": true,
"useLazyPaginationMode": true,
"queryId": "string",
"dataResultSet": [
{
"displayName": "string",
"displayPath": "string",
"path": "string",
"size": 0,
"modificationTime": 0,
"name": "string",
"flags": {
"isPseudo": true,
"directory": true,
"isFake": true,
"snap": true
},
"advancedData": {
"backupJobId": 0,
"jobFlags": 0,
"referenceTime": 0,
"jobType": 0,
"offset": 0,
"archiveGroupId": 0,
"objectGuid": "string",
"backupTime": 0,
"archiveFileId": 0,
"subclient": {
"_type_": 0,
"_SubclType_": 0,
"applicationId": 0
},
"sourceCommServer": {
"_type_": 0,
"commCellId": 0
},
"advConfig": {
"recallByPathRequest": true,
"doCrossComponentBrowseNarrowing": true,
"recallRequest": true,
"browseAdvancedConfigResp": {
"commcellNumber": 0
}
},
"browseMetaData": {
"indexing": {
"folderSize": 0
},
"bigQueryMetadata": {
"datasetMetadataJson": "string"
},
"dmStubData": {
"guid": "string"
}
}
}
}
],
"aggrResultSet": [
{
"result": 0,
"groupbyValue": "string",
"count": 0
}
]
}
}
]
}
{
"browseResponses": [
{
"respType": 0,
"workerId": "190",
"doClientSideSortingAndPaging": false,
"session": {
"sessionId": "1771474719-190"
},
"browseResult": {
"hasMoreData": false,
"useLazyPaginationMode": false,
"queryId": "0",
"dataResultSet": [
{
"displayName": "every_second2",
"displayPath": "/sqltestbigquery-d/every_second2",
"path": "/sqltestbigquery-d/every_second2",
"size": 289755,
"modificationTime": 0,
"name": "every_second2",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 218069,
"jobFlags": 0,
"referenceTime": 1771409126,
"jobType": 1,
"offset": 11974,
"archiveGroupId": 765,
"objectGuid": "5028dc9287914f983da1fe2b37777777",
"backupTime": 1771409126,
"archiveFileId": 870823,
"subclient": {
"_type_": 7,
"_SubclType_": 0,
"applicationId": 3349
},
"sourceCommServer": {
"_type_": 1,
"commCellId": 2
},
"advConfig": {
"recallByPathRequest": false,
"doCrossComponentBrowseNarrowing": true,
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 107342106
}
},
"browseMetaData": {
"indexing": {
"folderSize": 289755
},
"bigQueryMetadata": {
"datasetMetadataJson": "{\n \"kind\": \"bigquery#dataset\",\n \"etag\": \"qUx79odcDNdtfYTmcVbnOA==\",\n \"id\": \"sqltestbigquery-d:every_second2\",\n \"selfLink\": \"https://bigquery.googleapis.com/bigquery/v2/projects/sqltestbigquery-d/datasets/every_second2\",\n \"datasetReference\": {\n \"datasetId\": \"every_second2\",\n \"projectId\": \"sqltestbigquery-d\"\n },\n \"access\": [\n {\n \"role\": \"WRITER\",\n \"specialGroup\": \"projectWriters\"\n },\n {\n \"role\": \"OWNER\",\n \"specialGroup\": \"projectOwners\"\n },\n {\n \"role\": \"OWNER\",\n \"userByEmail\": \"ex@comm.com\"\n },\n {\n \"role\": \"READER\",\n \"specialGroup\": \"projectReaders\"\n }\n ],\n \"creationTime\": \"1770814554423\",\n \"lastModifiedTime\": \"1770814554423\",\n \"location\": \"us-central1\",\n \"type\": \"DEFAULT\",\n \"maxTimeTravelHours\": \"168\"\n}\n"
},
"dmStubData": {
"guid": "9bd3104953f0ba86b153939d54268467"
}
}
}
},
{
"displayName": "yale",
"displayPath": "/sqltestbigquery-d/yale",
"path": "/sqltestbigquery-d/yale",
"size": 57586,
"modificationTime": 0,
"name": "yale",
"flags": {
"isPseudo": false,
"directory": true,
"isFake": false,
"snap": false
},
"advancedData": {
"backupJobId": 206832,
"jobFlags": 0,
"referenceTime": 1770489007,
"jobType": 1,
"offset": 14658,
"archiveGroupId": 765,
"objectGuid": "81f256b123bc7fb8335811b4dc267d71",
"backupTime": 1770489007,
"archiveFileId": 856473,
"subclient": {
"_type_": 7,
"_SubclType_": 0,
"applicationId": 2946
},
"sourceCommServer": {
"_type_": 1,
"commCellId": 2
},
"advConfig": {
"recallByPathRequest": false,
"doCrossComponentBrowseNarrowing": true,
"recallRequest": false,
"browseAdvancedConfigResp": {
"commcellNumber": 107342106
}
},
"browseMetaData": {
"indexing": {
"folderSize": 57586
},
"bigQueryMetadata": {
"datasetMetadataJson": "{\n \"kind\": \"bigquery#dataset\",\n \"etag\": \"lZZqpoYeyJjMB5l0UfidCQ==\",\n \"id\": \"sqltestbigquery-d:yale\",\n \"selfLink\": \"https://bigquery.googleapis.com/bigquery/v2/projects/sqltestbigquery-d/datasets/yale\",\n \"datasetReference\": {\n \"datasetId\": \"yale\",\n \"projectId\": \"sqltestbigquery-d\"\n },\n \"access\": [\n {\n \"role\": \"WRITER\",\n \"specialGroup\": \"projectWriters\"\n },\n {\n \"role\": \"OWNER\",\n \"specialGroup\": \"projectOwners\"\n },\n {\n \"role\": \"OWNER\",\n \"userByEmail\": \"sc@comm.com\"\n },\n {\n \"role\": \"READER\",\n \"specialGroup\": \"projectReaders\"\n }\n ],\n \"creationTime\": \"1765797404264\",\n \"lastModifiedTime\": \"1765797404264\",\n \"location\": \"US\",\n \"type\": \"DEFAULT\",\n \"isCaseInsensitive\": false,\n \"maxTimeTravelHours\": \"168\"\n}\n"
},
"dmStubData": {
"guid": "bb1d5a0c532e08416078a049e8888888"
}
}
}
}
]
}
},
{
"respType": 0,
"workerId": "190",
"doClientSideSortingAndPaging": false,
"session": {
"sessionId": "1771474719-190"
},
"browseResult": {
"hasMoreData": false,
"useLazyPaginationMode": false,
"queryId": "1",
"aggrResultSet": [
{
"result": 2,
"groupbyValue": "",
"count": 2
}
]
}
},
{
"respType": 5,
"workerId": "190",
"doClientSideSortingAndPaging": false,
"session": {
"sessionId": "1771474719-190"
}
}
]
}
Loading...