F100327-04
API Documentation
14
3.2.3 How to Get Hourly Counting Data by Branch
Title
Get branch hourly counting data
Description: SQL Function to retrieve counting filtered by counter.
Counting data include Counter (in hourly interval), ValueDateTime, ValueIn, ValueOut, OutsideTraffic, Day, CounterId
Function Name
GetCounterCounting
Method
SQL
Data Params
Username [nvarchar]
Password [nvarchar]
BranchCode [bigint]
/ “-1” for whole branch in company
StartDate [datetime]
EndDate [datetime]
Success Response
Sample Call
SELECT
*
FROM
GetBranchHourly(
'username'
,
'password'
,
-1,
'20150320'
,
'20150321'
);
Notes
-1 refer to the all branches in the company
3.2.3 How to Get Daily Counting Data by Branch
Title
Get Branch Daily Counting Data
Description: SQL Function to retrieve daily summary filtered by counter
Counting data include Date (POSIX Timestamp), CameraName, ValueIn, ValueOut, OutsideTraffic, TurnInRate,
LessThanFifteen, LessThanThiry, OverThirty, NewCustomer, ReturnInWeek, ReturnInMonth, AggreggationStatus.
VerificationStatus
Function Name
GetBranchDailySummary
Method
SQL
Data Params
Username [nvarchar]
Password [nvarchar]
Branchcode [bigint]
“-1” for whole branch in company
StartDate [datetime]
EndDate [datetime]
Success Response
Sample Call
SELECT
*
FROM
GetBranchDailySummary(
'username'
,
'password'
, 410,
‘20140120’
,
‘20140121’
);
Notes
-1 refer to the all branches in the company
