min(...)

min(...)

Returns the minimum of a given set of numbers

Works with the following datatypes:

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

The min(...) function is most commonly used in $select aggregations to return the minimum of a set of numeric values (Numbers, Doubles, or Moneys). For example, to fetch the lowest salary of all of the employees in the City of Chicago:

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$select=min(annual_salary)

It can also be used in $group aggregations, like this one to get the minimum salary by job type:

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$select=job_titles,min(employee_annual_salary)&$group=job_titles