Distinct

Finds the distinct values for a specified field across a single collection and returns the results in an array.

[Distinct] - Finds the distinct values for a specified field across a single collection and returns the results in an array.

Finds the distinct values for a specified field across a single collection and returns the results in an array. https://docs.codemash.io/api/database/collections/distinct

get

/{version}/db/{CollectionName}/distinct

Authorizations

Path parameters

CollectionNameanyrequired

Collection name - unique, lowercased, collection name without whitespace. E.g., if your collection title you have entered in the CodeMash dashboard is "Business Trips" then collection name would be "business-trips".

versionanyrequired

The CodeMash API version used to fetch data from the API. If not specified, the last version will be used. E.g.: v2

Query parameters

Fieldanyrequired

The field for which to return distinct values

Header parameters

Acceptanyrequired

Accept Header

X-CM-Clusterany

API key of your cluster. Can be passed in a header as X-CM-Cluster.

X-CM-ProjectIdanyrequired

ID of your project. Can be passed in a header as X-CM-ProjectId.

CultureCodeany

Specify culture code when your response from the API should be localised. E.g.: en

Responses

application/json

cURL

JavaScript

Python

HTTP

cURL

curl -L \
  --url 'https://api.codemash.io//{version}/db/{CollectionName}/distinct' \
  --header 'Authorization: YOUR_API_KEY'

200

200

{
  "response_status": {
    "error_code": "text",
    "message": "text",
    "stack_trace": "text",
    "meta": {
      "ANY_ADDITIONAL_PROPERTY": "text"
    },
    "errors": [
      {
        "error_code": "text",
        "field_name": "text",
        "message": "text",
        "meta": {
          "ANY_ADDITIONAL_PROPERTY": "text"
        }
      }
    ]
  },
  "result": [
    {}
  ]
}

Success

[Distinct] - Finds the distinct values for a specified field across a single collection and returns the results in an array.

Finds the distinct values for a specified field across a single collection and returns the results in an array. https://docs.codemash.io/api/database/collections/distinct

post

/{version}/db/{CollectionName}/distinct

Authorizations

Path parameters

CollectionNameanyrequired

Collection name - unique, lowercased, collection name without whitespace. E.g., if your collection title you have entered in the CodeMash dashboard is "Business Trips" then collection name would be "business-trips".

versionanyrequired

The CodeMash API version used to fetch data from the API. If not specified, the last version will be used. E.g.: v2

Header parameters

Acceptanyrequired

Accept Header

X-CM-Clusterany

API key of your cluster. Can be passed in a header as X-CM-Cluster.

X-CM-ProjectIdanyrequired

ID of your project. Can be passed in a header as X-CM-ProjectId.

CultureCodeany

Specify culture code when your response from the API should be localised. E.g.: en

Body

Fieldstringrequired

The field for which to return distinct values

Filterstring

A query that specifies the documents from which to retrieve the distinct values

Responses

application/json

cURL

JavaScript

Python

HTTP

cURL

curl -L \
  --request POST \
  --url 'https://api.codemash.io//{version}/db/{CollectionName}/distinct' \
  --header 'Authorization: YOUR_API_KEY' \
  --header 'Content-Type: application/x-www-form-urlencoded' \
  --data 'Field=text&Filter=text'

200

200

{
  "response_status": {
    "error_code": "text",
    "message": "text",
    "stack_trace": "text",
    "meta": {
      "ANY_ADDITIONAL_PROPERTY": "text"
    },
    "errors": [
      {
        "error_code": "text",
        "field_name": "text",
        "message": "text",
        "meta": {
          "ANY_ADDITIONAL_PROPERTY": "text"
        }
      }
    ]
  },
  "result": [
    {}
  ]
}

Success