You can translate the question and the replies:

Multiple input parameters in REST service

HI Please let me know how to pass or query multiple inputs for a REST service. Eg. If my REST service has a view with 'Rollnum' in where condition then how shall i fetch the records for the roll numbers "1,,3,6,7" in one go ? Thanks
user
08-11-2016 05:16:32 -0500

3 Answers

Hi, On the interface of the Rest webservice I make use of the various conditions available for input parameters to perform a search and it displays the list of recrods that matches the search condition. In your case right next to the input parameter field "Rollnum" you can select the "iscontained" condition from the drop down and enter the value "1,3,6,7" to search and display the records in one go. Hope this helps!
Denodo Team
10-11-2016 03:40:09 -0500
HI.. Thanks for the reply .. I tried using ISCONTAINED operator from drop down in the WEB search screen instead of URL but didnt recieve any result the query in keep on running. Also apart from this can you please help me if how can I use the URL with filter for passing dynamic values in Java program for populating it dynamically
user
 Edited on: 14-05-2019 02:28:55 -0400
Hi, For passing multiple parameters in the URL of Rest Web Service, I would use the **$filter** parameter which filters the rows of a view based on where conditions. Also, for dynamically changing the values in the filter parameter, I would make use of [Interpolation variables](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport#paths-and-other-values-with-interpolation-variables) (like, ?$filter=@variable) and provide the value for this variable during each execution dynamically. You can have a look at [Input Parameters of the RESTful Web Service](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/restful_architecture/restful_web_service/input_parameters_of_the_restful_web_service#parameters-supported-by-the-denodo-restful-web-service-and-published-rest-web-services) section of Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
07-06-2019 08:32:57 -0400
You must sign in to add an answer. If you do not have an account, you can register here