I was able to get the desired result by performing the following steps in the Virtual DataPort Administration Tool:
1. You can [create a base view](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources) from the first JSON source which will retrieve all the IDs from the external source.
1. Create another base view from the second endpoint as a JSON data source with Data route as HTTP Client.
1. Once these base views are created in Virtual DataPort Administration Tool, you can create a derived view over them to [join](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_join_views/creating_join_views#creating-join-views) the "id" columns from both the base views.
You can also obtain the values of the ‘id’ column dynamically, then, you could navigate to the 'Edit > Model tab' where you could find the View parameters section. Setting the id column as a View parameter, you can change the value for the id column during runtime to retrieve only that particular record.
For more information about view parameters, you can refer [Parameters of derived views](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/creating_selection_views/creating_selection_views#parameters-of-derived-views) section of Virtual DataPort Administration Guide.
Hope this Helps!