Operations
Version 23.4.8843
Operations
Version 23.4.8843
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. |