Is it possible to define a new api (v3) endpoint which has a specific WHERE clause but that still leverages the flexibility of the "get" action in terms of defining parameters, options, pagination, chained api calls etc?
What I'm trying to achieve is to define an endpoint that returns all records that match a WHERE clause which looks something like this
(entity.field1 = 1 AND entity.field2 = 'a') OR
(entity.field1 = 2 AND entity.field2 = 'b') OR
(entity.field1 = 3 AND entity.field2 = 'c')"
but at the same time I still want the endpoint to be able to accept all the parameters and options that the "get" options accept, because a consumer of this endpoint would want to further filter the records or to sort them, paginate them, etc.
It doesn't seem that the built-in actions have support for OR
clauses, so this endpoint would have to be a mix of api methods and a manually built SQL query (if it's even possible?)