Operations


Operations


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.