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 | 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 | Date | The URL-encoded start date (in Coordinated Universal Time, or UTC) for the trip. Format: YYYY-MM-DD. If no query parameters are provided, the start date is set to today?s date - 30 days. The request will only return trips that are ongoing during the provided dates, either starting on the date, or starting before the date and ongoing during the provided date. |
| TripEndDate | Date | The URL-encoded UTC end date for the trip. Format: YYYY-MM-DD. If no query parameters are provided, the end date is set to today?s date + 12 months. The request will only return trips that are ongoing during the provided dates, either ending on the date, or starting before the date and ongoing during the provided date. |
| ModifiedDate | Date | The last modified UTC date of the trips and their associated bookings. This query string will return only the trips where the trip or any of its associated bookings have a last modified date that is greater or equal to the supplied time. The provided date/time can be anytime between now and the first date of trip creation in the database. The format is either the date or the date and time combined. |
| TripStatus | String | The status of the trip. One of the following: Confirmed; Ticketed; Canceled; Proposal; Booked Proposal. |
| 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. |
| IncludeCancelledTrips | Boolean | Whether or not the canceled trips should be included in the response
The default value is false. |
| BookingType | String | The trip includes at least one booking of this type. |
| IncludeVirtualTrip | Boolean | Show virtual trips. Virtual trips are segments booked offline through the Travel Request product. |
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 | Date | Date for when the trip was created. The query string will return trips created on or after this date. |
| CreatedBeforeDate | Date | Date for when the trip was created. The query string will return trips created on or before this date. |