Add an 'IN' operator to WHERE filter, to use a list
I've previously used ODATA when filtering requests - e.g. MYOB.
It provides an 'IN' operator for the filter, so you can request using a list of items.
e.g. ?where=Code IN ('1234','1245','1236','1237','1238')
Obviously, this translates directly to the common SQL clause - WHERE column_name IN (value1, value2, vlaue3, etc)
Thus avoiding the need for multiple request, or paging an ALL accounts request and then filtering locally.
3
votes
Mike
shared this idea