Skip to main content

Other Actions

Execute SQL

Runs an SQL query. (Target ODBC driver must be installed.)

Image

ParameterDescription
SQL DriverODBC / native driver to use (e.g., SQL Server Native Client 11.0).
Save to variableVariable that will hold the query result.
ServerHostname or IP of the database server.
PortListening port (default for SQL Server = 1433).
DatabaseTarget database name.
UsernameLogin user.
PasswordLogin password.
SQL QuerySQL statement (SELECT, INSERT, stored-proc call, …).
EncryptToggle TLS encryption of the session.
Trust Server CertificateAccept self-signed / untrusted certificates.
Trusted ConnectionUse Windows authentication instead of username/password.
Additional ParametersCustom connection string options (param1=a; param2=b; …).

Python Code

Executes the embedded Python code

Image

Start Process

Launches a program/command

Close All Windows – Terminates all open application and Explorer windows in the current session.

Image

ParameterDescription
ForceWhen ON, forcibly terminates windows that do not close gracefully.

Copy File – Duplicates a specified file from a source path to a destination path.

Image

ParameterDescription
Source filePath to the file or directory to copy.
Destination directoryTarget folder.
RecursiveCopy sub-folders and their contents.
ForceOverwrite existing files without prompt.

Create Directory – Generates a new folder at the chosen location, creating any missing parent folders if needed.

Image

ParameterDescription
Path to directoryFolder path to create (recursively).

Move File – Transfers (or renames) a file from its original path to a new path.

Image

ParameterDescription
Source fileFile or directory to move.
Destination directoryTarget folder.

Open Folder – Launches File Explorer focused on the designated directory.

Image

ParameterDescription
Path to directoryFolder path to open in File Explorer.

Remove File – Deletes a specified file from the file system.

Image

ParameterDescription
Path to fileFile or directory to delete.
RecursiveDelete sub-folders and files inside (for directories).

Custom Command – Executes any user-defined command, script, or executable with optional arguments.

Image

ParameterDescription
CommandFull command-line string to execute.