Operations
Version 22.0.8483
Operations
Version 22.0.8483
You can invoke the built-in operations to automate many common tasks before or after the Job execution, from file I/O to executing database queries. The available operations are described below. Additionally, you can make calls to the Sync REST API in the same way that you invoke the built-in operations. Use api:call to invoke an operation.
Operation Name | Description |
---|---|
dbListTables | Lists the tables in the database. |
dbListColumns | Lists the columns of a table or view. |
dbQuery | Executes a query against the database. |
dbNonQuery | Executes a query against the database. |
dbCall | Executes a stored procedure in the database. |
dbBeginTransaction | Starts a transaction. |
dbEndTransaction | Commit or Rollback the transaction. |
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. |
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. |