Workflow: Mysql Workflow
Integrations: code, httpRequest, mySql, stickyNote, webhook

{"meta": {"instanceId": "workflow-dba4a167", "versionId": "1.0.0", "createdAt": "2025-09-29T07:08:00.194854", "updatedAt": "2025-09-29T07:08:00.194866", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "nodes": [{"id": "44eb446d-3775-4fe0-8f76-67f46913531e", "name": "LoadDingTalkAccountMap", "type": "n8n-nodes-base.mySql", "position": [-600, 720], "parameters": {"table": {"__rl": true, "mode": "list", "value": "tfs_dingtalk_account_map", "cachedResultName": "tfs_dingtalk_account_map"}, "options": {}, "operation": "select", "returnAll": true}, "credentials": {"mySql": {"id": "{{ $credentials.mySql.id }}", "name": "MySQL account"}}, "typeVersion": 2.2, "notes": "This mySql node performs automated tasks as part of the workflow."}, {"id": "25d2a3aa-af18-4ff2-af6c-c2bf6618a511", "name": "ReceiveTfsPullRequestCreatedMessage", "type": "n8n-nodes-base.webhook", "position": [-860, 720], "webhookId": "05a0f565-7a1e-44f2-956d-1c68982ce314", "parameters": {"path": "pr-notify-template", "options": {}, "httpMethod": "POST"}, "typeVersion": 1, "notes": "This webhook node performs automated tasks as part of the workflow."}, {"id": "70d69753-9408-4a99-85a4-9dc4486fc460", "name": "BuildDingTalkWebHookData", "type": "n8n-nodes-base.code", "position": [-340, 720], "parameters": {"jsCode": "// Code here will run only once, no matter how many input items there are.\n// More info and help: {{ $env.WEBHOOK_URL }}\n\nconsole.log(\"items:\");\nconsole.log(items);\n\nvar mapUserMobile = function (tfsAccount) {\n  for(var i = 0; i < items.length; i++) {\n    var map = items[i].json;\n    if(tfsAccount.lastIndexOf(map.TfsAccount) != -1) {\n      return map.DingTalkMobile;\n    }\n  }\n\n  return null;\n}\nvar mapUserName = function (tfsAccount) {\n  for(var i = 0; i < items.length; i++) {\n    var map = items[i].json;\n    if(tfsAccount.lastIndexOf(map.TfsAccount) != -1) {\n      return map.UserName;\n    }\n  }\n\n  return null;\n}\n\nvar tfsMessage = $node[\"ReceiveTfsPullRequestCreatedMessage\"].json.body;\nconsole.log(\"TFS Message:\");\nconsole.log(tfsMessage);\n\nvar output = {};\nvar atMobiles = [];\nvar isAtAll = false;\nvar atUsers = [];\nvar messageText = tfsMessage.message.markdown;\nvar prCreatorTfsDomainName = tfsMessage.resource.createdBy.uniqueName;\nvar prCreatorTfsDisplayName = tfsMessage.resource.createdBy.displayName;\nvar prCreatorDingTalkName = mapUserName(prCreatorTfsDomainName);\n\nif (prCreatorDingTalkName !== null) {\n  messageText = messageText.replace(prCreatorTfsDisplayName, prCreatorDingTalkName);\n}\n\nfor (reviewer of tfsMessage.resource.reviewers) {\n  console.log(reviewer.uniqueName);\n  if(reviewer.uniqueName.lastIndexOf(\"\u56e2\u961f\") != -1) {\n    //\u5f53@\u6240\u6709\u4eba\u65f6\uff0c\u6d88\u606f\u5185\u5bb9\u4e2d\u7684\u624b\u673a\u53f7\u5c31\u4e0d\u4f1a\u88ab\u8f6c\u4e49\u6210\u7528\u6237\u540d\u4e86\uff0c\u6682\u65f6\u4e0d\u542f\u7528\u8be5\u529f\u80fd\n    isAtAll = true;\n    continue;\n  }\n\n  var mobile = mapUserMobile(reviewer.uniqueName);\n\n  if(mobile !== null) {\n    atMobiles.push(mobile);\n  }\n\n  var userName = mapUserName(reviewer.uniqueName);\n\n  if(userName !== null) {\n    atUsers.push(userName);\n  }\n}\n\nif(isAtAll) {\n  atUsers.unshift(\"\u6240\u6709\u4eba\");\n  atMobiles = [];\n} else {\n  atUsers = atMobiles;\n}\n\nif (atUsers.length > 0) {\n  messageText = messageText + \"<br />\u8bf7 @\" + atUsers.join(\" @\") + \" \u8bc4\u5ba1\";\n}\n\noutput.isAtAll = isAtAll;\noutput.text = messageText;\noutput.atMobiles = atMobiles.join(\", \");\n\nconsole.log('Done:');\nconsole.log(output);\n\nreturn [{json: output}];"}, "typeVersion": 2, "notes": "This code node performs automated tasks as part of the workflow."}, {"id": "dc6c235b-c1ac-4195-a404-e79c8ad1c8ef", "name": "SendDingTalkMessageViaWebHook", "type": "n8n-nodes-base.httpRequest", "position": [-80, 720], "parameters": {"url": "{{ $env.API_BASE_URL }}", "options": {}, "requestMethod": "POST", "jsonParameters": true, "bodyParametersJson": "={\n\t\"at\":\n\t{\n\t\t\"atMobiles\": [{{$json[\"atMobiles\"]}}],\n\t\t\"isAtAll\": \"{{$json[\"isAtAll\"]}}\"\n\t},\n\t\"msgtype\": \"markdown\",\n\t\"markdown\":\n\t{\n\t\t\"title\": \"New PR Notify\",\n\t\t\"text\": \"{{$json[\"text\"]}}\"\n\t}\n}"}, "typeVersion": 1, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "3476a787-387b-43e2-8646-6a682656f231", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-1449, 560], "parameters": {"width": 484, "height": 540, "content": "## Send DingTalk message on new Azure DevOps Pull Request\nThis template automates sending a DingTalk message on new Azure Dev Ops Pull Request Created Events. It uses a MySQL database to store mappings between Azure users and DingTalk users; so the right users get notified. \n\n### Set up instructions\n1. Define the path value of ReceiveTfsPullRequestCreatedMessage Webhook node of your own, copy the webhook url to create a Azure DevOps ServiceHook that call webhook with Pull Request Created event.\n2. In order to configure the LoadDingTalkAccountMap node, you need to create a MySQL table as below:\n|Name|Type|Length|Key|\n|-|-|-|-|\n|TfsAccount|varchar|255|\n|UserName|varchar|255|\n|DingTalkMobile|varchar|255|\n3. You can customize the Ding Talk message content by editing the BuildDingTalkWebHookData node.\n4. Define the URL of SendDingTalkMessageViaWebHook Http Request node as your Ding Talk group chat robot webhook URL.\n5. Send test of production message from Azure DevOps to test.\n\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}], "pinData": {}, "connections": {"25d2a3aa-af18-4ff2-af6c-c2bf6618a511": {"main": [[{"node": "error-handler-25d2a3aa-af18-4ff2-af6c-c2bf6618a511", "type": "main", "index": 0}], [{"node": "error-handler-25d2a3aa-af18-4ff2-af6c-c2bf6618a511-66faa0d5", "type": "main", "index": 0}], [{"node": "error-handler-25d2a3aa-af18-4ff2-af6c-c2bf6618a511-d9fbabe1", "type": "main", "index": 0}], [{"node": "error-handler-25d2a3aa-af18-4ff2-af6c-c2bf6618a511-efea7454", "type": "main", "index": 0}], [{"node": "error-handler-25d2a3aa-af18-4ff2-af6c-c2bf6618a511-917326ca", "type": "main", "index": 0}], [{"node": "error-handler-25d2a3aa-af18-4ff2-af6c-c2bf6618a511-4d0a1634", "type": "main", "index": 0}], [{"node": "error-handler-25d2a3aa-af18-4ff2-af6c-c2bf6618a511-b728740b", "type": "main", "index": 0}], [{"node": "error-handler-25d2a3aa-af18-4ff2-af6c-c2bf6618a511-2f16f399", "type": "main", "index": 0}], [{"node": "error-handler-25d2a3aa-af18-4ff2-af6c-c2bf6618a511-7933e973", "type": "main", "index": 0}]]}, "dc6c235b-c1ac-4195-a404-e79c8ad1c8ef": {"main": [[{"node": "error-handler-dc6c235b-c1ac-4195-a404-e79c8ad1c8ef", "type": "main", "index": 0}], [{"node": "error-handler-dc6c235b-c1ac-4195-a404-e79c8ad1c8ef-c4ad8ddf", "type": "main", "index": 0}], [{"node": "error-handler-dc6c235b-c1ac-4195-a404-e79c8ad1c8ef-2893aee0", "type": "main", "index": 0}], [{"node": "error-handler-dc6c235b-c1ac-4195-a404-e79c8ad1c8ef-3087a821", "type": "main", "index": 0}], [{"node": "error-handler-dc6c235b-c1ac-4195-a404-e79c8ad1c8ef-63232bd9", "type": "main", "index": 0}], [{"node": "error-handler-dc6c235b-c1ac-4195-a404-e79c8ad1c8ef-5b5d6814", "type": "main", "index": 0}], [{"node": "error-handler-dc6c235b-c1ac-4195-a404-e79c8ad1c8ef-3a9cb6a2", "type": "main", "index": 0}], [{"node": "error-handler-dc6c235b-c1ac-4195-a404-e79c8ad1c8ef-f512d955", "type": "main", "index": 0}], [{"node": "error-handler-dc6c235b-c1ac-4195-a404-e79c8ad1c8ef-50c6bb60", "type": "main", "index": 0}]]}}, "name": "Mysql Workflow", "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "description": "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.", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "notes": "Excellent quality workflow: Mysql Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}