You can translate the question and the replies:

ReST API Dynamic end point

I need to execute the First Endpoint and get the results Using the results of the First URL (ID) need to execute another call to get the corresponding data. First Call example https://company.data.com/api/metaproperties/ ID ABC CDE EFG Second Call examples (Number of calls varies based on the Output of First Call) https://company.data.com/api/metapropertiesdata/ABC https://company.data.com/api/metapropertiesdata/CDE https://company.data.com/api/metapropertiesdata/EFG Any suggestions ?
user
01-11-2017 20:58:28 -0400

2 Answers

Hi, I would make use of interpolation variables in order to access dynamic endpoints. I would create JSON datasource with Data Route as HTTP Client. When configuring the HTTP client with GET method, I would use interpolation variables in the URL as below, http://companydata.com/metadatapropertiesdata/@{id} This would allow me to create base views with dynamic values to the 'id' variable. In order to get the values for the 'id' field, I would create a similar JSON datasource with HTTP endpoint of web service that returns ‘id’ values. As the values are returned inside an array, this view should be flattened for further operation. Then, I would join these two views based on the 'id' column, in order to pass the value from the static service to the dynamic endpoint service and execute it to get the results. You can refer to [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) section of Virtual DataPort  Administration guide for more information. Hope this helps!
Denodo Team
02-11-2017 08:39:35 -0400
hi
user
09-09-2020 14:04:46 -0400
You must sign in to add an answer. If you do not have an account, you can register here