Counting Data API [Beta]

{CubeHostAddress}/API/v1/load

{CubeHostAddress}: https://cube.footfallcam.com (if you're using on-premise solution, please consult FootfallCam Support on the host address)

1. Authorization : Token value return from API 'GenerateAccessToken' by providing the user name & password

Cube name must be mentioned in payload and its available fields depends on cube selected. Please refer list of cube for cube details

1. query (object) : To define payload for query data
2. measures (list of string) : To define list of metric codes and type of aggregation.
3. timeDimensions (list of object) : Contains an object to define time related parameters
   1. dimension (string) : To specify dimension for applying time related parameters
   2. dateRange (list of string) : To specify start and end date time for data query. Example: "2021-10-01T10:00:00.000", "2021-10-31"
   3. granularity (string) : To define time granularity for data. Example: minute, hour, day, week, month, year
4. order (list of list of string) : To specify ordering of data. Each minor list contains field name to apply ordering and respective type of ordering. Example : ["ThisCubeName.FC01_SUM", "desc"]
5. filters (list of object) : To define filtering of query data.
   1. member (string) : To specify dimension for applying filter.
   2. operator (string) : To define type for filter. Example: equals, notEquals, contains, notContains
   3. values (list of string) : To specify value for filtering data.
6. dimensions (list of string) : To specify dimension to display in result data, similar to 'Select' statement in SQL query.
7. limit (int, optional) : To specify maximum record count of data returned. Default value will be 10000 (if not specified in payload), maximum value is 50000.