SORT_NATURAL

Sorts elements in an array by a property of an element in the array (case-insensitive). Pass a dot-separated path to sort by nested keys.

Syntax 

SORT_NATURAL(array, path, [include_json_paths: FALSE])

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"message": [
4
"north",
5
"South",
6
"east",
7
"west"
8
]
9
}
10
}

Formula

SORT_NATURAL(my_action.message)

Output

1
[
2
"east",
3
"north",
4
"South",
5
"west"
6
]

Sample Actions 

Event Transform
SORT NATURAL
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?