Operations

Version 24.2.8969


Operations

Version 24.2.8969


In CData Sync, 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 in the table below. In addition, you can make calls to the Sync REST API in the same way that you invoke the built-in operations. Use the api:call keyword 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 Commits or rolls back the transaction.
fileCopy Copies a file or directory to the path that is specified.
fileCreate Creates a text file and, optionally, writes to it.
fileDelete Deletes a file or a directory.
fileListDir Lists the files and the directories in the specified path.
fileMakeDir Creates the directory that is specified by the path.
fileMove Moves a file or a directory to the path that is specified.
fileRead Reads a text file and pushes out the data.
fileReadLine Reads a text file and pushes out the data.
fileWrite Writes encoded data to a file.
httpGet Gets a document from the web by using the HTTP GET method.
httpPost Posts data to a URL by using the HTTP POST method.
httpPut Puts a web document by using the HTTP PUT method.