Search

Operations

Version 21.0.8126

Operations

Version 21.0.8126

While Formatters are used to handle simple data manipulation and formatting, Operations are used for more complex operations within ArcScript.

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. Additionally, you can make calls to the API in the same way that you invoke the built-in operations. Use arc:call to invoke an operation.

Operation Name Description
dbBeginTransaction Start the transaction.
dbCall Executes a stored procedure in the database.
dbEndTransaction Commit or rollback the transaction.
dbListColumns Lists the columns of a table or view.
dbListTables Lists the tables in the database.
dbListViews Lists the views in the database.
dbNonQuery Executes a query against the database.
dbQuery Executes a query against the database.
excelClose Close an Excel connection.
excelCreate Create a new Excel worksheet.
excelDelete Delete the row by RowId in an Excel worksheet.
excelGet Queries the specified Excel worksheet.
excelGetHeader Describe the specified Excel worksheet.
excelInsert Append a record to an Excel sheet.
excelListSheets Lists the worksheets in a specified Excel workbook.
excelOpen Open an existing Excel workbook.
excelUpdate Update cells in an Excel worksheet.
fileCopy Copies a file or directory to the path specified.
fileCreate Creates a text file, and optionally writes to it.
fileDelete Deletes a file or directory.
fileListDir Lists the files and directories in the specified path.
fileMakeDir Creates the directory specified by the path.
fileMove Moves a file or directory to the path specified.
fileRead Reads a text file and pushes the data out.
fileReadLine Reads a text file and pushes the data out.
fileReceive Receives a file from the request.
fileWrite Write encoded data to a file.
httpGet Get a document from the Web using the HTTP GET method.
httpPost Post data to a URL using the HTTP POST method.
httpPut Put a Web document using the HTTP PUT method. (Usually requires authentication.)
httpReceive Receive files included in the HTTP request. The file content is sent using the input type=file element and encoded as multipart form data.
httpUpload Execute an HTTP post with multipart form data to upload files to Web servers compliant with RFC1867 (INPUT TYPE=FILE).
jsonClose Stop reading or writing a JSON document.
jsonDOMGet Get values from a JSON document.
jsonDOMSearch Loop from a JSON document.
jsonOpen Begin reading or writing a JSON document.
sysExecute Executes a program or command.
xmlClose Stop reading or writing an XML document.
xmlDOMGet Get values from an XML document.
xmlDOMSearch Loop from an XML document.
xmlOpen Begin reading or writing an XML document.
xmlPut Puts values to an XML document.
zipCompress Compress files into an archive. (GZIP,JAR, TAR, ZIP)
zipExtract Extract files from an existing archive. (GZIP, JAR, TAR, ZIP)
zipScan Scan an archive for information on the files it contains. (GZIP,JAR, TAR, ZIP)