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 connector 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 connector.
- Id supports the following operator: =.
- AccountId supports the following operator: =.
The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve a Country Spec by specifying its Id:
SELECT * FROM CountrySpecs WHERE Id = 'MyCountrySpecsId'
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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description | |
AccountId | String | The Id of the connected account to get country specs for |