Introduction

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'.


On this page:

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.