Home
User Guides
Integration
List of Cube v2

List of Cube v2

Contents

site_1d_summary

Description	Store site daily level data
Cube Name	site_1d_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. day, week, month, year
Measures	Available metrics for this cube A01 A02 A03 A04 A05 B01 B03 P01 P23 P25
Dimensions	The following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (number) (Only works for main entrance area) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string) OperateDate (datetime as string) IsWeekDay (number) IsPublicHoliday (number)
Body - JSON Example	{ "query": { "measures": [ "site_1d_summary.A01", "site_1d_summary.A02", "site_1d_summary.A03", "site_1d_summary.A04", "site_1d_summary.A05", "site_1d_summary.B01", "site_1d_summary.B03" ], "dimensions": [ "site_1d_summary.CompanyId", "site_1d_summary.CompanyName", "site_1d_summary.BranchId", "site_1d_summary.BranchName" ], "filters": [ { "member": "site_1d_summary.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "site_1d_summary.IsWeekday", "operator": "equals", "values": [ "true" ] }, ], "timeDimensions": [ { "dimension": "site_1d_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-31T23:59:59.000" ], "granularity": "day" } ], "order": [ [ "site_1d_summary.BranchId", "asc" ], [ "site_1d_summary.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_1d_summary.CompanyId": "12345", "site_1d_summary.CompanyName": "DemoCompany", "site_1d_summary.BranchId": "11111", "site_1d_summary.BranchName": "DemoBranch", "site_1d_summary.Time.day": "2024-01-01T00:00:00.000", "site_1d_summary.A01": 4958, "site_1d_summary.A02": 6060, "site_1d_summary.A03": 241, "site_1d_summary.A04": 376.42, "site_1d_summary.A05": 5839, "site_1d_summary.B01": 0.4592, "site_1d_summary.B03": 0.3213, }, { "site_1d_summary.CompanyId": "12345", "site_1d_summary.CompanyName": "DemoCompany", "site_1d_summary.BranchId": "11111", "site_1d_summary.BranchName": "DemoBranch", "site_1d_summary.Time.day": "2024-01-02T00:00:00.000", "site_1d_summary.A01": 2345, "site_1d_summary.A02": 1234, "site_1d_summary.A03": 132, "site_1d_summary.A04": 256.23, "site_1d_summary.A05": 4531, "site_1d_summary.B01": 0.3410, "site_1d_summary.B03": 0.1253, }, ], ... }

site_1h_summary

Description	Store site hourly level data
Cube Name	site_1h_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube A01 A02 A03 A04 A05 B01
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (number) (Only works for main entrance) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string) OperateDate (datetime as string) IsWeekDay (number) IsPublicHoliday (number)
Body - JSON Example	{ "query": { "measures": [ "site_1h_summary.A01", "site_1h_summary.A02", "site_1h_summary.A03", "site_1h_summary.A04", "site_1h_summary.A05", "site_1h_summary.B01" ], "dimensions": [ "site_1h_summary.CompanyId", "site_1h_summary.CompanyName", "site_1h_summary.BranchId", "site_1h_summary.BranchName" ], "filters": [ { "member": "site_1h_summary.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "site_1h_summary.IsWeekday", "operator": "equals", "values": [ "true" ] }, ], "timeDimensions": [ { "dimension": "site_1h_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-31T23:59:59.000" ], "granularity": "hour" } ], "order": [ [ "site_1h_summary.BranchId", "asc" ], [ "site_1h_summary.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_1h_summary.CompanyId": "12345", "site_1h_summary.CompanyName": "DemoCompany", "site_1h_summary.BranchId": "11111", "site_1h_summary.BranchName": "DemoBranch", "site_1h_summary.Time.hour": "2024-01-01T00:00:00.000", "site_1h_summary.A01": 4958, "site_1h_summary.A02": 6060, "site_1h_summary.A03": 241, "site_1h_summary.A04": 376.42, "site_1h_summary.A05": 5839, "site_1h_summary.B01": 0.4592, "site_1h_summary.B03": 0.3213, }, { "site_1h_summary.CompanyId": "12345", "site_1h_summary.CompanyName": "DemoCompany", "site_1h_summary.BranchId": "11111", "site_1h_summary.BranchName": "DemoBranch", "site_1h_summary.Time.hour": "2024-01-01T01:00:00.000", "site_1h_summary.A01": 2345, "site_1h_summary.A02": 1234, "site_1h_summary.A03": 132, "site_1h_summary.A04": 256.23, "site_1h_summary.A05": 4531, "site_1h_summary.B01": 0.3410, "site_1h_summary.B03": 0.1253, }, ], ... }

site_1m_summary

Description	Store site minute level data
Cube Name	site_1m_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day, week, month, year
Measures	Available metrics for this cube A01 A02 A03
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" Time15Minute (datetime as string). Use this instead of Time to filter for 15 minutes of granularity AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "site_1m_summary.A01", "site_1m_summary.A02", "site_1m_summary.A03" ], "dimensions": [ "site_1m_summary.CompanyId", "site_1m_summary.CompanyName", "site_1m_summary.BranchId", "site_1m_summary.BranchName" ], "filters": [ { "member": "site_1m_summary.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, ], "timeDimensions": [ { "dimension": "site_1m_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-01T23:59:59.000" ], "granularity": "minute" } ], "order": [ [ "site_1m_summary.BranchId", "asc" ], [ "site_1m_summary.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_1m_summary.CompanyId": "12345", "site_1m_summary.CompanyName": "DemoCompany", "site_1m_summary.BranchId": "11111", "site_1m_summary.BranchName": "DemoBranch", "site_1m_summary.Time.minute": "2024-01-01T00:00:00.000", "site_1m_summary.A01": 3, "site_1m_summary.A02": 5, "site_1m_summary.A03": 81 }, { "site_1m_summary.CompanyId": "12345", "site_1m_summary.CompanyName": "DemoCompany", "site_1m_summary.BranchId": "11111", "site_1m_summary.BranchName": "DemoBranch", "site_1m_summary.Time.minute": "2024-01-01T00:01:00.000", "site_1m_summary.A01": 5, "site_1m_summary.A02": 2, "site_1m_summary.A03": 52 }, ], ... }

site_live_summary

Description	Store site level live data
Cube Name	site_live_summary
Measures	Available metrics for this cube A03
Dimensions	Following fields can be used for applying filtering and ordering the data. AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "site_live_summary.A03" ], "dimensions": [ "site_live_summary.CompanyId", "site_live_summary.CompanyName", "site_live_summary.BranchId", "site_live_summary.BranchName" ], "filters": [ { "member": "site_live_summary.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, ], "order": [ [ "site_live_summary.BranchId", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_live_summary.CompanyId": "12345", "site_live_summary.CompanyName": "DemoCompany", "site_live_summary.BranchId": "11111", "site_live_summary.BranchName": "DemoBranch", "site_live_summary.A03": 81 }, { "site_live_summary.CompanyId": "12345", "site_live_summary.CompanyName": "DemoCompany", "site_live_summary.BranchId": "22222", "site_live_summary.BranchName": "DemoBranch2", "site_live_summary.A03": 52 }, ], ... }

site_today_summary

Description	Store today's site level data
Cube Name	site_today_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day
Measures	Available metrics for this cube A03
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" Time1Hour (datetime as string). Use this instead of Time to filter for 1 hour of granularity AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "site_today_summary.A03" ], "dimensions": [ "site_today_summary.CompanyId", "site_today_summary.CompanyName", "site_today_summary.BranchId", "site_today_summary.BranchName" ], "filters": [ { "member": "site_today_summary.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, ], "timeDimensions": [ { "dimension": "site_today_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-01T23:59:59.000" ], "granularity": "minute" } "order": [ [ "site_today_summary.BranchId", "asc" ], [ "site_today_summary.Time", "asc" ], ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_today_summary.CompanyId": "12345", "site_today_summary.CompanyName": "DemoCompany", "site_today_summary.BranchId": "11111", "site_today_summary.BranchName": "DemoBranch", "site_today_summary.Time.minute": "2024-01-01T00:00:00.000", "site_today_summary.A03": 81 }, { "site_today_summary.CompanyId": "12345", "site_today_summary.CompanyName": "DemoCompany", "site_today_summary.BranchId": "11111", "site_today_summary.BranchName": "DemoBranch", "site_today_summary.Time.minute": "2024-01-01T00:01:00.000", "site_today_summary.A03": 52 }, ], ... }

area_1d_summary

Description	Store area daily level data
Cube Name	area_1d_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'day'. day, week, month, year
Measures	Available metrics for this cube A01 A02 A03 A04 A05 B01 B03 P01 P23 P25
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string) OperateDate (datetime as string) IsWeekDay (number) IsPublicHoliday (number)
Body - JSON Example	{ "query": { "measures": [ "area_1d_summary.A01", "area_1d_summary.A02", "area_1d_summary.A03", "area_1d_summary.A04", "area_1d_summary.A05", "area_1d_summary.B01", "area_1d_summary.B03" ], "dimensions": [ "area_1d_summary.CompanyId", "area_1d_summary.CompanyName", "area_1d_summary.BranchId", "area_1d_summary.BranchName", "area_1d_summary.AreaId", "area_1d_summary.AreaName" ], "filters": [ { "member": "area_1d_summary.AreaId", "operator": "equals", "values": [ "33333" ] }, { "member": "area_1d_summary.IsWeekday", "operator": "equals", "values": [ "true" ] }, ], "timeDimensions": [ { "dimension": "area_1d_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-31T23:59:59.000" ], "granularity": "day" } ], "order": [ [ "area_1d_summary.Area", "asc" ], [ "area_1d_summary.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "area_1d_summary.CompanyId": "12345", "area_1d_summary.CompanyName": "DemoCompany", "area_1d_summary.BranchId": "11111", "area_1d_summary.BranchName": "DemoBranch", "area_1d_summary.AreaId": "33333", "area_1d_summary.AreaName": "DemoArea", "area_1d_summary.Time.day": "2024-01-01T00:00:00.000", "area_1d_summary.A01": 4958, "area_1d_summary.A02": 6060, "area_1d_summary.A03": 241, "area_1d_summary.A04": 376.42, "area_1d_summary.A05": 5839, "area_1d_summary.B01": 0.4592, "area_1d_summary.B03": 0.3213 }, { "area_1d_summary.CompanyId": "12345", "area_1d_summary.CompanyName": "DemoCompany", "area_1d_summary.BranchId": "11111", "area_1d_summary.BranchName": "DemoBranch", "area_1d_summary.AreaId": "33333", "area_1d_summary.AreaName": "DemoArea", "area_1d_summary.Time.day": "2024-01-02T00:00:00.000", "area_1d_summary.A01": 2345, "area_1d_summary.A02": 1234, "area_1d_summary.A03": 132, "area_1d_summary.A04": 256.23, "area_1d_summary.A05": 4531, "area_1d_summary.B01": 0.3410, "area_1d_summary.B03": 0.1253 }, ], ... }

area_1h_summary

Description	Store area hourly level data
Cube Name	area_1h_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube A01 A02 A03 A04 A05 B01
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string) OperateDate (datetime as string) IsWeekDay (number) IsPublicHoliday (number)
Body - JSON Example	{ "query": { "measures": [ "area_1h_summary.A01", "area_1h_summary.A02", "area_1h_summary.A03", "area_1h_summary.A04", "area_1h_summary.A05", "area_1h_summary.B01" ], "dimensions": [ "area_1h_summary.CompanyId", "area_1h_summary.CompanyName", "area_1h_summary.BranchId", "area_1h_summary.BranchName", "area_1h_summary.AreaId", "area_1h_summary.AreaName" ], "filters": [ { "member": "area_1h_summary.AreaId", "operator": "equals", "values": [ "33333" ] }, { "member": "area_1h_summary.IsWeekday", "operator": "equals", "values": [ "true" ] } ], "timeDimensions": [ { "dimension": "area_1h_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-31T23:59:59.000" ], "granularity": "hour" } ], "order": [ [ "area_1h_summary.AreaId", "asc" ], [ "area_1h_summary.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "area_1h_summary.CompanyId": "12345", "area_1h_summary.CompanyName": "DemoCompany", "area_1h_summary.BranchId": "11111", "area_1h_summary.BranchName": "DemoBranch", "area_1h_summary.AreaId": "33333", "area_1h_summary.AreaName": "DemoArea", "area_1h_summary.Time.hour": "2024-01-01T00:00:00.000", "area_1h_summary.A01": 4958, "area_1h_summary.A02": 6060, "area_1h_summary.A03": 241, "area_1h_summary.A04": 376.42, "area_1h_summary.A05": 5839, "area_1h_summary.B01": 0.4592 }, { "area_1h_summary.CompanyId": "12345", "area_1h_summary.CompanyName": "DemoCompany", "area_1h_summary.BranchId": "11111", "area_1h_summary.BranchName": "DemoBranch", "area_1h_summary.AreaId": "33333", "area_1h_summary.AreaName": "DemoArea", "area_1h_summary.Time.hour": "2024-01-01T01:00:00.000", "area_1h_summary.A01": 2345, "area_1h_summary.A02": 1234, "area_1h_summary.A03": 132, "area_1h_summary.A04": 256.23, "area_1h_summary.A05": 4531, "area_1h_summary.B01": 0.3410 }, ], ... }

area_1m_summary

Description	Store area minute level data
Cube Name	area_1m_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day, week, month, year
Measures	Available metrics for this cube A01 A02 A03
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "area_1m_summary.A01", "area_1m_summary.A02", "area_1m_summary.A03" ], "dimensions": [ "area_1m_summary.CompanyId", "area_1m_summary.CompanyName", "area_1m_summary.BranchId", "area_1m_summary.BranchName", "area_1m_summary.AreaId", "area_1m_summary.AreaName" ], "filters": [ { "member": "site_1m_summary.AreaId", "operator": "equals", "values": [ "33333" ] }, ], "timeDimensions": [ { "dimension": "area_1m_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-01T23:59:59.000" ], "granularity": "minute" } ], "order": [ [ "area_1m_summary.AreaId", "asc" ], [ "area_1m_summary.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "area_1m_summary.CompanyId": "12345", "area_1m_summary.CompanyName": "DemoCompany", "area_1m_summary.BranchId": "11111", "area_1m_summary.BranchName": "DemoBranch", "area_1m_summary.AreaId": "33333", "area_1m_summary.AreaName": "DemoArea", "area_1m_summary.Time.minute": "2024-01-01T00:00:00.000", "area_1m_summary.A01": 3, "area_1m_summary.A02": 5, "area_1m_summary.A03": 81 }, { "area_1m_summary.CompanyId": "12345", "area_1m_summary.CompanyName": "DemoCompany", "area_1m_summary.BranchId": "11111", "site_1m_summary.BranchName": "DemoBranch", "area_1m_summary.AreaId": "33333", "area_1m_summary.AreaName": "DemoArea", "area_1m_summary.Time.minute": "2024-01-01T00:01:00.000", "area_1m_summary.A01": 5, "area_1m_summary.A02": 2, "area_1m_summary.A03": 52 }, ], ... }

area_live_summary

Description	Store live area level data
Cube Name	area_live_summary
Measures	Available metrics for this cube A03
Dimensions	Following fields can be used for applying filtering and ordering the data. AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "area_live_summary.A03" ], "dimensions": [ "area_live_summary.CompanyId", "area_live_summary.CompanyName", "area_live_summary.BranchId", "area_live_summary.BranchName", "area_live_summary.AreaId", "area_live_summary.AreaName" ], "filters": [ { "member": "area_live_summary.AreaId", "operator": "equals", "values": [ "33333", "44444" ] }, ], "order": [ [ "area_live_summary.AreaId", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "area_live_summary.CompanyId": "12345", "area_live_summary.CompanyName": "DemoCompany", "area_live_summary.BranchId": "11111", "area_live_summary.BranchName": "DemoBranch", "area_live_summary.AreaId": "33333", "area_live_summary.AreaName": "DemoArea", "area_live_summary.A03": 81 }, { "area_live_summary.CompanyId": "12345", "area_live_summary.CompanyName": "DemoCompany", "area_live_summary.BranchId": "11111", "area_live_summary.BranchName": "DemoBranch", "area_live_summary.AreaId": "44444", "area_live_summary.AreaName": "DemoArea2", "area_live_summary.A03": 52 }, ], ... }

area_today_summary

Description	Store today's area level data
Cube Name	area_today_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day
Measures	Available metrics for this cube A03
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" Time1Hour (datetime as string). Use this instead of Time to filter for 1 hour of granularity AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "area_today_summary.A03" ], "dimensions": [ "area_today_summary.CompanyId", "area_today_summary.CompanyName", "area_today_summary.BranchId", "area_today_summary.BranchName" ], "filters": [ { "member": "area_today_summary.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, ], "timeDimensions": [ { "dimension": "area_today_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-01T23:59:59.000" ], "granularity": "minute" } ], "order": [ [ "area_today_summary.BranchId", "asc" ], [ "area_today_summary.Time", "asc" ], ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "area_today_summary.CompanyId": "12345", "area_today_summary.CompanyName": "DemoCompany", "area_today_summary.BranchId": "11111", "area_today_summary.BranchName": "DemoBranch", "area_today_summary.Time.minute": "2024-01-01T00:00:00.000", "area_today_summary.A03": 81 }, { "area_today_summary.CompanyId": "12345", "area_today_summary.CompanyName": "DemoCompany", "area_today_summary.BranchId": "11111", "area_today_summary.BranchName": "DemoBranch", "area_today_summary.Time.minute": "2024-01-01T00:01:00.000", "area_today_summary.A03": 52 }, ], ... }

device_1d_summary

Description	Store device daily level data
Cube Name	device_1d_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'day'. day, week, month, year
Measures	Available metrics for this cube A01 A02 A03 A04 A05
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" Serial (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "device_1d_summary.A01", "device_1d_summary.A02", "device_1d_summary.A03", "device_1d_summary.A04", "device_1d_summary.A05" ], "dimensions": [ "device_1d_summary.CompanyId", "device_1d_summary.CompanyName", "device_1d_summary.BranchId", "device_1d_summary.BranchName", "device_1d_summary.Serial" ], "filters": [ { "member": "device_1d_summary.Serial", "operator": "equals", "values": [ "000000123def789", "000000abc456ghi" ] }, ], "timeDimensions": [ { "dimension": "device_1d_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-31T23:59:59.000" ], "granularity": "day" } ], "order": [ [ "device_1d_summary.Serial", "asc" ], [ "device_1d_summary.Time", "asc" ], ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "device_1d_summary.CompanyId": "12345", "device_1d_summary.CompanyName": "DemoCompany", "device_1d_summary.BranchId": "11111", "device_1d_summary.BranchName": "DemoBranch", "device_1d_summary.Serial": "000123def789", "device_1d_summary.Time.day": "2024-01-01T00:00:00.000", "device_1d_summary.A01": 4958, "device_1d_summary.A02": 6060, "device_1d_summary.A03": 241, "device_1d_summary.A04": 376.42, "device_1d_summary.A05": 5839 }, { "device_1d_summary.CompanyId": "12345", "device_1d_summary.CompanyName": "DemoCompany", "device_1d_summary.BranchId": "11111", "device_1d_summary.BranchName": "DemoBranch", "device_1d_summary.Serial": "000123def789", "device_1d_summary.Time.day": "2024-01-02T00:00:00.000", "device_1d_summary.A01": 3728, "device_1d_summary.A02": 5102, "device_1d_summary.A03": 184, "device_1d_summary.A04": 150.42, "device_1d_summary.A05": 4320 }, ], ... }

