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 add-in uses the SAP Concur APIs to process filters that refer to Id, Country, or CountrySubdivision. The add-in processes other filters client-side within the add-in.

For example, the add-in 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 add-in 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