User Activity

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
  1. Authorization : Token value return from API 'GenerateAccessToken' by providing the user name & password
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.

  1. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00"
  2. UserName (string)
  3. Name (string)
  4. Email (string)
  5. UserRole (string)
  6. Action (string)
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"
                },
    ],
 
    ...
 
}
Updated on October 28, 2022