Sorting records

1. 1. 1. Tutorial

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

1. 1. 1. API Endpoint

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

1. 1. 1. API Docs Screenshot

1. 1. 1. Example - Sort contact records 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

1. 1. 1. Example - Sort contact records 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

1. 1. 1. Example - Sort contact records 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