Browse sources$ls -a sources
Logo of stripe
Stripe
Enable smarter financial features for your users via Stripe
Sync your customers' dataFiber pulls data from your customers' Stripe accounts into your database or cloud storage. Skip months of integration work and begin syncing in minutes.
Logo of stripe
Logo of stripe
Logo of stripe
Logo of stripe
Logo of stripe
Logo of stripe
Logo of stripe
Logo of stripe
Logo of stripe
Logo of stripe
Fiber
postgres-prod
stripe_balance_transactions
stripe_balances
stripe_charges
Your customers' Stripe accounts
Your production database
Meet your new integration toolkit: SQLReplace calls to the Stripe API with an interface you already use. Access the data you need straight from your database.
-- Fetch all the Charges belonging to the Stripe
-- account of a particular user.

SELECT *
FROM fiber.stripe_charge
WHERE account_id = '{user.stripe_id}'
-- Fetch all the Charges belonging to the Stripe
-- account of a particular user.

SELECT *
FROM fiber.stripe_charge
WHERE account_id = '{user.stripe_id}'
Code
CREATE TABLE fiber.stripe_charge (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
amount DOUBLE PRECISION,
balance_transaction TEXT,
billing_details JSONB,
currency TEXT,
customer TEXT,
description TEXT,
disputed BOOLEAN,
invoice TEXT,
metadata JSONB,
payment_intent TEXT,
payment_method_details JSONB,
receipt_email TEXT,
refunded BOOLEAN,
shipping JSONB,
statement_descriptor TEXT,
statement_descriptor_suffix TEXT,
status TEXT,
object TEXT,
amount_captured DOUBLE PRECISION,
amount_refunded DOUBLE PRECISION,
application TEXT,
application_fee TEXT,
application_fee_amount DOUBLE PRECISION,
calculated_statement_descriptor TEXT,
captured BOOLEAN,
created DOUBLE PRECISION,
failure_balance_transaction TEXT,
failure_code TEXT,
failure_message TEXT,
fraud_details JSONB,
livemode BOOLEAN,
on_behalf_of TEXT,
outcome JSONB,
paid BOOLEAN,
payment_method TEXT,
radar_options JSONB,
receipt_number TEXT,
receipt_url TEXT,
refunds JSONB,
review TEXT,
source_transfer TEXT,
transfer TEXT,
transfer_data JSONB,
transfer_group TEXT
)
CREATE TABLE fiber.stripe_charge (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
amount DOUBLE PRECISION,
balance_transaction TEXT,
billing_details JSONB,
currency TEXT,
customer TEXT,
description TEXT,
disputed BOOLEAN,
invoice TEXT,
metadata JSONB,
payment_intent TEXT,
payment_method_details JSONB,
receipt_email TEXT,
refunded BOOLEAN,
shipping JSONB,
statement_descriptor TEXT,
statement_descriptor_suffix TEXT,
status TEXT,
object TEXT,
amount_captured DOUBLE PRECISION,
amount_refunded DOUBLE PRECISION,
application TEXT,
application_fee TEXT,
application_fee_amount DOUBLE PRECISION,
calculated_statement_descriptor TEXT,
captured BOOLEAN,
created DOUBLE PRECISION,
failure_balance_transaction TEXT,
failure_code TEXT,
failure_message TEXT,
fraud_details JSONB,
livemode BOOLEAN,
on_behalf_of TEXT,
outcome JSONB,
paid BOOLEAN,
payment_method TEXT,
radar_options JSONB,
receipt_number TEXT,
receipt_url TEXT,
refunds JSONB,
review TEXT,
source_transfer TEXT,
transfer TEXT,
transfer_data JSONB,
transfer_group TEXT
)
Model definition
About this source
Logo of Stripe
StripeOnline payment processing for internet businesses.stripe.com  ↗
Available resources
Missing a resource? We will build it for you.
Similar sources
OAuth
Need help with OAuth for Stripe?Handshake ↗ is a Next.js app boilerplate that handles your OAuth with Stripe and over 200 other APIs. Setup and deploy within minutes.
Related guides
Logo of stripeIntegrate Stripe using Fiber Fiber makes it easy to access third-party data from Stripe accounts. Get started in just a few minutes.