Stripe

Read your Stripe customers, charges, invoices, subscriptions, products, prices, payment intents and balance.

Connect it in the console under Integrations > Connectors. See Connectors for how connectors work and who can use them.

Create a read-only credential

Create a restricted key in the Stripe Dashboard (Developers > API keys > Create restricted key) with Read access to the resources you want, and nothing else. A secret key (sk_) also works; a publishable key (pk_) does not.

Settings

Setting		Notes
API key	Required	A restricted key with read access is best. Stored encrypted and never shown again.

Tables

Table	Filters	Returns
balance	None	Available and pending balance.
customers	email, starting_after	Customers.
charges	customer, payment_intent, starting_after	Charges.
invoices	customer, status, subscription, starting_after	Invoices.
subscriptions	customer, status, price, starting_after	Subscriptions (status=all includes canceled).
products	active, starting_after	Products.
prices	product, active, type, starting_after	Prices.
payment_intents	customer, starting_after	Payment intents.
balance_transactions	type, payout, starting_after	Balance transactions.
accounts	starting_after	Connected accounts (Stripe Connect platforms only).

Query from the API

curl -s -X POST "https://api.vaif.studio/database/connector/$VAIF_PROJECT_ID/query" \
  -H "Authorization: Bearer $VAIF_TOKEN" -H "Content-Type: application/json" \
  -d '{"wrapperId":"stripe_fdw","table":"invoices","filters":{"status":"open"},"limit":50}'

$VAIF_TOKEN is a console access token. See Connectors for the routes.

How it stays read-only

Requests use Stripe API version 2024-06-20, so the columns do not change when your account’s default version does. Pages follow Stripe’s cursors: pass the last row’s id as starting_after.