Ordering

When requesting multiple instances of a content type, you can use the sort parameter to define the order in which items are returned.

The sort parameter accepts a comma separated list of field names that the results should be sorted by.

Note

By default, fields specified in the sort parameter are sorted in ascending order. To sort a field in descending order, you can prefix the field name with the hyphen.

Sort Ascending

The following example retrieves books sorted by their rating field in ascending order:

      
    GET /book?sort=rating
  
  curl https://{SPACE_ID}.spaces.lexascms.com/delivery/jsonapi/book?sort=rating \
     -H 'Content-Type: application/vnd.api+json'

  const axios = require('axios');

const requestOptions = {
  baseURL: 'https://{SPACE_ID}.spaces.lexascms.com/delivery/jsonapi',
  headers: { 'Content-Type': 'application/vnd.api+json' },
  params: {
    sort: 'rating'
  }
};

axios.get('/book', requestOptions).then(response => {
  console.log(response.data);
});

Sort Descending

The following example retrieves books sorted by their rating field in descending order:

      
    GET /book?sort=-rating
  
  curl https://{SPACE_ID}.spaces.lexascms.com/delivery/jsonapi/book?sort=-rating \
     -H 'Content-Type: application/vnd.api+json'

  const axios = require('axios');

const requestOptions = {
  baseURL: 'https://{SPACE_ID}.spaces.lexascms.com/delivery/jsonapi',
  headers: { 'Content-Type': 'application/vnd.api+json' },
  params: {
    sort: '-rating'
  }
};

axios.get('/book', requestOptions).then(response => {
  console.log(response.data);
});

Sort Multiple Fields

The following example retrieves books sorted by their rating field in descending order, followed by their publishedDate field in ascending order.

      
    GET /book?sort=-rating,publishedDate
  
  curl https://{SPACE_ID}.spaces.lexascms.com/delivery/jsonapi/book?sort=-rating,publishedDate \
     -H 'Content-Type: application/vnd.api+json'

  const axios = require('axios');

const requestOptions = {
  baseURL: 'https://{SPACE_ID}.spaces.lexascms.com/delivery/jsonapi',
  headers: { 'Content-Type': 'application/vnd.api+json' },
  params: {
    sort: '-rating,publishedDate'
  }
};

axios.get('/book', requestOptions).then(response => {
  console.log(response.data);
});

Filtering

JSON:API (REST)

Localisation

JSON:API (REST)

On This Page

Ordering

Sort Ascending

Sort Descending

Sort Multiple Fields

Features

Solutions

Support

Company