CountrySpecs
Returns the country specifications available in Stripe.
View-Specific Information
You can use CountrySpecs when you create an account.
SELECT
The add-in uses the Stripe API to filter the results by the following columns and operators. Other filters are executed client-side within the add-in.
| Column | Supported Operators |
| Id | = |
| AccountId | = |
You can select from CountrySpecs using 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 | The currencies available for bank accounts in the specified country. | |
| SupportedPaymentCurrenciesAggregate | String | The currencies accepted for payments in the specified country. | |
| SupportedPaymentMethodsAggregate | String | The payment methods available in the specified country. You must 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. | |
| SupportedTransferCountriesAggregate | String | Countries that can accept transfers from the specified country. | |
| DefaultCurrency | String | The default currency for this country. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AccountId | String | The Id of the connected account to get country specs for. |