Retrieves the administrative regions of a country subdivision, or the details of a single administrative region by Id.

View-Specific Information

Select

This view is backed by the SAP Concur Localities v5 API, which does not expose an endpoint that returns every administrative region. A query against AdminRegions must therefore filter on either the Id column, or on both the Country and the CountrySubdivision columns.

The connector uses the SAP Concur APIs to process filters that refer to Id, Country, or CountrySubdivision. The connector processes other filters client-side within the connector.

For example, the connector offloads the processing of the following queries to the SAP Concur APIs:

SELECT * FROM AdminRegions WHERE Id = '3b353fe3-5e4d-4a7a-8230-8eb44db254d0'
SELECT * FROM AdminRegions WHERE Country = 'US' AND CountrySubdivision = 'US-TX'

Aggregate Columns

SAP Concur returns the localized names and resource links of an administrative region 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 administrative region names. Each element carries the name and its langCode.
• URIAggregate: JSON array of the resource links. Each element carries the rel and the href.

Columns