Hi,
When I publish the view as RESTful web service, I would make use of "Set as mandatory" option by double clicking on the field in Resources Tab. With this setting, I have to specify the value for the field in the Query.
As for filtering the query result, I was able to use $filter parameter for RESTful web service. By using this filter, I don't have to pull all the data and I can just get the data I need.
I referred to the following user manuals, I believe it should be helpful to you:
* [Resources Tab](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/publication_of_web_services/publishing_rest_web_services/resources_tab)
* [Input Parameters of the RESTful Web Service](https://community.denodo.com/docs/html/browse/latest/vdp/administration/restful_architecture/restful_web_service/input_parameters_of_the_restful_web_service)
Hope this helps!