Distinct Values

Distinct values

It’s possible to retrieve all distinct values of a collection’s column using a POST request.

Examples

curl -X POST 
-H "X-Appery-Database-Id: 544a5cdfe4b03d005b6233b9" 
-d 'where={/* criteria */}' 
https://api.appery.io/rest/1/db/collections/[collectionName]/distinct/[columnName]
It’s also possible to use a GET request to retrieve distinct values:
curl -X GET 
-H "Content-Type: application/json" 
-H "X-Appery-Database-Id: 544a5cdfe4b03d005b6233b9" 
https://api.appery.io/rest/1/db/collections/<collection_name>/distinct/<column_name>?where=