SSIS Components for Stripe

Build 24.0.9062

CashBalance

Get the cash balance for the customer.

Table Specific Information

Select

The 本製品 uses the Stripe API to filter the results by the following column and operator:

  • CustomerId supports the = operator.
  • AccountId supports the = operator.

The rest of the filter is executed client-side within the 本製品.

You can select from CashBalance with the following queries:

    SELECT * FROM CashBalance WHERE CustomerId = 'cus_qwew123'
    SELECT * FROM CashBalance WHERE Livemode = true
    SELECT * FROM CashBalance WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'

Columns

Name Type References Description
CustomerId [KEY] String The Id of the customer.
Available String A hash of all cash balances available to this customer.
Livemode Boolean true if the object is in live mode andfalse if in test mode.
object String String representing the object's type.
ReconciliationMode String The configuration for how funds that land in the customer cash balance are reconciled.
UsingMerchantDefault Boolean A flag to indicate if reconciliation mode returned is the user?s default or is specific to this customer cash balance.

Pseudo-Columns

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

Name Type Description
AccountId String The Id of the connected account to get customer discounts for

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