Execute any JavaScript or Python code

When to use this Flow type

In the Etlworks Integrator, it is possible to execute any JavaScript or Python code as a separate Flow.

Since the script code in the Etlworks Integrator has full access to the ETL engine, it is possible to create and execute very complex scripts, which work with the files and framework objects outside of the Etlworks Integrator's sandbox.

Read about objects, functions, and methods available in Script Flow.

Create Flow

Step 1. Start creating a Flow by typing script into the Select Flow Type box.

Step 2. Continue by entering the JavaScript or Python code into the Parameters tab.

Read how to switch between JavaScript and Python.

Step 3. Add optional named Connections that can be referenced and used from the code.

An example of the JavaScript code which is using named Connection Files. 

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

• 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 JavaScript code.