SSIS Components for Stripe

Build 24.0.9062

CountrySpecs

Query the available Country Specs in Stripe.

Table Specific Information

Country Specs can be used when an account is created.

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

  • Id supports the following operator: =.
  • AccountId supports the following operator: =.

You can select from CountrySpecs with the following queries:

    SELECT * FROM CountrySpecs WHERE Id = 'MyCountrySpecsId'
    SELECT * FROM CountrySpecs WHERE AccountId = 'acct_1Gqj58Ly0qyl5A'
    SELECT * FROM CountrySpecs WHERE DefaultCurrency = 'usd'

Columns

Name Type References Description
Id [KEY] String The ISO Country code for this country.
SupportedBankAccountCurrenciesAggregate String Currencies that can be accepted in the specific country.
SupportedPaymentCurrenciesAggregate String Currencies that can be accepted in the specified country.
SupportedPaymentMethodsAggregate String Payment methods available in the specified country. You will need to enable BitCoin and ACH payments on your account for those methods to appear in this list.
VerificationFieldsAggregate String Lists the types of verification data needed to keep an account open. Includes 'minimum' fields, which every account must eventually provide, as well as additional fields, which are only required for some merchants.
SupportedTransferCurrenciesAggregate String Countries that can accept transfers from the specified country.
DefaultCurrency String The default currency for this country.

Pseudo-Columns

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

Name Type Description
AccountId String The Id of the connected account to get country specs for

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