Session Entity Use the session entity to query and manipulate sessions within Connect. Any user of Connect, whether using ODBC or REST, must first establish a session to perform any […]

Accessing Connect via the New API Gateway Developers can access Xactly Connect data services by using Xactly’s ODBC driver with a number of third party ODBC compliant database access tools. […]

Overview: Date and Time Data Types Summary This article explains the differences found across the date, date time, and time data types supported by Connect and example use cases for […]

UTCDateTime The UTCDateTime function returns the current system zoned date time aligned to UTC. Syntax UTCDateTime() Return Type Zoned_date_time Details Use the CurDateTime function instead of UTCDateTime if you want the current date […]

UTCDate The UTCDate function returns the current system date aligned to UTC. Syntax UTCDate() Return Type Date Details Use the CurDate function instead of UTCDate if you want the current date relative […]

Xactly Connect WSDL and Samples for SOAP APIs With Xactly Connect, a new degree of on-demand application integration is possible. In order to facilitate use of Xactly Connect, this section […]

LookupSplitTotalByOrderCodeItemCode The LookupSplitTotalByOrderCodeItemCode scalar function takes a sales order order_code and item_code as input parameters. It returns the sum of staging.order_item_assignment.split_amount_pct for the given combination. Syntax LookupSplitTotalByOrderCodeItemCode(<string>, <string>) The first […]

LookupOrderStageIdByOrderCodeItemCode The helper lookup function takes string values for order_code and item_code and returns the corresponding xactly.xc_order_stage.order_stage_id if found. Otherwise, the function returns null. Syntax LookupOrderStageIdByOrderCodeItemCode(<string>, <string>) The first parameter […]

LookupPeriodIdByName The LookupPeriodIdByName function returns the period_id for the given period name input parameter. Syntax LookupPeriodIdByName(<string>) Return Type long Details The function returns the xactly.xc_period.period_id for the given period name input parameter. Null […]

LookupPeriodTypeById The LookupPeriodTypeById function returns the xactly.xc_period_type.name value for the corresponding period_type_id given in the input parameter. Syntax LookupPeriodTypeById(<long>) Return Type String Details The function returns null if the period_type_id input parameter is not found in xactly.xc_period_type.period_type_id. Examples eval […]