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:
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!