Countries
Retrieve the countries along with their names and the currencies that are associated with them.
View-Specific Information
Select
The connector uses the SAP Concur Localities v5 API to process filters that refer to Code. The connector processes other filters client-side within the connector.
A query that does not filter on Code returns every country that is known to SAP Concur. A query that filters on Code retrieves the single matching country with additional details.
For example, the connector offloads the processing of the following queries to the SAP Concur APIs:
SELECT * FROM Countries
SELECT * FROM Countries WHERE Code = 'DE'
Aggregate Columns
SAP Concur returns the localized names, currencies, and resource links of a country as JSON arrays that preserve each element's structure. The connector exposes these arrays as string columns that carry the raw JSON payload:
- NamesAggregate: JSON array of the localized country names. Each element carries the name and its langCode.
- CurrenciesAggregate: JSON array of the ISO 4217 currencies associated with the country. Each element carries the currency code.
- URIAggregate: JSON array of the resource links. Each element carries the rel and the href.
Columns
| Name | Type | References | Description |
| Code [KEY] | String | The 2-letter ISO 3166-1 country code. Example: DE | |
| NamesAggregate | String | JSON aggregate of the localized names of the country. Each element carries the name and the language code (langCode). | |
| IsActive | Boolean | Indicates whether the country is active. | |
| CurrenciesAggregate | String | JSON aggregate of the ISO 4217 currencies that are associated with the country. Each element carries the currency code. | |
| NumericCode | Int | The numeric ISO 3166-1 code of the country. Concur returns this column only when the query filters on Code. Example: 276 | |
| Alpha3Code | String | The 3-letter ISO 3166-1 country code. Concur returns this column only when the query filters on Code. Example: DEU | |
| DistanceUnitCode | String | The unit of distance that is used in the country. Concur returns this column only when the query filters on Code. | |
| URIAggregate | String | JSON aggregate of the links that reference the country resource. Each element carries the relation (rel) and the URI (href). |