MicroStrategy REST API API Documentation
Get an single cube cache info
GET {{baseUrl}}/api/monitors/caches/cubes/:id
Get an single cube cache info.You obtain the authorization token needed to execute the request using POST /auth/login; you pass the authorization token in the request header. You specify cube cache id in the path of the request, and you can get cube cache id from API GET /monitors/caches/cubes, then you can obtain the cube cache detail information
Body
PARAM
| Key | Datatype | Required | Description |
fields
|
null | Comma-separated, top-level field whitelist that allows the client to selectively retrieve part of the response model. If specified, extra filtering is applied, and for top-level object (if root model is an array, each array element), only the listed fields are kept in the response. For example, "id,elements" keeps only the "id" field and whole "elements" array field, omitting all other fields in the top-level response model. |
HEADERS
| Key | Datatype | Required | Description |
X-MSTR-AuthToken
|
string | (Required) Authorization token |
RESPONSES
status OK
| {
"id": "QUVEMEQ2ODgxMUU3NzIxMTFDRDkwMDgwRUZFNThCRkM6QjdDQTkyRjA0QjlGQUU4RDk0MUMzRTlCN0UwQ0Q3NTQ6ZW52LTI3NjY4NmxhaW91c2Ux",
"projectId": "B7CA92F04B9FAE8D941C3E9B7E0CD754",
"source": {
"name": "2013 Webcast Metrics#6_20140306142013",
"id": "ADA1BBA611E772111D000080EFE58BFC",
"type": "cube"
},
"state": {
"active": true,
"dirty": false,
"infoDirty": false,
"persisted": true,
"processing": false,
"loadedState": "loaded"
},
"lastUpdateTime": "2017-07-26T14:49:53.000+0000",
"lastHitTime": "2022-03-02T21:08:44.000+0000",
"hitCount": 0,
"size": 1484800,
"creatorName": "Administrator",
"creatorId": "54F3D26011D2896560009A8E67019608",
"lastUpdateJob": 279671,
"openViewCount": 1,
"creationTime": "2014-05-22T16:20:01.000+0000",
"historicHitCount": 24,
"databaseConnections": [],
"fileName": "/opt/mstr/MicroStrategy/IntelligenceServer/Cube/cloud_10s/Server_env-276686laiouse1_PB7CA92F04B9FAE8D941C3E9B7E0CD754/AED0D68811E772111CD90080EFE58BFC.cube",
"dataLanguages": [],
"rowCount": 0,
"columnCount": 0,
"cubeType": "in_memory",
"jobExecutionStatistics": {
"startTime": "2014-05-22T16:20:00.000+0000",
"finishTime": "2014-05-22T16:20:01.000+0000",
"sqlDuration": 306,
"analyticalEngineDuration": 0,
"otherDuration": 307,
"tempTablesCount": 0,
"totalPassedCount": 2,
"sqlPassesCount": 2,
"analyticalEnginePassesCount": 0,
"errorMessage": "",
"totalElapsedDuration": 307,
"sqlExecutionDuration": 0,
"accessedTables": [],
"queryPasseInfos": [
{
"rowTotalNumber": 70,
"columnTotalNumber": 27,
"startTime": "2014-05-22T16:20:00.000+0000",
"finishTime": "2014-05-22T16:20:01.000+0000",
"duration": 300,
"sqlStatement": "",
"dataFetchin Curl curl -X GET 'baseUrl/api/monitors/caches/cubes/:id?fields=' -H 'X-MSTR-AuthToken: authToken' ENDPOINTS |