Scripting in Practice
Use scripting to transform data, control flow execution, set values dynamically, apply custom logic, anonymize data, and more.
- Set and Get a field's value in Mapping using JavaScript and Python
- Set field's value using native SQL (inline SQL)
- Randomization and Anonymization
- Execute any JavaScript or Python code as a Flow
- Execute a Flow conditionally
- Execute a Flow in a loop
- Transform dataset using JavaScript or Python
- Lookup data
- Preprocess source messages
- Store and access an original source message in its native Format
- Serialize data set into specific Format (JSON, XML, etc.)
- Convert string in any Format (XML, JSON, etc.) into data set
- Validate data using JavaScript
- Filter data using simple expression
- Filter and modify rows in a source CSV file
- Execute SQL INSERT, UPDATE, DELETE, or MERGE conditionally
- Execute SQL from JavaScript or Python
- Using JavaScript to load text and binary data from any connection
- Web/HTML scraping with JavaScript and Python
- Use named Connections in JavaScript
- Work with dates
- Sequence generators
- Share parameters between flows
- Important variables
- asText
- How to Get the Home URL of the App