upper(...)

upper(...)

Returns the uppercase equivalent of a string of text

Works with the following datatypes:

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

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

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

You can also use it within the $where parameter to do case-insensitive matches:

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$where=upper(name)=upper('ABARCA, ANABEL')