Sorting records
From DreamFactory
(Created page with "### 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. ### API End...") |
|||
| Line 11: | Line 11: | ||
[[File:Swagger-order.png|1000px]] | [[File:Swagger-order.png|1000px]] | ||
| − | ### Example - | + | ### Example - GET contact records and sort by last name ascending |
* Table name: contact | * Table name: contact | ||
| Line 17: | Line 17: | ||
* Request URL: <pre>https://foo.com/api/v2/db/_table/contact?order=last_name%20ASC</pre> | * Request URL: <pre>https://foo.com/api/v2/db/_table/contact?order=last_name%20ASC</pre> | ||
| − | ### Example - | + | ### Example - GET contact records and sort by last name descending |
* Table name: contact | * Table name: contact | ||
| Line 23: | Line 23: | ||
* Request URL: <pre>https://foo.com/api/v2/db/_table/contact?order=last_name%20DESC</pre> | * Request URL: <pre>https://foo.com/api/v2/db/_table/contact?order=last_name%20DESC</pre> | ||
| − | ### Example - | + | ### Example - GET contact records and sort by last name ascending, then by first name ascending (nested sort) |
* Table name: contact | * Table name: contact | ||
* Order parameter in API call: <pre>last_name ASC, first_name ASC</pre> | * Order parameter in API call: <pre>last_name ASC, first_name ASC</pre> | ||
* Request URL: <pre>https://foo.com/api/v2/db/_table/contact?order=last_name%20ASC%2C%20first_name%20ASC</pre> | * Request URL: <pre>https://foo.com/api/v2/db/_table/contact?order=last_name%20ASC%2C%20first_name%20ASC</pre> | ||
Revision as of 17:20, 15 October 2015
- 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.
- 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
