TDV Adapter for SAP Concur

Build 22.0.8462

Trips

Query all the trips.

Table Specific Information

Select

The adapter uses the SAP Concur APIs to process filters that refer to any combination of TripStartDate, TripEndDate, and ModifiedDate. The adapter processes other filters client-side within the adapter.

SELECT * FROM Trips WHERE TripStartDate='2018-01-01 10:00:00'  AND TripEndDate ='2018-03-01 10:00:00'  AND ModifiedDate = '2018-02-01 10:00:00'

Columns

Name Type References Description
Id [KEY] String The id of the trip.
TripName String The name of the trip.
TravelerFirstName String The first name of the traveler.
TravelerLastName String The last name of the traveler.
Passengers String A comma separated list of passengers.
TripStartDate Datetime The start date of the trip.
TripEndDate Datetime The end date of the trip.
ModifiedDate Datetime The date when the trip was last modified.
RecordLocator String The record locator of the trip.
LoginId String The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.
IsCanceled Boolean The status of the trip

The default value is false.

Pseudo-Columns

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
CreatedAfterDate Datetime Date for when the trip was created. The query string will return trips created on or after this date.
CreatedBeforeDate Datetime Date for when the trip was created. The query string will return trips created on or before this date.
BookingType String The trip includes at least one booking of this type.

The allowed values are Air, Car, Dining, Hotel, Parking, Rail, Ride.

IncludeVirtualTrip Boolean Show virtual trips. Virtual trips are segments booked offline through the Travel Request product.
IncludeGuestBookings Boolean Indicates whether to include guest bookings.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462