starts_with(...)

starts_with(...)

Matches on text strings that start with a given substring

Works with the following datatypes:

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

starts_with(...) allows you to filter for Text values that start with a given substring. For example, to query the City of Chicago Salaries for for only CHIEFs:

https://data.cityofchicago.org/resource/tt4n-kn4t.json?$where=starts_with(job_titles, 'CHIEF')