n8n: WIPUpdates

5 active flows.

Summary

Flow	Trigger	Calls	Procs	Tables
WIP Snapshot Job Stats	schedule: every 4 hours	0	1	0
WIP Updates - Create Prime History Notes	schedule: every 7 minutes	1	3	0
WIP Updates - Post Schedule Sharelinks to Prime	schedule: every minutes	0	3	0
WIP Updates - Process Email Queue	schedule: every 2 minutes	0	6	0
WIP Updates - SWMS Send Prime Attachment	schedule: every 7 minutes	1	3	0

Flows

WIP Snapshot Job Stats

Find foreign keys that are missing and queue the objects for sync

• Triggers: schedule: every 4 hours
• Nodes: 4 · Integrations: SQL
• Stored procedures: spEthWIPCaptureJobWeeklySnapshot

WIP Updates - Create Prime History Notes

• Triggers: schedule: every 7 minutes
• Nodes: 9 · Integrations: SQL
• HTTP targets: Ethos WebAPI
• Calls: Webhook Send Queued SMS
• Stored procedures: spEthTaskLockInsert, spEthTaskLockClear, spEthTaskLockIsLocked

WIP Updates - Post Schedule Sharelinks to Prime

• Triggers: schedule: every minutes
• Nodes: 8 · Integrations: SQL
• HTTP targets: Ethos WebAPI
• Stored procedures: spEthTaskLockIsLocked, spEthTaskLockInsert, spEthTaskLockClear

WIP Updates - Process Email Queue

WIP Update Email Sends queued emails for WIPUpdates. Sends using the Graph API and sends as the staff member not a shared mailbox

• Triggers: schedule: every 2 minutes
• Nodes: 17 · Integrations: SQL
• HTTP targets: login.microsoftonline.com, graph.microsoft.com
• Stored procedures: spEthTaskLockIsLocked, spEthTaskLockInsert, spEthTaskLockClear, spEthWIPJobEmailQueueAggregated, spEthWIPJobEmailMarkSentByWIPID, spEthWIPJobEmailMarkSendFailed

WIP Updates - SWMS Send Prime Attachment

• Triggers: schedule: every 7 minutes
• Nodes: 9 · Integrations: SQL
• HTTP targets: Ethos WebAPI
• Calls: Webhook Send Queued SMS
• Stored procedures: spEthTaskLockInsert, spEthTaskLockClear, spEthTaskLockIsLocked