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 

Transform
COMPACT
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?