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

Table Specific Information

Select

The driver uses the SAP Concur APIs to process filters that refer to any combination of TripId_p, OpportunityType_p, FromUtc_p, and ToUtc_p. The driver processes other filters client-side within the driver.

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'  

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

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