Loads a single provider by external id, its live-account count, and a
bounded sample of the most recently created live accounts it backs.
Returns null when no provider has that id — callers 404.
Searches providers with the count of live (non-deleted) virtual accounts
each backs, ordered by name. The soft-delete filter sits in the join's ON
clause so providers backing zero accounts still appear with
accountCount = 0. count(*) OVER () counts the grouped rows, so total
is the number of matching providers. The table is a small fixed reference
set with no timestamps, so the default page size returns every row.
Optionalids?: string[]Optionalpage?: numberDefaults to 1
OptionalpageSize?: numberDefaults to 50
Optionaltypes?: ("ROUTE_FUSION" | "VICTOR" | "BIVO" | "MANUAL")[]Renames a provider. Only the display label is mutable; type and
externalId are immutable here (see class doc). Rejects a blank name so
the list never shows an unlabelled row.
Admin-only reads + rename for the
virtual_account_providerreference table.The table is a small, fixed reference set: the seeded integrated providers (
victor/bivo/route_fusion) plus the canonicalmanualprovider. Rows are never minted or deleted here — only the display label (name) is mutable.typeis the route-matcher discriminator andexternalIdis referenced across routes, audits, and account rows, so neither is editable.