COMPACT

Removes any null values from an array.

Syntax 

COMPACT(array)

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"message": [
4
"one",
5
null,
6
"three",
7
"four",
8
null
9
]
10
}
11
}

Formula

COMPACT(my_action.message)

Output

1
[
2
"one",
3
"three",
4
"four"
5
]

Sample Actions 

Event transform
COMPACT
Event transform
My Action

Select an action to inspect.

You can also click "Copy actions" and paste them in your Tines story to see how they work.

Was this helpful?