Connect

ToOffsetTime

ToOffsetTime The ToOffsetTime function converts the input parameter to the offset_time data type. Syntax ToOffsetTime(<string>|<date_time>|<offset_date_time>|<zoned_date_time> [, <format_mask>] )   The optional format parameter defines the date time formatting mask to use when […]

Show Email

Show Email The SHOW EMAIL command shows metadata for the specific email domain object. The command returns a one row result set. Syntax show email <email_name>;  Parameters Parameter Description email_name (Required) Specifies […]

Show Emails

Show Emails The SHOW EMAILS command returns a result set listing all email domain object in the Connect environment. Syntax show emails;  Parameters None. Details   The command returns the following result […]

WithZoneSameInstant

WithZoneSameInstant Use the WithZoneSameInstant function to convert a date time value from one timezone to another. Syntax WithZoneSameInstant(<date>|<date_time>|<instant>|<offset_date_time>|<zoned_date_time> [,<string>]) The second string input parameter takes a Java zone_id or zone_name. Refer to […]

WithZoneSameDateTime

WithZoneSameDateTime Use the WithZoneSameDateTime function to add a timezone id or name to a date/date time value. Syntax WithZoneSameDateTime(<date>|<date_time>|<instant>|<offset_date_time>|<zoned_date_time> [,<string>]) The second string input parameter takes a Java zone_id or zone_name. […]

Sleep

Sleep Summary Use the sleep command to pause Connect processing for the given number of seconds. Processing will continue after the sleep period ends. The command can be used within a STEP […]

Incent Reset

Incent Reset Summary Invoke the incent reset command to reset Incent’s credit and incentive calculated results. Warning: To avoid conflicts in Incent’s processing queue, do not use the incent reset command […]

LookupBatchIdByName

LookupBatchIdByName Summary The LookupBatchIdByName function takes a batch name string input parameter and returns the corresponding xactly.xc_user_batch.batch_id. Syntax LookupBatchIdByName(<string>) Return Type long Details Null is returned if the function cannot find a […]

IsValidPeriodDateWithBatchName

IsValidPeriodDateWithBatchName Summary The IsValidPeriodDateWithBatchName function checks whether the batch name input parameter falls between the start and end dates for the monthly period derived from the date input parameter. The function […]

IsDateTimeFormat

IsDateTimeFormat Summary The IsDateTimeFormat function verifies if the given input string conforms to the given date time formatting mask. IsDateTimeFormat does not check the data type of the given value. Use TypeNameOfinstead. Syntax IsDateTimeFormat(<string>, <format_mask>) Return […]