I was able to achieve your use case by using the interpolation variable in the URL in the place of the productno. I did the following steps.
* In the Request url i replaced the parameter with interpolation variable like:
* Now I will provide a sample value for the productno and create the base view say bv_http_product on top of it.
* Next I will create a join condition between this base view bv_http_product and the other base view say bv_product_list which contains the list of the products on the condition **bv_product_list.productno = bv_http_product.productno**.
* Now when I execute the dervied view I will have the response for all the product numbers present in bv_product_list.
To know more about interpolation variables refer to the section '**[Paths and Other Values with Interpolation Variables](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/path_types_in_virtual_dataport#paths-and-other-values-with-interpolation-variables)**' of the Virtual DataPort Administration Guide.
Hope this helps.