Using Code Editor and Code Library to write scripts in SQL, JavaScript, Python, and XSLT

The Code Editor is available anywhere in the Etlworks Integrator, where the user can enter SQL, JavaScript, Python, or XSLT code.

Code Editor Basics

To access the Code Editor, click Open in Editor on top of the text field.

By default, the Code Editor opens in a pop-up window.

It then can be extended to the full screen by clicking Enter full screen and collapsing back to the pop-up window by clicking Exit full screen.

Code Editor commands

Below are some Code Editor commands and their shortcuts:

#	Shortcut	Command
1	Ctrl+F	Search
2	Ctrl+Shift+F	Search & Replace
3	Click Line:Column	Go to Line
4	Click language selector	Select color highlighter
5	Click Enter or Exit Full Screen	Enter or exit full-screen mode

 

Code Library and Macros

The Code Library contains shared and reusable fragments of code in all Etlworks Integrator-supported languages: SQL, JavaScript, Python, shell, and others.

Any user with permission to create and edit Flows can access and update the Code Library.

Macro

Macro is a reusable fragment of code that can be referenced in the Code Editor as {{LABEL}}.

Accessing the Code Library

The Code Library can only be accessed from the Code Editor. You can hide the Code Library by turning off Macros Library at the bottom of the code editor popup.

Using the Code Library

Add new code fragment (macro)

Click Add Macro to create a new macro.

Enter the code, Title, Label, and other (optional) parameters and save the macro. Once the macro is saved, the Label cannot be edited anymore.

Edit existing code fragment (macro)

Click 🖊️ to edit the code and other editable parameters.

Delete existing code fragment (macro)

Click 🖊️ to open the macro editor and click Delete to delete the macro.

Search code fragments 

You can filter existing macros by name, tag, description, and label.

Copy macro to editor

Highlight macro and click Copy macro to editor.

Copy macro body to editor

Highlight macro and click Copy macro body to editor.