n8n: Prime

62 active flows.

Sub-flow calls

Summary

Flow	Trigger	Calls	Procs	Tables
Prime Budget API	webhook GET /3d5ac8ad-a91c-4edf-8627-dd0e290b1735/prime-budget	0	1	0
Prime Create Reviewed Estimate	called by other flow	2	2	2
Prime Generate API Tokens	schedule: every 2 hours	0	1	0
Prime Get Api Token from SQL	called by other flow	0	1	0
Prime Job Tag Sync - Estimator Job Type	schedule: every hours	1	1	7
Prime Job Tag Sync - Immediate Failure Alert	error handler	0	1	0
Prime Notification Queue - Process	schedule: every minutes	0	3	0
Prime Predefine Check and Soft Delete	schedule: every 1 weeks	0	1	0
Prime Push Estimate Item Corrections	called by other flow	2	1	0
Prime Record Rate Limit	called by other flow	0	0	0
Prime Record Rate Limit and Query	called by other flow	0	1	0
Prime Sync Accounts Payable Invoices by Date	schedule: every 6 hours	2	4	1
Prime Sync Allocations by Date	schedule: every hours	2	4	1
Prime Sync AllocationStatuses	schedule: every 1 weeks	2	2	1
Prime Sync AppointmentType	schedule: every months	2	2	1
Prime Sync AR Invoices by Date	schedule: every 30 minutes	2	6	2
Prime Sync Attachments by Date	schedule: every 4 hours	2	4	1
Prime Sync AttachmentType	schedule: every months	2	2	1
Prime Sync Catastrophe Codes	schedule: every 1 weeks	2	2	1
Prime Sync Contact Licences	schedule: every undefined; schedule: cron 5 7-18 * * 1-5	2	2	1
Prime Sync Contacts by Date	schedule: cron 0,31 9-17 * * 1-5; schedule: cron 0 */2 * * 0,6; schedule: cron 0 0,2,4,6,8,18,20,22 * * 1-5	2	10	1
Prime Sync Custom Field Options	schedule: every days	2	2	1
Prime Sync Custom Fields	schedule: every days	2	2	1
Prime Sync Estimate Template Items - Ethos Only	schedule: every 6 hours	2	2	1
Prime Sync Estimate Template Items and Overrides	schedule: every weeks; schedule: every weeks	2	3	1
Prime Sync Estimates by Date	schedule: every hours	2	6	1
Prime Sync Feedback Items by Date	schedule: every undefined	2	4	1
Prime Sync Filter Tags	schedule: every 1 weeks	2	2	1
Prime Sync Filter Types	schedule: every 1 weeks	2	2	1
Prime Sync History - 6 Hourly	schedule: cron 0 32 0,6,12,18 * * *	2	4	1
Prime Sync History - Daily	schedule: cron 0 0,10,15,20,30,35 16 * * *	2	4	1
Prime Sync History - Hourly Estimator Payables	schedule: cron 0 5 * * * *	2	4	1
Prime Sync History - Hourly Receivables	schedule: cron 0 45 * * * *	2	4	1
Prime Sync History - Hourly Work Orders	schedule: cron 0 25 * * * *	2	4	1
Prime Sync HistoryActions	schedule: every weeks	2	2	1
Prime Sync Job Custom Fields by Date	schedule: every 2 hours	2	4	0
Prime Sync Job Expense Invoices	schedule: cron 10 * * * *	2	1	1
Prime Sync Locked Estimates by Date	schedule: every 4 hours	2	6	0
Prime Sync Milestone Items by Date	schedule: every 2 hours	2	4	0
Prime Sync Milestones by Date	schedule: every undefined	2	4	1
Prime Sync Notifications by Date	schedule: every 2 hours	2	5	1
Prime Sync NotificationTemplates	schedule: every 1 weeks	2	2	1
Prime Sync Perils	schedule: every 1 weeks	2	2	1
Prime Sync Queued Accounts Payable Invoices (Batched)	schedule: cron */37 * * * *	2	4	0
Prime Sync Queued ContactRelationship (Batched)	schedule: every 33 minutes; called by other flow	2	4	0
Prime Sync Queued Contacts (Batched)	schedule: every 30 minutes; called by other flow	2	2	0
Prime Sync Queued StatusHistories_Job (Batched)	schedule: every 55 minutes; called by other flow	2	3	0
Prime Sync Reminders by Date	schedule: every undefined	2	4	0
Prime Sync Schedules by Date	schedule: every 2 hours	2	6	0
Prime Sync SiteForms by Date	schedule: every 2 hours	2	5	1
Prime Sync SiteFormTemplates	schedule: every weeks	2	2	1
Prime Sync Status	schedule: every undefined	2	2	1
Prime Sync StatusHistories_Allocation by Date	schedule: cron 0 17 * * * *	2	4	1
Prime Sync StatusHistories_Job by Date	schedule: every 2 hours	2	4	1
Prime Sync Supervisors	schedule: cron 0 15 5 * * *	0	1	1
Prime Sync Trades	schedule: every 1 weeks	2	2	1
Prime Sync Users	schedule: every undefined	2	2	1
Prime Sync Work Orders by Date	schedule: every 2 hours	2	5	1
Prime Webhook Process Events	schedule: every 2 minutes; webhook GET (unguessable path)	0	3	0
Process Upsert Sync Progress History	schedule: every 3 hours	0	1	0
Queue Accounts Payable Invoices	schedule: every weeks	0	1	0
Sync Contact Relationship Types	schedule: every undefined	2	2	0

