Skip to main content

1E 23.7 (SaaS)

Sort Definition

Many API endpoints support filtering and sorting of the data they return.

These endpoints usually, but not always, have a 'Search' word in their URI, like '/Consumers/Search'.

Building sort expression

Sort expressions are defined as JSON. It's defined as a collection of sort specs, for example:

Sort Expression

[  
  {  
     "Column":"Column1",
     "Direction":"ASC"
  },
  {  
     "Column":"Column2",
     "Direction":"DESC"
  }
]
  • ASC - sort in ascending order - the default if no direction is specified

  • DESC - sort in descending order.