How to execute code in JavaScript or Python

Overview

Etlworks includes a dedicated flow type for executing code in JavaScript or Python.

Process

In Flows

Step 1. Create a new Execute JavaScript or Python code Flow.

Step 2. Select the Parameters tab. 

Step 3. The default language is JavaScript. If you are going to use JavaScript, you can skip step 3; otherwise, click Open in editor.

Click language and choose Python.

Step 4. Enter the JavaScript or Python code in the Script field. 

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

Here is an example of a JavaScript code that is using named Connection Files:

Step 6. Save the Flow and execute it manually.

In Schedules

Step 7. Schedule the Flow to be executed periodically.