n8n: OptimoRoute

5 active flows.

Summary

Flow	Trigger	Calls	Procs	Tables
OptimoRoute Dispatch	schedule: every minutes; webhook GET (unguessable path); called by other flow	0	3	0
OptimoRoute Email Orders Not Scheduled to Bookings	schedule: every undefined	0	0	0
OptimoRoute Update AI Job Summary Notes	schedule: every 3 hours	0	0	0
OptimoRoute WebAPI Complete Appointments and Set Estimators	schedule: every 33 minutes	0	0	0
OptimoRoute WebAPI Plan Dates	webhook GET (unguessable path); called by other flow	1	3	0

Flows

OptimoRoute Dispatch

OptimoRoute Dispatch - Process (API) Polls the WebAPI every 5 minutes. The API decides, not this flow. It works out for itself whether the cutoff has passed and whether the live date needs re-sending, so it follows the RoutePlanningCutoffTime setting in AdminP

• Triggers: schedule: every minutes; webhook GET (unguessable path); called by other flow
• Nodes: 23 · Integrations: SQL
• HTTP targets: Ethos WebAPI
• Stored procedures: spEthTaskLockIsLocked, spEthTaskLockInsert, spEthTaskLockClear

OptimoRoute Email Orders Not Scheduled to Bookings

• Triggers: schedule: every undefined
• Nodes: 3
• HTTP targets: Ethos WebAPI

OptimoRoute Update AI Job Summary Notes

Processes the Task Queue Gets the Prime Objects via the API Checks for Prime Data Generates and Saves a summary using OpenAI

• Triggers: schedule: every 3 hours
• Nodes: 5
• HTTP targets: Ethos WebAPI

OptimoRoute WebAPI Complete Appointments and Set Estimators

Updates back to Prime If the Stop is completed mark the Prime Appointment as Completed. If the Estimator is scheduled (after the cutoff) set the Appoinmtnet user in Prime

• Triggers: schedule: every 33 minutes
• Nodes: 7
• HTTP targets: Ethos WebAPI

OptimoRoute WebAPI Plan Dates

Plan Dates Starts planning for every date marked NotPlanned, polls until OptimoRoute reports none outstanding, then refreshes routes and orders for all future dates and sends any queued SMS. Split out of OptimoRoute WebAPI Create and Plan Appointments so the p

• Triggers: webhook GET (unguessable path); called by other flow
• Nodes: 22 · Integrations: SQL
• HTTP targets: Ethos WebAPI
• Calls: Webhook Send Queued SMS
• Stored procedures: spEthTaskLockIsLocked, spEthTaskLockInsert, spEthTaskLockClear