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. |