Excel Add-In for SAP Concur

Build 24.0.9062

Trips

Query all the trips.

テーブル固有の情報

Select

本製品 はSAP Concur API を使用して、TripStartDate、TripEndDate、ModifiedDate の任意の組み合わせを参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062