You can translate the question and the replies:

Posting data to materialized view via Denodo web service

Hi, We're using a separate software to route messages between a Denodo webservice and an external webservice. What is the best option to store the replies from the external webservice? It could be both error messages and data. I tested using a separate Denodo webservice over a materialized table and was able to post data to it. But I can only post one "record" at a time? And it does not accept complex data types like XML? Are there a work-around for these limitations? One alternative would be to store the replies on a file server in XML format and create Denodo views over it. What solution do you recommend, are there other options? I would prefer using the web service. Thank you! Niclas Eriksson Using Denodo 7.0.20210818
15-02-2022 09:42:31 -0500

1 Answer

Hi, I believe that you are looking for a way to store the response from an external webservice. You could achieve this by creating a [JSON]( or [XML]( datasource over the webservice and a base view on top of it to retrieve data in relational format. Inorder to export the results from the view, you could leverage [Denodo Scheduler]( to do the following. * Create a VDP-type job in Scheduler in such a way to extract the results from the web service view and export them to desired format. Inorder to export the data, you can use the [Exporters]( available in Scheduler such as CSV,JDBC or Custom Exporter. For more information, you can refer to the [VDP Extraction]( Section of the Scheduler Administration Guide. * If you want to export the results in XML format, you could either use [Generic XML Exporter]( which can be downloaded from the Support site if you are a valid support user or create your own [Customer Exporter]( which could export the data to XML format and use it in your Scheduler job. Note: If your intention is to export both data and errors, you could create a Custom Exporter as Generic XML Export can capture only the data. Furthermore, Denodo REST web service supports the HTTP POST method and with the help of POST method, you can insert multiple records to a view. For more information, you can refer to the [IDU Requests]( section of Virtual DataPort Administration Guide and similar Community Q&A answers [Denodo Web Service]( and [insert operation through postman for multiple unique primary keys]( Hope this helps!
Denodo Team
16-02-2022 07:52:40 -0500
You must sign in to add an answer. If you do not have an account, you can register here