Flows

Prime Budget API

Prime write-budget, for container-app jobs Read-only. Wraps spN8nGetPrimeRateLimitPercent so a Container Apps job can ask the same question the Process Queue workflows have always asked with their "Prime Budget OK?" node. Percentage is REMAINING headroom, so h

• Triggers: webhook GET /3d5ac8ad-a91c-4edf-8627-dd0e290b1735/prime-budget
• Nodes: 4 · Integrations: SQL
• Stored procedures: spN8nGetPrimeRateLimitPercent

Prime Create Reviewed Estimate

Prime Create Reviewed Estimate DevOps Task 1013. Sub-workflow of AI peer Review 3.0. One input item = one split estimate from Split Estimates for Prime [Std]. Creates a complete '<source label (Reviewed)' copy. GET /trades + GET /units (once) - POST estimate -

• Triggers: called by other flow
• Nodes: 39 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Called by: AI peer Review 3.0
• Stored procedures: spN8nGetPrimeRateLimitPercent, spEthEmailMessageInsertHTMLWithAttachments
• Tables/views read or written: primeJobs, EthAGTemplateWordingCodes

Prime Generate API Tokens

Api Token 1 Gets Access Token From Prime API

• Triggers: schedule: every 2 hours
• Nodes: 8 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Stored procedures: spPrimeUpsertApiToken

Prime Get Api Token from SQL

• Triggers: called by other flow
• Nodes: 3 · Integrations: SQL
• Called by: Adding Jobs to Peer Review Queue; AI peer Review 3.0; Amend Missing Schedules and Schedule Items; Discover and remove deleted invoices; Discover and remove deleted schedule items (Batched); Endata Scope Email at Estimate Approved for Submission; Make Safe Queued Allocation Checks; PC Build - Draft Form; PC Build - Read Job Reports; PC Build - Write Form; Peer Review Queue from Status Webhooks; Prime Create Reviewed Estimate; Prime Job Email Sync; Prime Job Tag Sync - Estimator Job Type; Prime Push Estimate Item Corrections; Prime Sync Accounts Payable Invoices by Date; Prime Sync Allocations by Date; Prime Sync AllocationStatuses; Prime Sync Appointments by Date; Prime Sync AppointmentType; Prime Sync AR Invoices by Date; Prime Sync Attachments by Date; Prime Sync AttachmentType; Prime Sync Catastrophe Codes; Prime Sync Contact Licences; Prime Sync Contacts by Date; Prime Sync Custom Field Options; Prime Sync Custom Fields; Prime Sync Estimate Template Items - Ethos Only; Prime Sync Estimate Template Items and Overrides; Prime Sync Estimates by Date; Prime Sync Feedback Items by Date; Prime Sync Filter Tags; Prime Sync Filter Types; Prime Sync History - 6 Hourly; Prime Sync History - Daily; Prime Sync History - Hourly Estimator Payables; Prime Sync History - Hourly Receivables; Prime Sync History - Hourly Work Orders; Prime Sync HistoryActions; Prime Sync Job Custom Fields by Date; Prime Sync Job Expense Invoices; Prime Sync Jobs by Date; Prime Sync Locked Estimates by Date; Prime Sync Milestone Items by Date; Prime Sync Milestones by Date; Prime Sync Notifications by Date; Prime Sync NotificationTemplates; Prime Sync Perils; Prime Sync Queued Accounts Payable Invoices (Batched); Prime Sync Queued Allocations (Batched); Prime Sync Queued Allocations By ID; Prime Sync Queued Allocations; Prime Sync Queued ContactRelationship (Batched); Prime Sync Queued Contacts (Batched); Prime Sync Queued Jobs (Batched); Prime Sync Queued StatusHistories_Job (Batched); Prime Sync Reminders by Date; Prime Sync Resync Jobs; Prime Sync Resync Work Orders by JobID; Prime Sync Schedules by Date; Prime Sync SiteForms by Date; Prime Sync SiteFormTemplates; Prime Sync Status; Prime Sync StatusHistories_Allocation by Date; Prime Sync StatusHistories_Job by Date; Prime Sync Trades; Prime Sync Users; Prime Sync Work Orders by Date; Quote Submission Automation; Supplier Compliance - Make Lapsed Contacts Inactive (daily); Sync Contact Relationship Types
• Stored procedures: spEthGetLastApiToken

