Query option $orderby

Use the $orderby query option to request records in either ascending or descending order. If you don't specify an order, the default order is ascending.

Component Description

Component	Description
HTTP method	GET
URL	https://`host`/fmi/odata/`version`/`database-name`/`table-name`?$orderby=`field-name` {asc/desc} `host` – FileMaker Cloud or FileMaker Server host name `version` – the OData version, always `v4` `database-name` – the name of the hosted database `table-name` - the name of the table `field-name` - the name of the field Example: `/fmi/odata/v4/ContactMgmt/Contacts?$orderby=Company desc` The request above sorts Contacts records in descending order by the Company field.

HTTP method

GET

URL

https://host/fmi/odata/version/database-name/table-name?$orderby=field-name {asc/desc}

host – FileMaker Cloud or FileMaker Server host name

version – the OData version, always v4

database-name – the name of the hosted database

table-name - the name of the table

field-name - the name of the field

Example: /fmi/odata/v4/ContactMgmt/Contacts?$orderby=Company desc

The request above sorts Contacts records in descending order by the Company field.

FileMaker information

Enclose field names that include special characters, such as spaces or underscores, in double-quotation marks.
The $orderby query option doesn't support OData built-in functions.