Execute any JavaScript or Python code

When to use this Flow type

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

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

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

Process

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, Etlworks will execute this JavaScript code.