Prime Job Tag Sync - Estimator Job Type

• Triggers: schedule: every hours
• Nodes: 17 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL
• Stored procedures: spN8nGetPrimeRateLimitPercent
• Tables/views read or written: primeFilterTags, primeJobFilterTags, primeAppointments, primeAppointmentType, primeJobs, EthEstimatorOpenJobs, EthEstimatorQuoteLife

Prime Job Tag Sync - Immediate Failure Alert

Immediate failure alert for the tag backfill Set as the Error Workflow on Prime Job Tag Sync - Estimator Job Type. WHY THIS EXISTS: the Global Error Handler only emails after five consecutive failures, or when six of the last ten runs fail. That suits a flow r

• Triggers: error handler
• Nodes: 3 · Integrations: SQL
• Stored procedures: spEthEmailMessageInsertHTMLWithAttachments

Prime Notification Queue - Process

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

Prime Predefine Check and Soft Delete

• Triggers: schedule: every 1 weeks
• Nodes: 3 · Integrations: SQL
• Stored procedures: spPrimeSoftDeleteMissingPredefines

Prime Push Estimate Item Corrections

• Triggers: called by other flow
• Nodes: 12 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Called by: AI peer Review 3.0
• Stored procedures: spN8nGetPrimeRateLimitPercent

Prime Record Rate Limit

WorkFlow is Disabled Use the Prime Record Rate Limit and Query instead

• Triggers: called by other flow
• Nodes: 3

Prime Record Rate Limit and Query

• Triggers: called by other flow
• Nodes: 2 · Integrations: SQL
• Called by: AI peer Review 3.0; Amend Missing Schedules and Schedule Items; Discover and remove deleted invoices; Discover and remove deleted schedule items (Batched); Endata Scope Email at Estimate Approved for Submission; PC Build - Draft Form; PC Build - Read Job Reports; PC Build - Write Form; Peer Review Queue from Status Webhooks; Prime Create Reviewed Estimate; Prime Job Email Sync; Prime Push Estimate Item Corrections; Prime Sync Accounts Payable Invoices by Date; Prime Sync Allocations by Date; Prime Sync AllocationStatuses; Prime Sync Appointments by Date; Prime Sync AppointmentType; Prime Sync AR Invoices by Date; Prime Sync Attachments by Date; Prime Sync AttachmentType; Prime Sync Catastrophe Codes; Prime Sync Contact Licences; Prime Sync Contacts by Date; Prime Sync Custom Field Options; Prime Sync Custom Fields; Prime Sync Estimate Template Items - Ethos Only; Prime Sync Estimate Template Items and Overrides; Prime Sync Estimates by Date; Prime Sync Feedback Items by Date; Prime Sync Filter Tags; Prime Sync Filter Types; Prime Sync History - 6 Hourly; Prime Sync History - Daily; Prime Sync History - Hourly Estimator Payables; Prime Sync History - Hourly Receivables; Prime Sync History - Hourly Work Orders; Prime Sync HistoryActions; Prime Sync Job Custom Fields by Date; Prime Sync Job Expense Invoices; Prime Sync Jobs by Date; Prime Sync Locked Estimates by Date; Prime Sync Milestone Items by Date; Prime Sync Milestones by Date; Prime Sync Notifications by Date; Prime Sync NotificationTemplates; Prime Sync Perils; Prime Sync Queued Accounts Payable Invoices (Batched); Prime Sync Queued Allocations (Batched); Prime Sync Queued Allocations By ID; Prime Sync Queued Allocations; Prime Sync Queued ContactRelationship (Batched); Prime Sync Queued Contacts (Batched); Prime Sync Queued Jobs (Batched); Prime Sync Queued StatusHistories_Job (Batched); Prime Sync Reminders by Date; Prime Sync Resync Jobs; Prime Sync Resync Work Orders by JobID; Prime Sync Schedules by Date; Prime Sync SiteForms by Date; Prime Sync SiteFormTemplates; Prime Sync Status; Prime Sync StatusHistories_Allocation by Date; Prime Sync StatusHistories_Job by Date; Prime Sync Trades; Prime Sync Users; Prime Sync Work Orders by Date; Supplier Compliance - Make Lapsed Contacts Inactive (daily); Sync Contact Relationship Types
• Stored procedures: spN8nRateLimitInsert

