Skip to content

Main Navigation Technical

Modelling Guides

Set Instructions

Process Functions

Visual Processes

PowerPoint Addin

Sidebar Navigation

Visual Processes

Introduction

Cheat Sheet

Nodes

Flow Control

Branching

Abort

Branch

Sequence

Switch

Error Handling

Retry

Throw

Try / Catch

Iteration

Break

Continue

Do While Loop

For Each (List)

For Each (Map)

For Loop

While Loop

Timing

Sleep

Throttle

Wait Until Time

Utilities

Cache

Collections

Collection Count

List

List Add Item

List Create

List Difference

List Distinct

List First Item

List From JSON

List Get Item

List Insert Item

List Last Item

List Merge

List

List Range

List Remove Item At

List Set Item

Map

Map Add To (MODLR Formula)

Map Add To

Map Create

Map Flatten

Map From JSON

Map From XML

Map Get Value

Map List Keys

Map List Values

Map Key Exists

Map Merge

Map

Map Remap

Map Remap (Mapping)

Map to List

Map Transform (MODLR Formula)

Cube Operations

General

Cube Create

Cube Delete

Cube Dimension Count

Cube Exists

Cube Get ID

Cube Get Name

Cube Invalidate

Cube List Dimensions

Cube List

Cube Rename

Cube Wipe (List)

Cube Wipe (Map)

Cube Wipe (String)

Query

Cube Get (List)

Cube Get (String)

Cube Update (List)

Cube Update (Map)

Cube Slice (List)

Cube Slice (Map)

Cube Slice (String)

Properties

Cube is Formula Evaluating

Cube is Logging

Cube Set Formula Evaluation

Cube Set Logging

Dimension & Hierarchy

Dimension

Dimension Create Multiple

Dimension Create

Dimension Delete

Dimension Element Parents

Dimension Exists

Dimension has Element

Dimension Rename

Dimension Wipe

Hierarchy

For Each Child in Hierarchy

For Each Parent in Hierarchy

For Each Root in Hierarchy

For Element Range

Hierarchy Create

Hierarchy Delete

Hierarchy Exists

Hierarchy has Element

Hierarchy has Root Element

Hierarchy Insert Element

Hierarchy Wipe

Alias

Alias Create

Alias Delete

Alias Exists

Alias Get

Alias Set

Alias Wipe

Mapping

Mapping Delete

Mapping Exists

Mapping Wipe

String Operations

String Format

String

String Template

String Template (Map)

To JSON String

To String

Comparison

String Contains

String Ends With

String Equals

String is Alpha

String is Alphanumeric

String is Digit

String Is Null or Empty

String Is Null or Whitespace

String is Numeric

String Matches Regex

Starts With

Manipulation

String Concat

String Join

String Pad Left

String Pad Right

String Repeat

String Replace

String Split

String Substring

String to Lower

String to Title

String to Upper

String Trim

Information

String Index Of

String Last Index Of

String Length

Math

Absolute

Add

Ceil

Clamp

Divide

Exp

Floor

Max

Min

Modulo

Multiply

Power

Round

Sign

Square Root

Subtract

Logic

And

Boolean

Equals

Greater

Greater or Equal

Less

Less or Equal

Negate

Not Equals

Or

Xor

I/O

Files & Directories

Directory Create

Directory Delete

Directory List

File Copy

File Delete

File Exists

File Move

File Read

File Write

Archiving

Archive

Extract Archive

CSV

CSV Reader

CSV Writer Close

CSV Writer

Web & APIs

Basic Auth

Bearer Auth

FTP Connection

FTP Directory

FTP Download

FTP Upload

HTTP Form Request

HTTP Request

Integration

OAuth 1.0 Auth

Send Email

Datasource

Datasource Alter Table

Datasource Batch Flush

Datasource Batch Create

Datasource Batch Insert (Map)

Datasource Batch Insert (List)

Datasource Create Table

Datasource Execute

Datasource Mapping

Datasource Paginated Query

Datasource Query

Datasource Query (Stream)

S3

S3 Connection

S3 Download File

S3 List Objects

S3 Upload File

Date & Time

Date Time Adjust

Date Time Component

Date Time Difference

Date Time Format

Date Time Parse

Date Time Range

Date Time UTC Now

Number

Double

Integer

Format Number

Random

Random Double

Random Integer

Random UUID

Debugging

Assert

Logger

Log Level

Note

Stopwatch

Custom

Custom Process

MODLR Formula

Variables & Arguments

Argument

Variable Accumulate

Variable List Get Item

Variable Map Get Value

Variable

Variable Set

Model Variable

Model Variable Set

Secret

Encryption / Encoding

AES-256-CBC Decrypt

AES-256-CBC Encrypt

Base64 Decode

Base64 Encode

Hash String

HMAC

OTP

Secure Random String

URL Decode

URL Encode

Graph

Graph Output

Graph Status

Iterable Subprocess

Subprocess

Processes

Process Execute

Process Fork

Process Join

Visual Process Execute

Visual Process Fork

Visual Process Join

Cards

Card Execute

Users

Get User By Email

Get User By Id

Boolean

Pure

Outputs a constant boolean value

Pure Function

Yes

Execute Inputs

Execution

INPUT

Execution Input.

Data Outputs

Value

OUTPUTboolean

The constant boolean.

Multiple

Settings

Boolean

BOOLEAN

Default:

Debug

STRING

Break on node when executing.

Default: No

Options:

NoBeforeInputsBeforeProcessingAfterProcessing

Last updated:

Pager

Previous pageAnd

Next pageEquals

Copyright © 2025 MODLR