自动发送Vtiger支持工单到Telegram（含状态更新）

• •Telegram Bot Token

{
  "id": "ymg0bc27jttcvbcj",
  "meta": {
    "instanceId": "ea2b41532677d34614d95d13d7d2ccb694657be482144baf71e7140df3b2a853",
    "templateCredsSetupCompleted": true
  },
  "name": "自动发送 Vtiger 支持工单到 Telegram（含状态更新）",
  "tags": [],
  "nodes": [
    {
      "id": "e9ca7d91-ee88-4cc4-9c12-e638fbfb6e66",
      "name": "定时触发器 每 n 分钟执行",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -816,
        -208
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes",
              "minutesInterval": 1
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "81b830bc-e1d3-4d6b-9ef1-e323771b5b5f",
      "name": "VtigerCRM 获取工单",
      "type": "n8n-nodes-vtiger-crm.vtigerNode",
      "position": [
        -592,
        -208
      ],
      "parameters": {
        "query_field": "select * from HelpDesk where ticketstatus='Open' order by id desc limit 1;"
      },
      "credentials": {
        "vtigerApi": {
          "id": "GDVMGSZb4YFb0cMz",
          "name": "SaadeddinTestCRM"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ff439d91-3b2c-4f8e-9c38-aca0f09ce86c",
      "name": "如果有数据返回",
      "type": "n8n-nodes-base.if",
      "position": [
        -368,
        -208
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "1a4121a1-3315-48c6-b319-be947242e291",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.result[0].id }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "77eb4e5c-0048-4469-9815-df5534a7e9dd",
      "name": "发送工单详情到 Telegram",
      "type": "n8n-nodes-base.telegram",
      "position": [
        112,
        -384
      ],
      "webhookId": "78ebd6db-cd6a-4eac-af64-133af5c81e89",
      "parameters": {
        "text": "=New ticket with the following details:\nTicketid: {{ $json.result[0].ticket_no }}\nTitle: {{ $json.result[0].ticket_title }}\nStatus: {{ $json.result[0].ticketstatus }}\nPriority: {{ $json.result[0].ticketpriorities }}\nSeverity: {{ $json.result[0].ticketseverities }}\nCategory: {{ $json.result[0].ticketcategories }}\nDescription: {{ $json.result[0].description }}",
        "chatId": "6885236190",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "credentials": {
        "telegramApi": {
          "id": "lJq9SLWpaYUg6w8w",
          "name": "Telegram account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "70cd5610-46f4-42b0-8008-511a99b9888e",
      "name": "VtigerCRM 更新工单状态",
      "type": "n8n-nodes-vtiger-crm.vtigerNode",
      "position": [
        128,
        -176
      ],
      "parameters": {
        "operation": "update",
        "element_field": "={\n  \"ticketstatus\": \"In Progress\"\n}",
        "webservice_id_field": "={{ $json.result[0].id }}"
      },
      "credentials": {
        "vtigerApi": {
          "id": "GDVMGSZb4YFb0cMz",
          "name": "SaadeddinTestCRM"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "49cff4dc-a89e-4ebe-a1a9-6e9ef6fdd958",
      "name": "无操作，不执行任何操作",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -80,
        -16
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4a8d8029-2a1d-4704-90bd-712adca45596",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        -704
      ],
      "parameters": {
        "width": 688,
        "height": 368,
        "content": "### 🎟️ 自动发送 Vtiger 工单到 Telegram"
      },
      "typeVersion": 1
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "c66999f4-49e3-4e5f-8500-e5a8663d9f88",
  "connections": {
    "VtigerCRM get Tickets": {
      "main": [
        [
          {
            "node": "If there's a data returned",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If there's a data returned": {
      "main": [
        [
          {
            "node": "Send a Ticket detail to Telegram",
            "type": "main",
            "index": 0
          },
          {
            "node": "VtigerCRM Update Ticket Status",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "VtigerCRM Update Ticket Status": {
      "main": [
        []
      ]
    },
    "Schedule Trigger Every n Minutes": {
      "main": [
        [
          {
            "node": "VtigerCRM get Tickets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a Ticket detail to Telegram": {
      "main": [
        []
      ]
    }
  }
}