Prime Sync Accounts Payable Invoices by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 6 hours
• Nodes: 20 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spPrimeUpsertAccountsPayableInvoice, spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Allocations by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every hours
• Nodes: 19 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spPrimeUpsertAllocation, spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync AllocationStatuses

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 1 weeks
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertAllocationStatus, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync AppointmentType

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every months
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertAppointmentType, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync AR Invoices by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 30 minutes
• Nodes: 27 · Integrations: SQL
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spEthSyncUpsertProgress, spPrimeUpsertAccountsReceivableInvoice, spPrimeUpsertAccountsReceivableInvoiceItem, spPrimeUpsertAccountsReceivableInvoiceItemAllocation, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule, ethSyncSkippedWindows

Prime Sync Attachments by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 4 hours
• Nodes: 19 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spPrimeUpsertAttachments, spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync AttachmentType

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every months
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertAttachmentType, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Catastrophe Codes

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 1 weeks
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertCatastropheCode, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Contact Licences

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every undefined; schedule: cron 5 7-18 * * 1-5
• Nodes: 16 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: primeContactLicences

Prime Sync Contacts by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: cron 0,31 9-17 * * 1-5; schedule: cron 0 */2 * * 0,6; schedule: cron 0 0,2,4,6,8,18,20,22 * * 1-5
• Nodes: 30 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spPrimeUpsertContact, spEthSyncUpsertProgress, spPrimeOrphanContactTrades, spPrimeUpsertContactTrades, spPrimeDeleteOrphanedContactTrades, spPrimeOrphanContactRegions, spPrimeUpsertContactRegions, spPrimeDeleteOrphanedContactRegions, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Custom Field Options

• Triggers: schedule: every days
• Nodes: 13 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent, spPrimeUpsertCustomFieldOption
• Tables/views read or written: ethSyncSchedule

Prime Sync Custom Fields

• Triggers: schedule: every days
• Nodes: 13 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent, spPrimeUpsertCustomField
• Tables/views read or written: ethSyncSchedule

Prime Sync Estimate Template Items - Ethos Only

• Triggers: schedule: every 6 hours
• Nodes: 14 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent, spPrimeUpsertEstimateTemplateItem
• Tables/views read or written: ethSyncSchedule

Prime Sync Estimate Template Items and Overrides

• Triggers: schedule: every weeks; schedule: every weeks
• Nodes: 26 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent, spPrimeUpsertEstimateTemplateItem, spPrimeUpsertEstimateTemplateItemOverride
• Tables/views read or written: ethSyncSchedule

Prime Sync Estimates by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every hours
• Nodes: 28 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spEthSyncUpsertProgress, spPrimeUpsertEstimate, spPrimeUpsertEstimateCategory, spPrimeUpsertEstimateCategoryItem, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Feedback Items by Date

