Skip to main content
While Formatters can handle simple data manipulation and formatting, Operations are used for more complex operations in Script.

Operation Basics

Each operation specifies a set of input parameters and output parameters. You can write scripts, triggered by events, to automate message processing. You can invoke the built-in operations to automate many common tasks when processing, from file I/O to working directly with the protocol used by the connector. The available operations are described below. You can also make calls to the API in the same way that you invoke the built-in operations. Use arc:call to invoke an operation.
Operation NameDescription
appSendEmailSends an email using the server information (such as SMTP server, user, and password) from the Alerts section of the Settings page.
cryptoDecryptDecrypts encrypted data.
cryptoEncryptEncrypts data using the AES algorithm.
dbBeginTransactionExecutes the BEGIN TRANSACTION SQL command. Indicates the start point of an explicit SQL transaction.
dbCallExecutes a stored procedure in the database.
dbEndTransactionIndicates the end of an explicit SQL transaction created using dbBeginTransaction, and provides the option to commit or roll back the transaction.
dbListColumnsLists the columns in a table or view on the database server.
dbListTablesLists the tables in the target database server.
dbListViewsLists the views in the target database server.
dbNonQueryExecutes a query against the database.
dbQueryExecutes a query against the database.
encDecodeDecodes an encoded file or string of data.
encEncodeEncodes a file or string of data in a specified encoding format.
excelCloseCloses the readable Excel handle created by excelOpen.
excelGetGets values from an Excel workbook. Commonly used in template files for the Excel connector, but can also be used in dedicated script scenarios such as the Script connector.
excelListSheetsLists the worksheets in a specified Excel workbook.
excelOpenCreates a readable handle for an existing Excel workbook.
flowExecuteExecutes a flow from a script.
httpGetIssues an HTTP GET request for a specific web-based API resource.
httpPostIssues an HTTP POST request to an API endpoint.
httpPutIssues an HTTP PUT request to an API endpoint.
httpUploadIssues an HTTP POST request using multipart/form-data to upload files to an API endpoint compliant with RFC 1867.
integrityResetTamperingAllows users to reset the tamper-evident warning state if log tampering is detected.
jsonCloseCloses the readable JSON handle created by jsonOpen.
jsonDOMGetGets values from a JSON document.
jsonDOMSearchLoops over the elements in an input JSON document.
jsonOpenCreates a readable handle for JSON data from a URI or static text.
messageReadReads the contents of a message item and returns the message body in a single output string.
messageReadLineReads and enumerates over the contents of a message item on a line-by-line basis and returns one line at a time from the message.
sysExecuteExecutes a program or command.
threadSleepInstructs the current thread to sleep for a configured amount of time.
xmlCloseCloses the readable XML handle created by xmlOpen.
xmlDOMGetGets values from an XML document.
xmlDOMSearchLoops over the elements in an input XML document.
xmlOpenCreates a readable handle for XML data from a URI or static text.
zipCompressCompresses files or folders into an archive. (GZIP, JAR, TAR, ZIP)
zipExtractExtracts files and folders from an existing compressed archive. (GZIP, JAR, TAR, ZIP)
zipScanScans a compressed archive for information on the files and directories it contains. (GZIP, JAR, TAR, ZIP)