Skip to main content Skip to complementary content

List functions

The list functions manipulate list data.

Count

Counts the number of items in a list.

{$.getContacts} = [{name:"John Doe},{name:Jane Doe}]

{count:{$.getContacts}} = 2

Get keys

Returns a list of keys from key-value pairs in an object.

{$.contact} = {name:John Doe, email:jd@email.com}

{getkeys:$.contact} = [name,email]

Implode

Converts a list of items into a comma-separated string. You can change the delimiter as a parameter.

{$.contacts[*].name} = [John,Jane,Bill,Barb]

{implode:{$.contacts[*].name}} = John,Jane,Bill,Barb

With a linebreak as the delimiter:

{implode:{$.contacts[*].name}, "{linebreak}"} = John</br>Jane</br>Bill</br>Barb

Sort

Sorts a list ascending. For lists of object, add a parameter to sort the objects by key name. Use sortdecs to sort a list descending.

{$.contacts[*].name} = [John,Jane,Bill,Barb]

{sort:{$.contacts[*].name}} = [Barb,Bill,Jane,John]

With a key name as a parameter:

{$.contacts[*].name}=

[
  {
    "name":"John",
    "id":"100"
  },
  {
    "name":"Bill",
    "id":"4"
  },
  {
    "name":"Barb",
    "id":"17"
  },
  {
    "name":"Jane",
    "id":"1"
  }
]

{sort:{$.contacts[*].name}, "id"} =

[
  {
    "name":"Jane",
    "id":"1"
  },
  {
    "name":"Bill",
    "id":"4"
  },
  {
    "name":"Barb",
    "id":"17"
  },
  {
    "name":"John",
    "id":"100"
  }
]
Information note

The algorithm applies a natural sort order, not an alphanumeric sort order. Change the algorithm as needed.

The sort order options

The sort order algorithm list for the sort function

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!