• Triggers: schedule: every undefined
• Nodes: 17 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent, spEthSyncGetNextDates, spPrimeUpsertFeedbackItem, spEthSyncUpsertProgress
• Tables/views read or written: ethSyncSchedule

Prime Sync Filter Tags

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 1 weeks
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertFilterTag, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Filter Types

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 1 weeks
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertFilterType, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync History - 6 Hourly

• Triggers: schedule: cron 0 32 0,6,12,18 * * *
• Nodes: 16 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spPrimeUpsertHistoryPage, spN8nGetPrimeRateLimitPercent, spEthSyncGetNextDatesByGroup, spEthSyncRecordWindowOutcome
• Tables/views read or written: ethSyncSchedule

Prime Sync History - Daily

• Triggers: schedule: cron 0 0,10,15,20,30,35 16 * * *
• Nodes: 17 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spPrimeUpsertHistoryPage, spN8nGetPrimeRateLimitPercent, spEthSyncGetNextDatesByGroup, spEthSyncRecordWindowOutcome
• Tables/views read or written: ethSyncSchedule

Prime Sync History - Hourly Estimator Payables

• Triggers: schedule: cron 0 5 * * * *
• Nodes: 16 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spPrimeUpsertHistoryPage, spN8nGetPrimeRateLimitPercent, spEthSyncGetNextDatesByGroup, spEthSyncRecordWindowOutcome
• Tables/views read or written: ethSyncSchedule

Prime Sync History - Hourly Receivables

• Triggers: schedule: cron 0 45 * * * *
• Nodes: 16 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spPrimeUpsertHistoryPage, spN8nGetPrimeRateLimitPercent, spEthSyncGetNextDatesByGroup, spEthSyncRecordWindowOutcome
• Tables/views read or written: ethSyncSchedule

Prime Sync History - Hourly Work Orders

• Triggers: schedule: cron 0 25 * * * *
• Nodes: 16 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spPrimeUpsertHistoryPage, spN8nGetPrimeRateLimitPercent, spEthSyncGetNextDatesByGroup, spEthSyncRecordWindowOutcome
• Tables/views read or written: ethSyncSchedule

Prime Sync HistoryActions

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every weeks
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertHistoryActions, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Job Custom Fields by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 2 hours
• Nodes: 18 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spPrimeUpsertJobCustomFields, spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent

Prime Sync Job Expense Invoices

Hourly delta + nightly full sweep (Task 1856, 2026-10-15) Prime now honours q='updatedAt'.gt(...) on this route - proven 2026-10-15 (165 of 19,378). The August finding that every filter was ignored is superseded. Sort is still ignored. How it works - Runs ever

• Triggers: schedule: cron 10 * * * *
• Nodes: 14 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent
• Tables/views read or written: primeJobExpenseInvoices

Prime Sync Locked Estimates by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 4 hours
• Nodes: 28 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spEthSyncUpsertProgress, spPrimeUpsertLockedEstimate, spPrimeUpsertLockedEstimateCategory, spPrimeUpsertLockedEstimateCategoryItem, spN8nGetPrimeRateLimitPercent

Prime Sync Milestone Items by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 2 hours
• Nodes: 18 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spPrimeUpsertMilestoneItems, spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent

Prime Sync Milestones by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every undefined
• Nodes: 20 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spPrimeUpsertMilestones, spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Notifications by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 2 hours
• Nodes: 20 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, Upsert, spPrimeUpsertNotification, spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync NotificationTemplates

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 1 weeks
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertNotificationTemplate, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Perils

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 1 weeks
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertPeril, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Queued Accounts Payable Invoices (Batched)

• Triggers: schedule: cron */37 * * * *
• Nodes: 13 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent, spEthGetQueuedIDs, spPrimeUpsertAccountsPayableInvoice, spEthSyncQueueDelete

Prime Sync Queued ContactRelationship (Batched)

• Triggers: schedule: every 33 minutes; called by other flow
• Nodes: 14 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Called by: Prime Job Email Sync
• Stored procedures: spN8nGetPrimeRateLimitPercent, spEthGetQueuedIDs, spPrimeUpsertContactRelationship, spEthSyncQueueDelete

Prime Sync Queued Contacts (Batched)

