SSIS Components for SAP Concur

Build 24.0.9060

Locations

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

Table Specific Information

Select

The component uses the SAP Concur APIs to process filters that refer to Id or City_p. The component processes other filters client-side within the component. For example, the component 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'

Columns

Name Type 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 Boolean Indicates whether the location is an airport. Format: true or false
IsBookingTool Boolean Indicates whether the location is used by the booking tool. Format: true or false
Latitude String The latitude of the geocode for the location.
Longitude String The longitude of the geocode for the location.
Name String The location name. Maximum length: 64 characters
URI String The URI to the resource.

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