Introduction
Use Cube API to get data
|
Description |
Calling this endpoint by providing the type of counting data & query payload object in JSON string to get counting data in JSON format. |
| Endpoint | {CubeHostAddress}/API/v1/load |
| Method | POST |
| Headers |
|
| Body - JSON Example | Follow below Cube Body - JSON example. |
Cubes
users_activity_log
| Description | Store users activity log |
| Cube Name |
users_activity_log
|
| Time granularities |
No time granularities |
| Measures |
No Measures |
| Dimensions |
Following fields can be used for applying filtering and ordering the data.
|
| Body - JSON Example |
{
"queryType" : "multi",
"query" :
{
"measures" : [
],
"dimensions" : [
"users_activity_log.UserName",
"users_activity_log.Name",
"users_activity_log.Email",
"users_activity_log.UserRole",
"users_activity_log.Action",
"users_activity_log.Time"
],
"filters" : [
],
"timeDimensions" : [
{
"dimension": "users_activity_log.Time",
"dateRange": ["2022-09-01", "2022-10-01"]
}
]
,
"order": [
["users_activity_log.Time", "asc"]
]
}
}
|
| Response - JSON Example |
{
...
"data": [
{
"users_activity_log.UserName": "user",
"users_activity_log.Name": "user",
"users_activity_log.Email": "[email protected]",
"users_activity_log.UserRole": "user",
"users_activity_log.Action": "Log In",
"users_activity_log.Time": "2022-09-22T06:39:49.000"
},
{
"users_activity_log.UserName": "admin",
"users_activity_log.Name": "admin",
"users_activity_log.Email": "[email protected]",
"users_activity_log.UserRole": "admin",
"users_activity_log.Action": "Log In",
"users_activity_log.Time": "2022-09-23T01:49:01.000"
},
{
"users_activity_log.UserName": "admin",
"users_activity_log.Name": "admin",
"users_activity_log.Email": "[email protected]",
"users_activity_log.UserRole": "admin",
"users_activity_log.Action": "Log Out",
"users_activity_log.Time": "2022-09-23T03:30:00.000"
},
],
...
}
|