MySQL Automate

MySQL Automate streamlines notifications for new Azure DevOps Pull Requests by integrating with DingTalk. It automatically maps Azure users to DingTalk contacts, ensuring the right team members receive updates. This workflow enhances communication efficiency and keeps teams informed in real-time, reducing the risk of missed reviews.

7/8/2025
5 nodes
Medium
webhookmediummysqlsticky notedatabasedataintegrationapi
Categories:
Data Processing & AnalysisWebhook TriggeredMedium Workflow
Integrations:
MySQLSticky Note

Target Audience

This workflow is designed for DevOps engineers, project managers, and team leads who want to streamline communication in their development processes. It is particularly beneficial for teams using Azure DevOps and DingTalk for notifications, allowing them to efficiently notify the right stakeholders about new pull requests.

Problem Solved

This workflow addresses the challenge of ensuring that team members are promptly notified about new pull requests in Azure DevOps. By integrating with MySQL for user mapping, it ensures that notifications are sent to the correct DingTalk users, minimizing the risk of missed communications and enhancing collaboration within the team.

Workflow Steps

  • Receive Pull Request Notification: The workflow begins when a new pull request is created in Azure DevOps, triggering the ReceiveTfsPullRequestCreatedMessage webhook.
    2. Load User Mapping: The LoadDingTalkAccountMap node queries the MySQL database to retrieve the mapping between Azure DevOps users and their corresponding DingTalk accounts.
    3. Build Notification Message: The BuildDingTalkWebHookData node processes the pull request information and constructs a notification message. It replaces Azure user names with their DingTalk equivalents and includes mentions for reviewers.
    4. Send Notification: The SendDingTalkMessageViaWebHook node sends the constructed message to the specified DingTalk group chat using the provided webhook URL.
    5. Visualize Workflow: The Sticky Note node provides an overview of the workflow, including setup instructions and customization options.

    • Customization Guide

  • Webhook Configuration: Update the path value in the ReceiveTfsPullRequestCreatedMessage node to match your Azure DevOps ServiceHook settings.
    2. Database Setup: Create a MySQL table according to the specified schema to store user mappings, ensuring accurate notifications.
    3. Message Customization: Modify the BuildDingTalkWebHookData node's JavaScript code to change the content of the DingTalk messages as needed for your team's communication style.
    4. Webhook URL Update: Replace the access token in the SendDingTalkMessageViaWebHook node with your DingTalk group chat robot webhook URL to enable message sending.
    5. Testing: Conduct tests by sending sample pull request notifications from Azure DevOps to verify the workflow's functionality.