Connections
VisiGrid connects to 11 financial data sources via vgrid fetch. Each adapter authenticates with the provider, fetches transactions for a date range, and outputs the same canonical 9-column CSV. See vgrid fetch for the output format specification.
| Connection | Command | Auth | Description |
|---|---|---|---|
| Stripe | vgrid fetch stripe | API key (STRIPE_API_KEY) | Balance transactions with payout grouping |
| Mercury | vgrid fetch mercury | API key (MERCURY_API_KEY) | Bank account transactions |
| QuickBooks Online | vgrid fetch qbo | OAuth 2.0 credentials file | Deposits, purchases, transfers |
| Xero | vgrid fetch xero | OAuth 2.0 credentials file | Bank transactions & transfers |
| Gusto | vgrid fetch gusto | OAuth 2.0 credentials file | Payroll (net, tax, other) |
| Brex Card | vgrid fetch brex-card | API key (BREX_API_KEY) | Card transactions |
| Brex Bank | vgrid fetch brex-bank | API key (BREX_API_KEY) | Cash account transactions |
| Ramp Card | vgrid fetch ramp-card | OAuth token (RAMP_ACCESS_TOKEN) | Card transactions |
| Ramp Bank | vgrid fetch ramp-bank | OAuth token (RAMP_ACCESS_TOKEN) | Business account transactions |
| Custom HTTP | vgrid fetch http | Configurable | Any JSON REST API via mapping file |
| SFTP | vgrid fetch sftp | SSH key / password | Download files from SFTP servers |
All adapters except SFTP produce the canonical 9-column CSV described in vgrid fetch. SFTP is a transport-only adapter that downloads raw files.