Server-Side Secret Isolation
Retool Resources, Supabase Edge Secrets (supabase secrets set APIFY_TOKEN=...), Next.js Route Handlers, and Bubble Private Headers keep your API token strictly server-side—never exposed to end-user browsers.
Retool, Supabase, Next.js & BubbleBuilding an internal treasury ops dashboard in Retool or Appsmith, or shipping a vertical B2B SaaS on Supabase + Next.js or Bubble? Skip months of maintaining fragile fixed-width COBOL/ISO 20022 specs—plug in our 9 deterministic banking endpoints via 1-click OpenAPI 3.1 import or 20-line Edge Functions at $0/month fixed cost.
https://geornaden.github.io/finops-studio/openapi.json to auto-discover all 9 synchronous endpoints.
Retool Resources, Supabase Edge Secrets (supabase secrets set APIFY_TOKEN=...), Next.js Route Handlers, and Bubble Private Headers keep your API token strictly server-side—never exposed to end-user browsers.
Every request validates IBAN MOD-97, ABA MOD-10, 2026 EPC BE04 structured addresses, Leitweg-ID MOD 97-10, or BAI2 49/98/99 control totals before a finance manager ever touches a bank portal.
Instead of paying $499–$1,500/month for enterprise treasury middleware while launching your SaaS feature, pay $0/month fixed and $0.02/payment row ($0.05/e-invoice)—passing pennies per export cleanly into your Pro tier.
In Retool's query Success event handler, run a 1-line script: utils.downloadFile(exportBankBatch.data[0].fileContent, exportBankBatch.data[0].fileName, 'text/plain'). Because FinOps Studio returns exact 94-char (NACHA), 100-char (BACS), or 120-char (ABA) lines as an intact string inside JSON, Retool's browser download preserves every space-padded fixed-width column.
Yes. Synchronous batches up to hundreds of rows execute in 1.2–3.0 seconds via /run-sync-get-dataset-items, well inside Bubble API Connector's timeout window. For 10,000+ row enterprise payroll runs, call /runs asynchronously with a Bubble backend webhook URL.