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

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

Code Editor Basics

To access the code editor, click the Open in Editor button on top of the text field.

By default, the code editor opens in the pop-up window.

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

Code Editor Commands

#	Shortcut	Command
1	Ctrl+F	Search
2	Ctrl+Shift+F	Search & Replace
3	Click the Line:Column	Go to Line
4	Click the language selector	Select color highlighter
5	Click the 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 supported by Etlworks Integrator 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 which can be referenced in the code editor as {{LABEL}}.

Accessing Code Library

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

Using Code Library

Add new code fragment (macro)

Click the Add Macro button to add a new macro.

Enter the code, Title, Label, and other [optional] parameters. Save the macro. Once the macro is saved, the Label cannot be edited anymore.

Edit existing code fragment (macro)

Click the Edit macro button (the pen) to edit the code and other editable parameters.

Delete existing code fragment (macro)

Click the Edit macro button (the pen) to open the macro editor. Click the Delete button 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.