Approvals with one tap in a chat — verified and logged

A decision is confirmed with a tap in botHelp: the scenario verifies the signature and the deadline, updates the status in Microsoft SQL, notifies the author and writes an audit entry.

  • Decisions are made with one tap in botHelp
  • The tap's authenticity and expiry are verified
  • The ticket status is updated in Microsoft SQL
  • Every decision lands in the audit log
Webhook
Set it up for yourselfScriptera

How it works

To get Microsoft SQL notifications in botHelp, you don't need a developer: a ready-made scenario watches events and sends messages for you.

  1. Starts when: 01 Webhook Trigger: Approval Decision
  2. Then: 02 FN: Verify Signature + TTL
  3. Check: Actions
  4. If yes: 04c DB: Update Ticket Status
  5. Then: 04c2 DB: Insert Audit Row
  6. Then: 04c1 DB: Get Ticket Owner
  7. Check: 04c1a IF: Resolved or In Progress
  8. If yes: If Resolved
  9. If yes: 05c1a Telegram: Notify Resolved
  10. Check: Notify Failed?
  11. If yes: Execute a SQL query
  12. If no: If in_progress
  13. If yes: 05c1b Telegram: Notify In Progress
  14. Then: 05c Telegram: Update Confirmation
  15. If no: 04r0 DB: Get Ticket ID
  16. Then: Execute a SQL query1
  17. Then: Text (reject)
  18. If no: 04e DB: Insert Audit Expired
  19. Then: 05e Telegram: Notify Expired
  20. If no: 04i DB: Insert Audit Invalid
  21. Then: 05i Telegram: Alert Invalid

You can launch this Microsoft SQL + botHelp integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios