You can translate the question and the replies:

JSON source representation

Hi, I would liket to import currency rates ( 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é
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]( 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]( 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é
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 ]( 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*&FromTables=%24TimeSeries but the columns ans content are separated in this REST service. Thank you
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
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