AvailableBalance
Returns the available balance in Stripe.
View-Specific Information
SELECT
The provider 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 provider.
| Column | Supported Operators |
| AccountId | = |
You can select from AvailableBalance 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 amount for card sources. | |
| SourceTypesBankAccount | Long | The amount for bank account sources. | |
| SourceTypesBitcoinReceiver | Long | The amount for Bitcoin receiver sources. | |
| Livemode | Boolean | Indicates whether the object exists in live mode. The value is true in live mode and false in test mode. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get the available balance for. |