Trips
Query all the trips.
テーブル固有の情報
Select
connector はSAP Concur API を使用して、TripStartDate、TripEndDate、ModifiedDate の任意の組み合わせを参照するフィルタを処理します。connector はクライアント側で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
デフォルト値は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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |