Multiple Requests with HTTP Connection

Hello, I am working on a project to pull in data from an external JSON source. One endpoint will give me a list of ids that I can store in a base view. I would like to use those IDs (lets say there are 50) to pass into a second endpoint http url that requires the specific id to return information about the object. I want to run the call 50 times, using those IDs from BaseView1 to create BaseView2 with 50 rows. Is this possible with Denodo?
user
11-07-2019 22:29:47 -0400

1 Answer

Hi, 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!
Denodo Team
26-07-2019 05:40:39 -0400
You must sign in to add an answer. If you do not have an account, you can register here