Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Alerts & Notifications

Alerts & Notifications

Send TFS Pull Request Alerts to DingTalk

When a TFS pull request is created, it looks up reviewer accounts in MySQL and sends a DingTalk webhook message.

What it does

# Mysql Workflow ## Overview Automated workflow: Mysql Workflow. This workflow integrates 6 different services: webhook, stickyNote, httpRequest, mySql, code. It contains 9 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 9 - Node Types: 6 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - LoadDingTalkAccountMap: mySql - ReceiveTfsPullRequestCreatedMessage: webhook - BuildDingTalkWebHookData: code - SendDingTalkMessageViaWebHook: httpRequest - Sticky Note: stickyNote - Error Handler: stopAndError - Stopanderror 1: stopAndError - Error Handler for 25d2a3aa: stopAndError - Error Handler for dc6c235b: stopAndError ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible

The steps

  1. LoadDingTalkAccountMap
  2. ReceiveTfsPullRequestCreatedMessage
  3. BuildDingTalkWebHookData
  4. SendDingTalkMessageViaWebHook
  5. Error Handler
  6. Stopanderror 1
  7. Error Handler for 25d2a3aa
  8. Error Handler for dc6c235b
  9. Error Handler
  10. Error Handler
  11. Error Handler
  12. Error Handler
  13. Error Handler
  14. Error Handler

23 steps in total.

Similar automations