You can translate the question and the replies:

Dynamic Query in JSON

Hi team, How to create a dynamic query for the specific field or multiple fields? Because, I think Dynamic query helps to filter the data in runtime and gets to filter the huge data and provide the result much faster than the usual one. So I need to know, **how to create a dynamic query for JSON datasource from the source ?**

1 Answer

Hi, In situations where there is a need to query sources dynamically, I would use the interpolation variable. That is, for instance when an interpolation variable is used in URL for a the JSON source with HTTP Client as the data route, when a view created from such source is executed there are a need to specifying the value for the variable. For instance, to create a JSON web service with the HTTP as data route I would provide a interpolation variable in the URL similar to the following syntax: ``` <URL>?field1=@{PARAM1}&$format=json&field2=@{PARAM2} ``` You can take a look at the [Paths and Other Values with Interpolation Variables](https://community.denodo.com/docs/html/browse/latest/en/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) section of the Virtual DataPort Administration Guide for more information on how to provide the interpolation variable. Hope this helps!
Denodo Team
02-09-2021 07:11:26 -0400
You must sign in to add an answer. If you do not have an account, you can register here