Excel Add-In for SAP Concur

Build 24.0.9060

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 Description
ID [KEY] String The unique identifier of the resource.
TripId [KEY] 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.

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