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" \
  -H "Content-Type: application/json" \
  -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=