Query Balance History in Stripe.
Table Specific Information
Server-Side Query Support
The connector will use the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client side within the connector.
- Id, Amount, Created, Currency, Source, and Type support the following operators: >, >=, <, <=, =.
The following query gets all records from BalanceHistory view (the provider supports all columns to be used as criteria in the Where clause of Select statement, as long as SupportEnhancedSQL is set to True):
SELECT * FROM BalanceHistory
You can also filter balance transactions that were paid out on the specified payout ID.
SELECT * FROM BalanceHistory WHERE Payout = '123'
|Id [KEY]||String||The Id of the balance transaction.|
|Amount||Integer||Gross amount of the transaction, in cents.|
|AvailableOn||Datetime||The date the net funds of the transaction will become available in the Stripe balance.|
|Created||Datetime||The datetime of creation.|
|Currency||String||The currency of the transaction.|
|Description||String||The transaction description.|
|Fee||Integer||Fees (in cents) paid for this transaction.|
|FeeDetailsAggregate||String||The fee details.|
|Net||Integer||Net amount of the transaction, in cents.|
|Source||String||The Stripe object this transaction is related to.|
|SourcedTransfers||String||The transfers (if any) for which source is a source_transaction.|
|Status||String||If the net funds of the transaction are available in the Stripe balance yet. Either available or pending.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|Transfer||String||For automatic Stripe transfers only, only returns transactions that were transferred out on the specified transfer Id.|
|Payout||String||For automatic Stripe payouts only, only returns transactions that were payed out on the specified payout ID. .|
|AccountId||String||The Id of the connected account to get balance history for|