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 - 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

1. 1. 1. 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

1. 1. 1. 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