Appearance

n8n: TimeCritical ​

8 active flows.

Sub-flow calls ​

Summary ​

FlowTriggerCallsProcsTables
Make Safe Queued Allocation Checksschedule: every 3 minutes250
Prime Job Email SyncOutlook email750
Prime Sync Appointments by Dateschedule: every hours; called by other flow261
Prime Sync Jobs by Dateschedule: every 30 minutes651
Prime Sync Queued Allocationsschedule: cron */47 * * * *240
Prime Sync Queued Allocations (Batched)schedule: cron */47 * * * *; called by other flow240
Prime Sync Queued Allocations By IDschedule: every 3 hours220
Prime Sync Queued Jobs (Batched)schedule: every 33 minutes; called by other flow230

Flows ​

Make Safe Queued Allocation Checks ​

What is this check? For new Prime jobs; Allocation may come in after the job is created (e.g. 1 min later). This task performs the checks that are scheduled when the PrimeJob was created with allocation checks up to 15 minutes after creation. the Task syncs al

  • Triggers: schedule: every 3 minutes
  • Nodes: 10 · Integrations: SQL
  • Calls: Prime Sync Queued Allocations (Batched); Prime Get Api Token from SQL
  • Stored procedures: spMakesafeUpsertPhoneCallFromPrimeJob, spEthSyncQueueUpsert, spEthTaskGetNext, spEthTaskClaimNext, spEthTaskDelete

Prime Job Email Sync ​

  • Triggers: Outlook email
  • Nodes: 20 · Integrations: Outlook, SQL
  • HTTP targets: www.primeeco.tech
  • Calls: SMS Send Queued Messages; Prime Sync Queued Contacts (Batched); Prime Sync Queued StatusHistories_Job (Batched); Prime Sync Queued Allocations (Batched); Prime Sync Queued ContactRelationship (Batched); Prime Record Rate Limit and Query; Prime Get Api Token from SQL
  • Stored procedures: spPrimeUpsertJob, spEthSyncQueueMissingObjectsByJobID, spMakesafeUpsertPhoneCallFromPrimeJob, spPrimeEmailJobRegisteredInsert, spPrimeSaveJobReference

Prime Sync Appointments 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; called by other flow
  • Nodes: 26 · Integrations: SQL
  • HTTP targets: www.primeeco.tech
  • Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
  • Called by: Recurring Appointments - Process Now
  • Stored procedures: spEthSyncGetNextDates, spPrimeUpsertAppointments, spEthSyncUpsertProgress, spN8nGetPrimeRateLimitPercent, spEthTaskLockIsLocked, spEthTaskLockClear
  • Tables/views read or written: ethSyncSchedule

Prime Sync Jobs 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: 32 · Integrations: SQL
  • HTTP targets: www.primeeco.tech
  • Calls: Prime Record Rate Limit and Query; SMS Send Queued Messages; Prime Sync Queued Contacts (Batched); Prime Sync Queued StatusHistories_Job (Batched); Prime Sync Queued Allocations (Batched); Prime Get Api Token from SQL
  • Stored procedures: spEthSyncGetNextDates, spPrimeUpsertJob, spEthSyncUpsertProgress, spEthSyncQueueMissingObjectsByJobID, spMakesafeUpsertPhoneCallFromPrimeJob
  • Tables/views read or written: ethSyncSchedule

Prime Sync Queued Allocations ​

About Syncing This Jobs syncs Allocations by JobID

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

Prime Sync Queued Allocations (Batched) ​

  • Triggers: schedule: cron */47 * * * *; 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: Make Safe Queued Allocation Checks; Prime Job Email Sync; Prime Sync Jobs by Date
  • Stored procedures: spN8nGetPrimeRateLimitPercent, spEthGetQueuedIDs, spPrimeUpsertAllocation, spEthSyncQueueDelete

Prime Sync Queued Allocations By ID ​

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

  • Triggers: schedule: every 3 hours
  • Nodes: 10 · Integrations: SQL
  • HTTP targets: www.primeeco.tech
  • Calls: Prime Record Rate Limit and Query; Prime Get Api Token from SQL
  • Stored procedures: spPrimeUpsertAllocation, spEthGetQueuedIDs

Prime Sync Queued Jobs (Batched) ​

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