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 |