SSIS Components for Stripe

Build 24.0.9062

AvailableBalance

Query the Available Balance in Stripe.

Table Specific Information

Select

Server-Side Query Support

The 本製品 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 本製品.

  • 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
AccountId String The Id of the connected account to get available balance for

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062