distinct

distinct

Returns distinct set of records

Works with the following datatypes:

This function works with 2.1 endpoint(s). What does this mean? »

The distinct keyword can be used in conjunction with $select to return one record for each distinct value in the selected column(s). For example, to fetch the distinct departments

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$select=distinct department

It can also be used in a full $query to select distinct values.

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$query=select distinct department