Execute shell (command line) script

This functionality is only available for the self-hosted and selected customers on dedicated instances. Please contact Etlworks support for more details.

When to use this Flow type

The Execute command-line script Flow executes a shell script using the designated command line interpreter of the host operating system: sh on Linux and cmd on Windows.

You can use flow variables referenced as {VARNAME} anywhere in the code.

Other cases:

• Running Python programs using the Python installed in the host computer.
• Accessing resources not available from the Etlworks Integrator sandbox.

Create Flow

Step 1. Start creating a Flow by typing command line into the Select Flow Type box:

Step 2. Continue by entering the script code into the Parameters tab.

Step 3. Enter other parameters if needed (optional):

• Success mask: enter string or a part of the string which, if found, will indicate that the Flow executed successfully.
• Error mask: enter string or a part of the string which, if found, will indicate that the Flow executed with error.
• Keep log: if option is selected (default), the system will add the log produced by executing the script to the Flow log.
• Script: the JavaScript or Python program that will be executed before executing a command-line script. You can use it to set the global variables that can be referenced as {parameters} in the command line script. You can also use it to conditionally disable the command-line script Flow.
• On Exception: by default, any error causes a halt of execution. When ignore is selected, the errors will be ignored and execution will continue. Read how to configure the Flow to ignore all or specific exceptions.
• Exception Mask: you can specify what errors should be ignored and still halt the execution for all other errors. Enter part or all of the exception string. This field works only when the Ignore On Exception option is selected.
• Execute if Error: if this option is selected and an error occurs, the Etlworks Integrator will execute this script code.

Step 4. Optionally enter flow variables as key-value pairs.