Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

lower(...)

lower(...)

Returns the lowercase equivalent of a string of text

Works with the following datatypes:

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

The lower(...) function is used within the $select or $where parameters to lower-case a Text value. For example, you could use it within the $select statement to lower-case names from the Chicago salaries dataset:

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