Overview - CData Sync Documentation

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