Sorting

To sort the API query result by specify field, use the  sort_by query parameter.

Examples

Request 1

Sort by ascending order: Suppose you want to obtain the access control records in ascending order. You initially pass parameter sort_by=accessDate to the endpoint and retrieve the earliest records of the dataset.

Response 1 (truncated)

Request 2

Sort by descending order: Suppose you want to obtain the latest access control records, you would like to sort the result in descending order. You initially pass parameter sort_by=-accessDate to the endpoint and retrieve the latest records of the dataset.

Response 2 (truncated)

NOTE:

Sort operations that do not use an index will abort when they use 32 megabytes of memory. To check if the field is indexed or not, please refer to the “Indexed” filed in related data dictionary.

If pagesize and page are not given in the query string, a maximum of first 100 objects will be returned. Details please refer to “Pagination“.