There is no excerpt because this is a protected post.

JsonPath The JsonPath function traverses a JSON string and returns a specified value from within the JSON text.  The value returned is returned as a string. Syntax JsonPath(<string>, <json path>) […]

Incent Upload Currency Rates Summary The incent upload currency rates command allows developers to create and maintain currency exchange rates within the Incent application. The command transfers data from staging.currency_rate table into Incent’s xactly schema tables. Currency Rates […]

UntarFile Summary Use the UntarFile function to extract the contents of a tar file to the Connect SFTP server file system. Syntax TarFile(FilePath='<path to source tar file>’,     Destination='<target untar directory>’      [, Overwrite=<true|false>]) […]

TarFile Summary Use the TarFile function to create a tar file archive from files and directories found on the Xactly SFTP server file system. Syntax TarFile(FilePath='<full-path-to-source-file>’ or Directory='<source-directory>’,     Destination='<target-gzip-file-path>’     [, Overwrite=<true|false>] […]

GunzipFile Summary Use the GunzipFile function to uncompress the contents of a GZIP file located on the Connect SFTP file system. The GZIP compressed file can contain only a single archive file, which may […]

Create Iterator Summary The CREATE ITERATOR command allows iteration over a result set. An iterator sets variable values for each row in the <command> result set and then invokes the given pipeline or step.  The variable […]

ToQwerty ToQwerty is a data scrubbing function that removes all non-QWERTY characters from a string. Syntax ToQwerty(<input_string> [,<retain_chars>]) Input_string is the source string to modify. Retain_chars appends to the list of characters to keep. […]

DiffTime DiffTime computes the difference between two dates or date times for a given time unit of measure. Syntax DiffTime(<input_1>, <input_2>[, <unit_of_measure>]) Where input_1 and input_2 are of one of […]

CountWeekdays The CountWeekdays function returns the number of weekdays between two date input parameters. Syntax CountWeekdays(<input_1>, <input_2>) Where input_1 and input_2 are of one of the following data types: instant […]