Create Teams notifications for new tickets in ConnectWise with Redis

by Gavin · 4,990 views · created 2024-07-22 · Ticket Management

What this workflow does

This workflow has 8 nodes and runs on a schedule (cron */1 8-16 * * 1-5). Along the way it connects Redis and Microsoft Teams. It also calls na.myconnectwise.net over HTTP.

How it runs

Trigger: On a schedule (cron */1 8-16 * * 1-5).

1. Get New Tickets (HTTP Request): calls na.myconnectwise.net
2. Query Database (Redis): get
3. Add Filterable Parameter (Code): runs custom JavaScript code
4. Filter Out Tickets that have already been sent (Merge): merges the data from its input branches
5. Combine like Companies (Code): runs custom JavaScript code
6. Log in Redis (Redis): set
7. Teams to Dispatch (Microsoft Teams): work with chat message

Services it uses

RedisMicrosoft Teams

HTTP calls to: na.myconnectwise.net

Before you upgrade to n8n 3.0

Nodes used (6)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• Redisn8n-nodes-base.redis
• Mergen8n-nodes-base.merge
• HTTP Requestn8n-nodes-base.httpRequest
• Microsoft Teamsn8n-nodes-base.microsoftTeams

From the author

This Workflow does a HTTPs request to ConnectWise Manage through their REST API. It will pull all tickets in the "New" status or whichever status you like, and notify your dispatch team/personnel whenever a new ticket comes in using Microsoft Teams. Video…

View the original on n8n.io → Check your own copy