- Download the latest release here
- Unzip the archive and open a shell (cmd, pwsh, powershell) of your choice in that directory
.\edr.exe run scl "Print 'Hello world'"
To run a Sequence from a file:
PS > .\edr.exe run .\sequence.scl
From the command line:
PS > .\edr.exe run scl "- <version> = GetApplicationVersion `n- Print <version>"
To display the available commands and parameters when running edr, use the
PS > .\edr.exe --help
To see a list of all the
Steps available, use the
PS > .\edr.exe steps # To filter by name or connector, add a filter as the first argument PS > .\edr.exe steps file
EDR uses a connector system to extend functionality to various applications.
By default, EDR comes with the
All the available connectors can be seen in the
To manage connectors, use the
PS > .\edr.exe connector # To list the connectors currently installed, use list PS > .\edr.exe connector list # To list all the connectors available in the registry, use find PS > .\edr.exe connector find # To install a connector, use add PS > .\edr.exe connector add Reductech.EDR.Connectors.Sql
Some Examples to Try
Convert JSON To CSV
FileRead 'C:/data.json' | FromJson | ToCSV | FileWrite 'C:/data.csv'
Remove duplicates from CSV
FileRead 'C:/data.csv' | FromCSV | ArrayDistinct <> | ToCSV | FileWrite 'C:/data-distinct.csv'
Remove rows with duplicate Ids from CSV
FileRead 'C:/data.csv' | FromCSV | ArrayDistinct (From <> 'Id') | ToCSV | FileWrite 'C:/data-distinct.csv'
To install in VS Code:
- Open the Extensions sidebar (
Ctrl + Shift + X)
- Search for Reductech
- Click on SCL and select Install
The extension currently supports:
- Syntax highlighting
- Hover help
- Code completion for step names and parameters
- Error Diagnostics
Run SCL from VS Code (F5)
To run SCL in VS Code using
F5, the EDR path needs to be set
in the settings.
- Go to
File > Preferences > Settings
- Navigate to
Extensions > Reductech SCL
Or, add the following token to your
settings.json with a full
path to the EDR executable: