Opportunities
Gets opportunities for a specified trip or for all trips that fall within a date range.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to process filters that refer to any combination of TripId_p, OpportunityType_p, FromUtc_p, and ToUtc_p. The add-in processes other filters client-side within the add-in.
For example, the following query is processed server side:
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
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 | |
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 |