• Triggers: schedule: every 30 minutes; called by other flow
• Nodes: 14 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Called by: Prime Job Email Sync; Prime Sync Jobs by Date
• Stored procedures: spN8nGetPrimeRateLimitPercent, spEthGetQueuedIDs

Prime Sync Queued StatusHistories_Job (Batched)

• Triggers: schedule: every 55 minutes; called by other flow
• Nodes: 12 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Called by: Prime Job Email Sync; Prime Sync Jobs by Date
• Stored procedures: spN8nGetPrimeRateLimitPercent, spEthGetQueuedIDs, spPrimeUpsertStatusHistory_Job

Prime Sync Reminders by Date

• Triggers: schedule: every undefined
• Nodes: 17 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent, spEthSyncGetNextDates, spEthSyncUpsertProgress, spPrimeUpsertReminder

Prime Sync Schedules by Date

Prime Sync Schedules by Date Replaces the per-JobId queue flow hNO4bz7xoVxhVa9J, which existed only because Prime's bulk GET /schedules returned 405 until 2026-08-03. Each schedule carries its items inline at attributes.scheduleItems[], so one page populates b

• Triggers: schedule: every 2 hours
• Nodes: 20 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent, spEthSyncGetNextDates, spEthSyncUpsertProgress, args, spPrimeUpsertSchedule, spPrimeUpsertScheduleItem

Prime Sync SiteForms by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 2 hours
• Nodes: 24 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spEthSyncUpsertProgress, spPrimeUpsertSiteForm, spPrimeUpsertSiteFormItem, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync SiteFormTemplates

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every weeks
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertSiteFormTemplate, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Status

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every undefined
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertStatus, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync StatusHistories_Allocation by Date

• Triggers: schedule: cron 0 17 * * * *
• Nodes: 16 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Get Api Token from SQL; Prime Record Rate Limit and Query
• Stored procedures: spN8nGetPrimeRateLimitPercent, spEthSyncGetNextDates, spPrimeUpsertStatusHistory_AllocationBatch, spEthSyncUpsertProgress
• Tables/views read or written: ethSyncSchedule

Prime Sync StatusHistories_Job by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 2 hours
• Nodes: 19 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Called by: Webhook Sync Jobs
• Stored procedures: spEthSyncGetNextDates, spPrimeUpsertStatusHistory_Job, spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Supervisors

• Triggers: schedule: cron 0 15 5 * * *
• Nodes: 6 · Integrations: SQL
• Stored procedures: spEthSupervisorSync
• Tables/views read or written: ethSupervisor

Prime Sync Trades

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 1 weeks
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertTrades, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Users

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every undefined
• Nodes: 15 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertUser, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Sync Work Orders by Date

About Pagination Get the First Page as this contains the total page numbers. If Total Pages 1 then performs the second request (for each page)

• Triggers: schedule: every 2 hours
• Nodes: 24 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spEthSyncGetNextDates, spEthSyncUpsertProgress, spPrimeUpsertWorkOrder, spPrimeUpsertWorkOrderItems, spN8nGetPrimeRateLimitPercent
• Tables/views read or written: ethSyncSchedule

Prime Webhook Process Events

Processes inbound Prime webhook events (UserStory1258) PrimeWebhookController stores every inbound Prime webhook POST in ethPrimeWebhookLog and returns 200 immediately - it does no processing, because Prime retries any non-2xx and inline work would turn a slow

• Triggers: schedule: every 2 minutes; webhook GET (unguessable path)
• Nodes: 11 · Integrations: SQL
• HTTP targets: Ethos WebAPI
• Stored procedures: spEthTaskLockIsLocked, spEthTaskLockInsert, spEthTaskLockClear

Process Upsert Sync Progress History

Creates a History for the current Date

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

Queue Accounts Payable Invoices

• Triggers: schedule: every weeks
• Nodes: 3 · Integrations: SQL
• Stored procedures: spEthQueueAccountsPayableInvoices

Sync Contact Relationship Types

Api Token Gets the Last Token from the SQL Database as a Sub Workflow

• Triggers: schedule: every undefined
• Nodes: 13 · Integrations: SQL
• HTTP targets: www.primeeco.tech
• Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
• Stored procedures: spPrimeUpsertContactRelationshipType, spN8nGetPrimeRateLimitPercent