Trips
Query all the trips.
Table Specific Information
Select
The connector uses the SAP Concur APIs to process filters that refer to any combination of TripStartDate, TripEndDate, and ModifiedDate. The connector processes other filters client-side within the connector.
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. |