Get the results of a specific cube instance

GET {{baseUrl}}/api/v2/cubes/:cubeId/instances/:instanceId?offset=0&standardDateFormat=true&standardRawDateFormat=true&limit=1000&fields=Excepteur Lorem

Get the normalized JSON structure result supporting cross-tab of a previously created instance of a specific cube, using the in-memory instance created by a POST /cubes/{cubeId}/instances request. You obtain the authorization token needed to execute the request using POST /auth/login; you obtain the project ID using GET /projects. You pass the authorization token and the project ID in the request header. You specify the cube ID and the cube instance ID in the path of the request. You use the offset and limit query parameters in the request to determine the data displayed on the page; the offset parameter specifies where to start returning results, and the limit parameter specifies how many results to return.

Request Params

KeyDatatypeRequiredDescription
offsetnumberStarting point within the collection of returned results. Used to control paging behavior.
standardDateFormatbooleanStandard date format in ISO8601
standardRawDateFormatbooleanStandard raw date format in ISO8601
limitnumberMaximum number of items returned for a single request. Used to control paging behavior. Use -1 for no limit.
fieldsstringField selector. This allows client to exclude unneeded information from response model. It can be either empty, or a combination of following exclusion rules separated by comma: '-data.metricValues.raw' / '-data.metricValues.formatted' / '-data.metricValues.extras'.

HEADERS

KeyDatatypeRequiredDescription
X-MSTR-AuthTokenstring(Required) Authorization token
X-MSTR-ProjectIDstring(Required) Project ID
PreferstringPrefer--allow client to set preferences. Currently, respond-async allows client to execute in async mode

RESPONSES

status: OK

""