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
- LoadDingTalkAccountMap
- ReceiveTfsPullRequestCreatedMessage
- BuildDingTalkWebHookData
- SendDingTalkMessageViaWebHook
- Error Handler
- Stopanderror 1
- Error Handler for 25d2a3aa
- Error Handler for dc6c235b
- Error Handler
- Error Handler
- Error Handler
- Error Handler
- Error Handler
- Error Handler
23 steps in total.
Similar automations
Alerts & NotificationsSend DingTalk Messages for New Azure DevOps Pull Requests4 stepsAlerts & NotificationsSend Telegram Alerts from a MySQL Customer Package Job8 stepsData Sync & ETLSync Google Sheets Inquiries with MySQL and Send Notifications16 stepsData Sync & ETLSync New MySQL Rows to Google Sheets6 steps