F100327-04
API Documentation
13
3.2 Pull Data from SQL in Central Database
Instead of using API, users may choose to extract the footfall data directly from FootfallCam Central Database. This involves establishing a remote connection
directly to the database to extract the data from the relevant table to the business intelligence system.
3.2.1 How to Get Branch List
Title
Get Branch List
Description: SQL Function to retrieve branch list.
Branch data include Branch Id, Name, Region, City, Country, StoreType, Latitude, Longitude and Floor Size
Function Name
GetBranchList
Method
SQL
Data Params
Username [nvarchar]
Password [nvarchar]
Success Response
Sample Call
SELECT
*
FROM
GetBranchList(
'username'
,
'password'
);
Notes
None
3.2.2 How to Get Counter List
Title
Get Counter by Branch
Description: SQL Function to retrieve counters filtered by branch.
Counter data include Counter Id, Name, IP, Port, Serial
Function Name
GetCounterByBranch
Method
SQL
Data Params
Username [nvarchar]
Password [nvarchar]
BranchId [bigint]
Success Response
Sample Call
SELECT
*
FROM
GetCounterByBranch(
'username'
,
'password'
, 37);
