Phantom Ledger is a Railway-hosted proxy that syncs Salesforce report data across all five lines of business on a five-minute schedule and serves it from a shared cache — powering the Top Producers widget on SharePoint and any surface that needs ranked producer performance without hammering Salesforce on every request.
A lightweight Express server that authenticates to Salesforce via OAuth 2.0 client credentials and refreshes all five reports together every five minutes, caching the parsed results server-side. Every request — the widget, a debug call, or a dozen browser tabs at once — reads from that shared cache, so Salesforce is called once per cycle no matter who's watching. If one report's fetch fails, that LOB simply keeps serving its last known-good data.
A self-contained HTML widget that calls /reports and renders a ranked leaderboard for each line of business — a grand total up top, Top 10 producers underneath, and a colored metric banner on every column (Premium · MTD, Revenue · Last 30 Days, Policies · Last 30 Days). A "last updated" footer, stamped in the viewer's own timezone, keeps the cache interval visible at a glance.
Each line of business has its own scoped endpoint for debugging and verification — also served from the shared five-minute cache rather than calling Salesforce directly, so checking a single report adds no extra load or wait. Useful for validating parse logic or confirming data shape without pulling all five reports at once.
Phantom Ledger is an internal system at YourPolicy — not a public product. Built on Express and deployed on Railway, syncing Salesforce every five minutes so the leaderboard stays fast without hammering the API.