SSIS Components for Stripe

Build 24.0.9062

PendingBalance

Query the available balance in Stripe.

Table Specific Information

Select

You can select from PendingBalance with the following queries:

    SELECT * FROM PendingBalance WHERE Currency = 'usd'
    SELECT * FROM PendingBalance WHERE Livemode = true
    SELECT * FROM PendingBalance WHERE SourceTypesCard > 1000
    SELECT * FROM PendingBalance WHERE SourceTypesBankAccount > 5000
    SELECT * FROM PendingBalance WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'

Columns

Name Type References Description
Currency String The currency of the balance.
Amount Integer The pending amount.
SourceTypesAggregate String The source cards.
SourceTypesCard Integer The source cards.
SourceTypesBankAccount Integer The source Bank Account.
SourceTypesBitcoinReceiver Integer The source 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 pending balance for.

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