REST Service for Custom table Items

Hello All,

I am using built in Kentico feature to get data for a custom table using REST API as described by this documentation https://docs.kentico.com/display/K8/Getting+data+using+REST

I had had fair success using this. The only problem I'm facing is When I start using Where clause.

Let's say I have a custom table with two columns City and State for all cities/state for USA. Now I would like to get Cities based on selected cities

So my Hashed URL will be like this

http://mydomain.com/REST/customtableitem.exclusive.CityState?format=json&Columns=City,State&Where=State=%27IL%27

Now since this where clause will be dynamically generated, I am unable to get around by using a generic hash code for this. It will be difficult to hash all 52 urls. What is the way around to this problem or am I doing something wrong?

Thanks, Chetan