device_1h_summary

Description	Store device hourly level data
Cube Name	device_1h_summary
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube A01 A02 A03 A04 A05
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" Serial (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "device_1h_summary.A01", "device_1h_summary.A02", "device_1h_summary.A03", "device_1h_summary.A04", "device_1h_summary.A05" ], "dimensions": [ "device_1h_summary.CompanyId", "device_1h_summary.CompanyName", "device_1h_summary.BranchId", "device_1h_summary.BranchName", "device_1h_summary.Serial" ], "filters": [ { "member": "device_1h_summary.Serial", "operator": "equals", "values": [ "000000123def789", "000000abc456ghi" ] }, ], "timeDimensions": [ { "dimension": "device_1h_summary.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-31T23:59:59.000" ], "granularity": "hour" } ], "order": [ [ "device_1h_summary.Serial", "asc" ], [ "device_1h_summary.Time", "asc" ], ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "device_1h_summary.CompanyId": "12345", "device_1h_summary.CompanyName": "DemoCompany", "device_1h_summary.BranchId": "11111", "device_1h_summary.BranchName": "DemoBranch", "device_1h_summary.Serial": "000123def789", "device_1h_summary.Time.hour": "2024-01-01T00:00:00.000", "device_1h_summary.A01": 4958, "device_1h_summary.A02": 6060, "device_1h_summary.A03": 241, "device_1h_summary.A04": 376.42, "device_1h_summary.A05": 5839 }, { "device_1h_summary.CompanyId": "12345", "device_1h_summary.CompanyName": "DemoCompany", "device_1h_summary.BranchId": "11111", "device_1h_summary.BranchName": "DemoBranch", "device_1h_summary.Serial": "000123def789", "device_1h_summary.Time.hour": "2024-01-01T01:00:00.000", "device_1h_summary.A01": 3728, "device_1h_summary.A02": 5102, "device_1h_summary.A03": 184, "device_1h_summary.A04": 150.42, "device_1h_summary.A05": 4320 }, ], ... }

device_live_summary

Description	Store device level live data
Cube Name	device_live_summary
Measures	Available metrics for this cube A03
Dimensions	Following fields can be used for applying filtering and ordering the data. Serial (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "device_live_summary.A03" ], "dimensions": [ "device_live_summary.CompanyId", "device_live_summary.CompanyName", "device_live_summary.BranchId", "device_live_summary.BranchName", "device_live_summary.Serial" ], "filters": [ { "member": "device_live_summary.Serial", "operator": "equals", "values": [ "000000123def789", "000000abc456ghi" ] }, ], "order": [ [ "device_live_summary.Serial", "asc" ] ], "limit": 10 } }

Updated on November 30, 2024