HikCentral Attendance API Integration

I need an API layer that lets HikCentral Pro push employee attendance records directly into my SQL database. HikCentral will be the data source; the SQL instance will act as the system of record. At the moment I’m not completely sure of the payload format—HikCentral’s documentation mentions something that looks like “POSTSQL”, so I’ll need guidance on the exact structure (it could end up as JSON once we see the sample webhook).

Core requirements
• Accept incoming attendance records from HikCentral over HTTPS.
• Route those records into a chosen table within my SQL environment (SQL Server is currently installed, but I can adjust if you suggest a better flavour).
• Support three actions through separate, secure endpoints or a single endpoint with action flags:
– Insert new attendance records
– Update existing records
– Delete records

Additional notes
– Please include token-based authentication so only HikCentral can hit the API.
– Error handling must be logged both in text files and in a dedicated SQL log table so we can audit failures.
– I’ll need simple setup instructions (connection strings, port to open, expected headers) so my IT team can deploy it on our Windows server beside the HikCentral installation.

Once implemented, I should be able to see new swipes or edits reflected in the SQL table within moments of the event occurring. If you’ve worked with HikCentral or similar access-control platforms before, that experience will be invaluable.