`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]

Example 2

Sorts by key

 Input 1{2 "animals": [3 {4 "name": "dog"5 },6 {7 "name": "Cat"8 },9 {10 "name": "bear"11 }12 ]13} Formula `SORT(animals, 'name')` Output 1[2 {3 "name": "bear"4 },5 {6 "name": "Cat"7 },8 {9 "name": "dog"10 }11]

Example 3

Sorts by nested key

 Input 1{2 "employees": [3 {4 "name": "Jim",5 "address": {6 "city": "new york"7 }8 },9 {10 "name": "John",11 "address": {12 "city": "dublin"13 }14 },15 {16 "name": "Jane",17 "address": {18 "city": "London"19 }20 }21 ]22} Formula `SORT(employees, 'address.city', include_json_paths: TRUE)` Output 1[2 {3 "name": "John",4 "address": {5 "city": "dublin"6 }7 },8 {9 "name": "Jane",10 "address": {11 "city": "London"12 }13 },14 {15 "name": "Jim",16 "address": {17 "city": "new York"18 }19 }20]

Sample Actions

Transform
SORT NATURAL
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.