AvailableBalance
Query the Available Balance in Stripe.
Table Specific Information
Select
Server-Side Query Support
The server 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 server.
- 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 |