Cmdlets for SAP Concur

Build 23.0.8839


Retrieve details of locations that are used by Concur and that are valid at the company of the user.

Table Specific Information


The cmdlet uses the SAP Concur APIs to process filters that refer to Id or City_p. The cmdlet processes other filters client-side within the cmdlet. For example, the cmdlet will offload the processing of the following queries to the SAP Concur APIs:

SELECT * FROM Locations WHERE Id = '123456'
SELECT * FROM Locations WHERE City_p = 'London'


Name Type References Description
ID [KEY] String The unique identifier of the resource.
AdministrativeRegion String The administrative region of the location.
Country String The 2-letter ISO 3166-1 country code for the location.
CountrySubdivision String The ISO 3166-2:2007 country subdivision code for the location. Example: US-WA
IATACode String The International Air Transport Association (IATA) airport code of the location.
IsAirport Bool Indicates whether the location is an airport. Format: true or false
IsBookingTool Bool Indicates whether the location is used by the booking tool. Format: true or false
Latitude Decimal The latitude of the geocode for the location.
Longitude Decimal The longitude of the geocode for the location.
Name String The location name. Maximum length: 64 characters
URI String The URI to the resource.


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
City_p String The city name of the location.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839