GET api/SQLReporting/TotalCheckInsByVenue?venueID={venueID}&startDate={startDate}&endDate={endDate}

Request Information

URI Parameters

Name	Type	Additional information
venueID	integer	Required
startDate	date	Required
endDate	date	Required

Body Parameters

None.

Response Information

Resource Description

Collection of CheckInOutDTO

Name	Type	Additional information
ID	integer	None.
CustomerVenueID	integer	None.
SystemUserID	integer	None.
CheckInDateTime	date	None.
CheckInLong	string	None.
CheckInLat	string	None.
CheckOutDateTime	date	None.
CheckOutLong	string	None.
CheckOutLat	string	None.
Count	integer	None.

Response Formats

application/json, text/json

Sample:

[
  {
    "ID": 1,
    "CustomerVenueID": 2,
    "SystemUserID": 3,
    "CheckInDateTime": "2025-12-12T16:53:44.6101978+02:00",
    "CheckInLong": "sample string 5",
    "CheckInLat": "sample string 6",
    "CheckOutDateTime": "2025-12-12T16:53:44.6101978+02:00",
    "CheckOutLong": "sample string 8",
    "CheckOutLat": "sample string 9",
    "Count": 10
  },
  {
    "ID": 1,
    "CustomerVenueID": 2,
    "SystemUserID": 3,
    "CheckInDateTime": "2025-12-12T16:53:44.6101978+02:00",
    "CheckInLong": "sample string 5",
    "CheckInLat": "sample string 6",
    "CheckOutDateTime": "2025-12-12T16:53:44.6101978+02:00",
    "CheckOutLong": "sample string 8",
    "CheckOutLat": "sample string 9",
    "Count": 10
  }
]

application/xml, text/xml

Sample:

<ArrayOfCheckInOutDTO xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DataAccess.DTO">
  <CheckInOutDTO>
    <CheckInDateTime>2025-12-12T16:53:44.6101978+02:00</CheckInDateTime>
    <CheckInLat>sample string 6</CheckInLat>
    <CheckInLong>sample string 5</CheckInLong>
    <CheckOutDateTime>2025-12-12T16:53:44.6101978+02:00</CheckOutDateTime>
    <CheckOutLat>sample string 9</CheckOutLat>
    <CheckOutLong>sample string 8</CheckOutLong>
    <Count>10</Count>
    <CustomerVenueID>2</CustomerVenueID>
    <ID>1</ID>
    <SystemUserID>3</SystemUserID>
  </CheckInOutDTO>
  <CheckInOutDTO>
    <CheckInDateTime>2025-12-12T16:53:44.6101978+02:00</CheckInDateTime>
    <CheckInLat>sample string 6</CheckInLat>
    <CheckInLong>sample string 5</CheckInLong>
    <CheckOutDateTime>2025-12-12T16:53:44.6101978+02:00</CheckOutDateTime>
    <CheckOutLat>sample string 9</CheckOutLat>
    <CheckOutLong>sample string 8</CheckOutLong>
    <Count>10</Count>
    <CustomerVenueID>2</CustomerVenueID>
    <ID>1</ID>
    <SystemUserID>3</SystemUserID>
  </CheckInOutDTO>
</ArrayOfCheckInOutDTO>