← Mikaeel Faraz

Production alerts to support tickets in real time, exactly once

Role
Specified it, verified it against live data, and rolled it out
Users
Support agents
Period
Jul to Sep 2026
Stack
Netlify Functions, HMAC-SHA256, Zoho Desk REST API, Supabase
Status
In production

Production alerts used to reach the support desk through a spreadsheet that was polled. I replaced that with a signed webhook that creates the ticket directly, on the right account, and only once.

How it works

Each request is signed and checked before anything happens. Each alert is claimed in a table that acts as a lock, so if the same event arrives twice the second copy updates the ticket instead of opening another. The account is matched exactly, and a rule-based classifier with tests sorts the ticket.

Decisions

  • Check the helpdesk API against live data before designing, then write a detailed spec and review the implementation against it.
  • A rule-based classifier rather than a language model: predictable, testable and free per ticket.

Before and after

BeforeAfter
LatencyPollingReal time
Duplicate tickets on retryPossiblePrevented

This describes internal work at qlub. Names, internal rules and business data are left out on purpose. If you want the detail behind any of it, email mikaeel2013@gmail.com and I will walk you through it.