Oracle CRM On Demand REST API Developer's Guide > Using the Oracle CRM On Demand REST API >

Sorting Collection Resources

When you list Oracle CRM On Demand collection resources, you can sort the collections list using the orderBy URL parameter. The orderBy query parameter value contains the field name, followed by either asc (ascending) or desc (descending) to specify whether the sort results return in either ascending or descending order. If there are multiple field names specified for the orderBy parameter value, then a comma is used to separate the field names.

For example:

https://<host>/user/OnDemand/Rest/latest/Accounts?orderBy=AccountName:asc,AccountLocation:asc&limit=100&offset=0&fields=RowId,AccountName,AccountLocation