Skip to main content

Peliqan

Try for free
Request a demo

Stripe

Number of successful and failed transactions

SQL query for Stripe

Get the number of successful and failed transactions from the payment_intents table.

SELECT status, COUNT(*) as count FROM payment_intents GROUP BY status

Try this query now in Stripe

Stripe data model

Stripe
Products

View 9 columns
IdString
NameString
TypeString
ActiveBoolean
ObjectString
CreatedInteger
UpdatedInteger
LivemodeBoolean
Default_priceString
Stripe
Balance Transactions

Stripe
Charges

Stripe
Customers

Stripe
Disputes

Stripe
Events

Stripe
Files

Stripe
Invoices

Stripe
Payouts

Stripe
Prices

Stripe
Payment Intents

Stripe
Refunds

Stripe
Shipping Rates

Stripe
Subscriptions

Stripe
Sub Accounts

Stripe
Subscription Items

Stripe
Balance Payout Reconciliation

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed