Form Utils

The Form Utils Worker provides a range of tools including database interactions, PDF generation and FTP/SFTP requests.

Worker Configuration

All properties are optional.

Property	Type	Description
checkSQLForLiteralValues	Boolean	Enables checks for dangerous literal rather than parametrised strings in SQL expression. Default: true
transactionTimeout	Integer	Timeout for transactions in milliseconds. Default 60000
transactionExpiryTaskPeriod	Integer	Transaction expiry check frequency. Default: 30000
maxClusterLockLifetime	Integer	Maximum cluster lock life. Default: 60000
clusterLocksExpiryTaskPeriod	Integer	Cluster lock lifetime exceeded check frequency. Default 1800000
queryTimeout	Integer	The period of time it takes in seconds for a query to timeout. Default 120

{ "name": "formutils", "instances": 1, "threadsPerInstance": 10 }

Includes executeSQL and support for transactions.

The data importer lets you import data from a CSV file into custom database tables.

Populate the options values of list-type form fields.

Removes words from the suplied text if they are found in iCM's swerword dictionary.

Methods that allow you to run a series of commands against a remote FTP server

This method generates and returns an ID in the same format as the business keys used in workflow processes.

Attempts to acquire a named cluster-wide lock.

This function exposes the functionality of the MessageDigest and Mac classes to the caller via a consistent JSONRPC interface.

These functions work with the site user password rules set up in iCM.

A method that allows you to generate a PDF from HTML or Handlebars and store it in the filestore.

Releases named cluster-wide locks

Checks the supplied string for spelling mistakes and returns an array of suggestions for each spelling mistake found.