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