Distinct

Database.

Collections hold your records. Norbix generates a full CRUD + query API over each collection from its schema, with record-level ownership and triggers.

Returns distinct values for it.

Database

get

Authorizations

HTTPRequired

JWT Bearer Authorization

Path parameters

versionstring · nullableRequired

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

Header parameters

norbix-project-idstring · nullableRequired

ID of your project. Can be passed in a header as norbix-project-id.

norbix-envstring · nullableOptional

Target environment for this request (e.g. TEST, STAGING). Optional — when omitted the request runs against PROD. Can be passed in a header as norbix-env.

CultureCodestring · nullableOptional

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

TimeZoneIdstring · nullableOptional

TimeZone

CorrelationIdstring · nullableOptional

CorrelationId for each request

Responses

200

Success

application/json

DistinctResponse

valuesObject[] · nullableOptional

get/{version}/database/collections/{collectionName}/distinct

GET /{version}/database/collections/{collectionName}/distinct HTTP/1.1
Host: api.norbix.ai
Authorization: Bearer YOUR_SECRET_TOKEN
norbix-project-id: text
Accept: */*

200

Success

{
  "values": [],
  "responseStatus": {
    "isSuccess": true
  }
}

Refused operators

A filter (or pipeline) that contains $where, $function or $accumulator — the MongoDB operators that run JavaScript on the database server — is refused with CM-ERRORS-DATABASE-031 (Operator '…' is not allowed in a record filter or read-only aggregation pipeline.), one error per operator, at any depth. Use ordinary query operators instead.

In Cloud

Manage this visually in Cloud — see Database.

Use it from code

Every Norbix SDK exposes this endpoint as a method — see Distinct in the SDK reference, with examples in every language.