Open Ticket Configuration in Automate

Overview

This workflow looks up configurations attached to a ConnectWise ticket and opens the first managed configuration in Automate. It filters out unmanaged configurations and provides a direct link to open the configuration in your Automate server.

Setup Instructions

Grab the webhook URL in n8n by double-clicking the first node.
In ConnectWise, navigate to Setup Tables > Links and choose + on the menubar. Under Link Name put Open in Automate. Set Table Reference to Service and change the Link Definition to the webhook URL and add https://n8n.example.com/webhook/abcd-UUID-here?ticketid=[srnumber]. See ConnectWise University for more info.
Configure the Filter node in n8n to only return managed configurations that can be opened in Automate by adding appropriate filter conditions.
Modify the Redirect to Automate node to include your Automate server URL/domain.

The Workflow

{
  "nodes": [
    {
      "parameters": {
        "path": "7c63c8c5-d6ae-418f-87d0-4fe8384c3590_automate_open_computer",
        "responseMode": "responseNode",
        "options": {}
      },
      "type": "n8n-nodes-base.webhook",
      "typeVersion": 2.1,
      "position": [
        0,
        -208
      ],
      "id": "67ada8f0-66c2-490e-a3d9-f7643bf1834d",
      "name": "Webhook",
      "webhookId": "7c63c8c5-d6ae-418f-1234-1234567890"
    },
    {
      "parameters": {
        "resource": "ticket",
        "operation": "get",
        "id": "={{ $json.query.ticketid }}"
      },
      "type": "@mspcopilot/n8n-nodes-connectwise.connectWisePsa",
      "typeVersion": 1,
      "position": [
        224,
        -208
      ],
      "id": "9ee9627b-4dbd-47ad-a5e8-2a948cdc00f7",
      "name": "Get a ticket",
      "credentials": {
        "connectWisePsaApi": {
          "id": "YOUR_CREDENTIAL_ID",
          "name": "API account"
        }
      }
    },
    {
      "parameters": {
        "resource": "custom",
        "endpoint": "={{ $json._info.configurations_href }}"
      },
      "type": "@mspcopilot/n8n-nodes-connectwise.connectWisePsa",
      "typeVersion": 1,
      "position": [
        448,
        -208
      ],
      "id": "72c597a0-6edf-4d7d-9463-9c8a5a28c4e0",
      "name": "Get Configurations on Ticket",
      "credentials": {
        "connectWisePsaApi": {
          "id": "YOUR_CREDENTIAL_ID",
          "name": "API account"
        }
      }
    },
    {
      "parameters": {
        "resource": "custom",
        "endpoint": "={{ $json._info.configuration_href }}"
      },
      "type": "@mspcopilot/n8n-nodes-connectwise.connectWisePsa",
      "typeVersion": 1,
      "position": [
        672,
        -208
      ],
      "id": "b66bf023-729a-4d59-826f-9734821fbfec",
      "name": "Lookup Each Configuration",
      "credentials": {
        "connectWisePsaApi": {
          "id": "YOUR_CREDENTIAL_ID",
          "name": "API account"
        }
      }
    },
    {
      "parameters": {
        "conditions": {
          "options": {
            "caseSensitive": true,
            "leftValue": "",
            "typeValidation": "strict",
            "version": 2
          },
          "conditions": [
            {
              "id": "02425d71-ea0d-4825-8bc3-d0d901b369ea",
              "leftValue": "={{ $json.type.name }}",
              "rightValue": "Managed Server",
              "operator": {
                "type": "string",
                "operation": "contains"
              }
            },
            {
              "id": "9ada5e63-0a9a-42b8-b5c9-7062aebeaaa9",
              "leftValue": "={{ $json.type.name }}",
              "rightValue": "Managed Workstation",
              "operator": {
                "type": "string",
                "operation": "contains"
              }
            }
          ],
          "combinator": "or"
        },
        "options": {}
      },
      "type": "n8n-nodes-base.filter",
      "typeVersion": 2.2,
      "position": [
        896,
        -208
      ],
      "id": "391b20df-57ae-48ff-a9e9-1986173d01c4",
      "name": "Filter"
    },
    {
      "parameters": {},
      "type": "n8n-nodes-base.limit",
      "typeVersion": 1,
      "position": [
        1120,
        -208
      ],
      "id": "2292a3b3-656f-460e-ad1a-3773cbce19e0",
      "name": "Limit",
      "alwaysOutputData": false
    },
    {
      "parameters": {
        "respondWith": "redirect",
        "redirectURL": "=https://YOURAUTOMATESERVERHERE.com/automate/computer/{{ $json.deviceIdentifier }}",
        "options": {}
      },
      "type": "n8n-nodes-base.respondToWebhook",
      "typeVersion": 1.4,
      "position": [
        1344,
        -208
      ],
      "id": "2f11c36c-8ba5-4cc0-b38c-5e1caf0db15d",
      "name": "Redirect to Automate"
    },
    {
      "parameters": {
        "content": "Modify the URL to point to your Automate Server",
        "height": 80
      },
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1280,
        -32
      ],
      "typeVersion": 1,
      "id": "72316389-b6f1-4d31-8d90-f361fb1957bb",
      "name": "Sticky Note"
    }
  ],
  "connections": {
    "Webhook": {
      "main": [
        [
          {
            "node": "Get a ticket",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get a ticket": {
      "main": [
        [
          {
            "node": "Get Configurations on Ticket",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Configurations on Ticket": {
      "main": [
        [
          {
            "node": "Lookup Each Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Lookup Each Configuration": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit": {
      "main": [
        [
          {
            "node": "Redirect to Automate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {
    "Webhook": [
      {
        "params": {},
        "query": {
          "ticketid": "120418"
        }
      }
    ]
  },
  "meta": {
    "templateCredsSetupCompleted": true,
    "instanceId": "c184e9b4530d135cec93024f76caa53accab9229399f0cbe7ab0b73389a579ec"
  }
}