Any #
Syntax: #
Any(array[])
Returns true if there are one or more elements in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array to be checked. |
Returns: #
bool
Any($.Courses[*])
Avg #
Syntax: #
Avg(array[])
Returns the average of the elements in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array of numbers to be averaged. |
Returns: #
decimal
Avg($.Courses[*].Price)
ChunkBy #
Syntax: #
ChunkBy(array[], size)
Chunks the elements in the array[] into batches of the provided size. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array to be chunked. |
| size | int | The size of each chunk. |
Returns: #
ChunkBy($.Courses[*], 5)
Count #
Syntax: #
Count(array[])
Returns the number of elements in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array whose elements are to be counted. |
Returns: #
int
Count($.Courses[*])
Distinct Count #
Syntax: #
DCount(array[])
Returns the distinct number of elements in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array whose distinct elements are to be counted. |
Returns: #
int
DCount($.Courses[*])
Empty #
Syntax: #
Empty(param1)
Returns true if param1 is null or empty. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| param1 | string | The string to be checked. |
Returns: #
bool
Empty(”)
Returns `true`.
First #
Syntax: #
First(array[])
Returns the first element in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array from which the first element is to be returned. |
Returns: #
object
First($.Courses)
First #
Syntax: #
First(array[], param1, selector)
Returns the first element in the array[] that matches the filter expression and returns the object or value of the selector expression. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array to be searched. |
| param1 | string | The filter expression. |
| selector | string | The selector expression. |
Returns: #
object
First($.Courses[*], @.Name = ‘Maths’)
First($.Courses[*], @.Name = ‘Maths’).id
GroupBy #
Syntax: #
GroupBy(array[], selector)
Groups the elements in the array[] by the selector. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array to be grouped. |
| selector | string | The property to group by. |
Returns: #
object: {‘Key’:123, ‘Group’:[]}
GroupBy($.Courses, ‘Category’)
In #
Syntax: #
In(array[], param1)
Returns true if param1 is in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array to be searched. |
| param1 | object | The object to be checked. |
Returns: #
bool
In(‘Maths’, $.Courses[*].Name)
IsEmpty #
Syntax: #
IsEmpty(array[], param2)
Returns the original array if it is not empty. If the array is empty, returns the specified return value. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | array | The array to be evaluated for emptiness |
| param2 | object | The value to be returned if the array is empty |
Returns: #
array or object
IsEmpty([], ‘Array is empty’)
Returns `’Array is empty’` if the input array is empty.
IsEmpty([‘Course 1’, ‘Course 2’], ‘Array is empty’)
Returns `[‘Course 1’, ‘Course 2’]` if the input array is not empty.
Join #
Syntax: #
Join(array[], param2)
Joins the elements in the array[] using param2 as the separator and returns a string. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array of strings to be joined. |
| param2 | string | (Optional) The separator string. |
Returns: #
string
Join($.Courses[*].Name, ‘, ‘)
Last #
Syntax: #
Last(array[])
Returns the last element in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array from which the last element is to be returned. |
Returns: #
object
Last($.Courses)
Last #
Syntax: #
Last(array[], param1, selector)
Returns the last element in the array[] that matches the filter expression and returns the object or value of the selector expression. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array to be searched. |
| param1 | string | The filter expression. |
| selector | string | The selector expression. |
Returns: #
object
Last($.Courses[*], @.Name = ‘Maths’)
Last($.Courses[*], @.Name = ‘Maths’).id
Max #
Syntax: #
Max(array[])
Returns the largest element in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array from which the maximum value is to be returned. |
Returns: #
object
Max($.Courses[*].Price)
Min #
Syntax: #
Min(array[])
Returns the smallest element in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array from which the minimum value is to be returned. |
Returns: #
object
Min($.Courses[*].Price)
Sum #
Syntax: #
Sum(array[])
Returns the sum of the elements in the array[]. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| array[] | json array | The array of numbers to be summed. |
Returns: #
decimal
Sum($.Courses[*].Price)
ToArray #
Syntax: #
ToArray(param1, param2, param3, ...)
Converts param1, param2, param3, … into an array. #
Array
Parameters: #
| Name | Type | Description |
|---|---|---|
| param1 | object | The first element of the array. |
| param2 | object | The second element of the array. |
| param3 | object | The third element of the array. |
| … | object | Additional elements of the array. |
Returns: #
array
ToArray(1, 2, 3)