Skip to content

n8n: Repairline ​

4 active flows.

Summary ​

FlowTriggerCallsProcsTables
Repairline dates and schedules - Enqueueschedule: every 3 hours010
Repairline submit job - create Prime jobwebhook POST /f7a3b2c1-8d4e-4f5a-9b6c-7d8e9f0a1b2c/repairline-submit/create-prime-job011
Repairline submit job - intakeOutlook email010
Repairline submit job - intake reconciler (Outlook trigger)Outlook email010

Flows ​

Repairline dates and schedules - Enqueue ​

Repairline dates and schedules - Enqueue A trigger and one EXEC. spEthRepairlineJobDatesQueueTasks is the producer: it finds Prime jobs whose RepairLine dates and schedules are missing or stale and ends in spEthWorkQueueEnqueuePreview on the RepairlinePortalUp

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

Repairline submit job - create Prime job ​

Create Prime job (the non-web half of repair-line submit) The Stagehand worker reads a RepairLine job page and POSTs { messageId, claimToken, snapshot } here exactly once per message, with no retries. This workflow owns everything that is not the website: vali

  • Triggers: webhook POST /f7a3b2c1-8d4e-4f5a-9b6c-7d8e9f0a1b2c/repairline-submit/create-prime-job
  • Nodes: 22 · Integrations: SQL
  • HTTP targets: Ethos WebAPI
  • Stored procedures: spEthWorkQueueSeal_Preview
  • Tables/views read or written: primeJobs

Repairline submit job - intake ​

Repairline submit job: mail intake Fast path. RepairLine mail in quotes@ that is a new job to submit becomes a queue row about a minute after it arrives. The reconciler (Repairline submit job - intake reconciler) is the guaranteed path: it re-reads three days

  • Triggers: Outlook email
  • Nodes: 13 · Integrations: Outlook, OpenAI, SQL
  • Stored procedures: spEthRepairlineSubmitQueueTask

Repairline submit job - intake reconciler (Outlook trigger) ​

Repair-line submission intake (Outlook trigger) Trigger-based version of Repairline submit job - intake reconciler. The standard Microsoft Outlook Trigger polls the quotes@ mailbox every minute for new mail from no-reply@repairline.com.au; each message is chec

  • Triggers: Outlook email
  • Nodes: 8 · Integrations: Outlook, SQL
  • Stored procedures: spEthRepairlineSubmitQueueTask