JDBC Driver for SAP Concur

Build 23.0.8839

Opportunities

Gets opportunities for a specified trip or for all trips that fall within a date range.

テーブル固有の情報

Select

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

例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM Opportunities WHERE TripId_p = 'sampleTripId' AND OpportunityType_p = 'Hotel' AND FROMUtc_p = '2018-01-01 13:00:00' AND ToUtc_p = '2018-01-01 13:00:00'  

Columns

Name Type References Description
ID [KEY] String The unique identifier of the resource.
TripId String The trip id of the associated itinerary
EndCityCode String The city code of the destination city where the opportunity is offered
EndDateLocal Datetime The local end date of the location where the opportunity is offered
EndPostalCode String The postal code of the destination location where the opportunity is offered
IsActive Bool Indicates that the opportunity is currently active
StartCityCode String The city code of the originating city where the opportunity is offered
StartDateLocal Datetime The local start date of the location where the opportunity is offered
StartPostalCode String The postal code of the originating location where the opportunity is offered
Type String The type of opportunity
URI String The URI to the resource.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
OpportunityType_p String Comma seperated list of opportunities (Hotel, Car, Air, Rail, Taxi and Service) to get. Do not specify any values to get all opportunities
TripId_p String The trip id
ToUtc_p String The To date in UTC for the date range
FromUtc_p String The From date in UTC for the date range

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