Sorting records

Sort records in a SQL or NoSQL GET request. Try these examples in the 'API Docs' tab of the DreamFactory Admin Console or from the command line with cURL.

API Endpoint

GET https://{url}/api/v2/{api_name}/_table/{table_name}?order={sort_order}

API Docs Screenshot

Example - GET contact records and sort by last name ascending

• Table name: contact
• Order parameter in API call:

  last_name ASC

• Request URL:

  https://foo.com/api/v2/db/_table/contact?order=last_name%20ASC

Example - GET contact records and sort by last name descending

• Table name: contact
• Order parameter in API call:

  last_name DESC

• Request URL:

  https://foo.com/api/v2/db/_table/contact?order=last_name%20DESC

Example - GET contact records and sort by last name ascending, then by first name ascending (nested sort)

• Table name: contact
• Order parameter in API call:

  last_name ASC, first_name ASC

• Request URL:

  https://foo.com/api/v2/db/_table/contact?order=last_name%20ASC%2C%20first_name%20ASC