Execute any JavaScript or Python code

When to use this flow type

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

Since the script code in 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 Integrator's sandbox.

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

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