You can translate the question and the replies:

I need to send multiple query parameters to a field in REST API

Hi, can us help me with that? i want to know if is possible to send multiple query parameters like "field in (value 1, value2, valueN)" to a field in REST API. The goal is to use a single 'GET' but 'IN' condition, or also if there was a way to edit the VQL of the REST service that allows to receive an 'Array' type field. Thanks,
user
03-05-2023 09:57:14 -0400
code

1 Answer

Hi, you can add a condition to the URL itself. For your specific case I recommend using the following format: $filter=field1 IN ('value1','value2'). You have to append it to the URL as shown in this example: http://localhost:9090/denodo-restfulws/mydb/views/myview?$filter=productid IN (1,2) URL-encode the URL above would look like this: http://localhost:9090/denodo-restfulws/mydb/views/myview?$filter=productid%20IN%20(1,2) You can find this and more information about the input parameters of the Denodo RESTful Web Service in the Section [Input Parameters of the Restful Web Service ](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/restful_architecture/restful_web_service/input_parameters_of_the_restful_web_service) of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
05-05-2023 05:15:10 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here