Syntax
SORT_NATURAL(array, path)
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') |
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
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.