You can translate the question and the replies:

JSON source representation

Hi, I would liket to import currency rates (https://api.exchangeratesapi.io/latest?base=USD) into Denodo in the form of one table with 2 columns, -Currency -Rate In fact Denodo generates a column for each currency. Thank you for helping, José
user
09-04-2020 03:34:28 -0400

6 Answers

Hi, To retrieve the results in a format that has ‘Currency and Rate’ as the column name and has its corresponding ‘value’ in a row, I would develop a custom wrapper using [Denodo4E](https://community.denodo.com/docs/html/browse/7.0/denodo4e/install_denodo4e/install_denodo4e#installing-denodo4e) extension to achieve this scenario. Also, note that the schema of a view must be static and it cannot be dynamic. For more information,you could refer to the [Developing Custom Wrappers](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/developing_extensions/developing_custom_wrappers/developing_custom_wrappers#developing-custom-wrappers) section under the Virtual DataPort Developer Guide for more details. You could also find samples for Virtual DataPort Custom Wrapper in the directory ‘<DENODO_HOME>\samples\vdp\customWrappers’ for your reference. Hope this helps!
Denodo Team
09-04-2020 08:27:56 -0400
Ok So a simple REST envelop without Swagger definition adhoc is somewhat useless with Denodo. Tha is why I came to the conlusion of using a soap/wsdl instead of Swaggerless JSON wich comes with service metadata describing the data actually transmitted. And that's quite usable inside Denodo. Thank you anyway, José
user
09-04-2020 08:32:34 -0400
Hi, I am glad that you were able to figure it out. You could refer the section [SOAP Web Service ](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/soap_web_service_sources/soap_web_service_sources) of Virtual DataPort Administration Guide to get more information. Hope this helps!
Denodo Team
05-05-2020 08:16:14 -0400
Hi, Is there a sample of Denodo Custom wrapper available ? I need to integrate http://demo.ingenibridge.com/SQLREADER/ExecuteSelect?SelectColumns=*&FromTables=%24TimeSeries but the columns ans content are separated in this REST service. Thank you
user
06-05-2020 04:04:51 -0400
Hi, You could find the sample for Denodo Custom wrapper in the directory **<DENODO_HOME>\samples\vdp\customWrappers**. Hope this helps!
Denodo Team
13-05-2020 02:35:40 -0400
Great ! I hadnt seen it... :-) Thx
user
14-05-2020 15:02:18 -0400
You must sign in to add an answer. If you do not have an account, you can register here