AvailableBalance
Query the Available Balance in Stripe.
Table Specific Information
Select
Server-Side Query Support
The adapter uses 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 adapter.
- AccountId support the following operator: =.
You can select from Authorizations with the following queries:
SELECT * FROM AvailableBalance WHERE AccountId = 'acct_1Gqj58Ly0qyl5A' SELECT * FROM AvailableBalance WHERE Currency = 'usd' SELECT * FROM AvailableBalance WHERE Livemode = true SELECT * FROM AvailableBalance WHERE Amount > 10000
Columns
Name | Type | References | Description |
Currency | String | The currency of the available balance. | |
Amount | Long | The available amount. | |
SourceTypesCard | Long | The source cards. | |
SourceTypesBankAccount | Long | Amount for bank account. | |
SourceTypesBitcoinReceiver | Long | Amount for Bitcoin Receiver. | |
Livemode | Boolean | Has the value true if the object exists in live mode or the value false if the object exists in test mode. |
Pseudo-Columns
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.
Name | Type | Description | |
AccountId | String | The Id of the connected account to get available balance for |