Automated notification system for Pull Requests in DingTalk from Azure DevOps

• Notify team members in DingTalk about new Pull Requests in Azure DevOps.
• Automate communication for development teams using Azure DevOps and DingTalk.
• Ensure relevant stakeholders receive updates on code changes and reviews.

Receive Pull Request creation notifications via a webhook. Query MySQL database to map Azure DevOps users to DingTalk accounts. Build a formatted message for DingTalk using the retrieved user data. Send the constructed message to the designated DingTalk group via a webhook.

1. 1
   Import the workflow template into n8n.
2. 2
   Define the webhook path for the ReceiveTfsPullRequestCreatedMessage node.
3. 3
   Create a MySQL table for user mappings as specified in the workflow.
4. 4
   Configure the LoadDingTalkAccountMap node with the appropriate database credentials.
5. 5
   Set the DingTalk webhook URL in the SendDingTalkMessageViaWebHook node.
6. 6
   Test the integration by triggering a Pull Request creation in Azure DevOps.