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](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/json_sources/json_sources) or [XML](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/xml_sources/xml_sources) 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](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/index) 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](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/postprocessing_section_exporters) available in Scheduler such as CSV,JDBC or Custom Exporter. For more information, you can refer to the [VDP Extraction](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdp_extraction_section) Section of the Scheduler Administration Guide.
* If you want to export the results in XML format, you could either use [Generic XML Exporter](https://community.denodo.com/docs/html/document/denodoconnects/7.0/en/Generic%20XML%20Exporter%20-%20User%20Manual) which can be downloaded from the Support site if you are a valid support user or create your own [Customer Exporter](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/developer_api/extensions_plugins/exporters) 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](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/restful_architecture/restful_web_service/idu_requests) section of Virtual DataPort Administration Guide and similar Community Q&A answers [Denodo Web Service](https://community.denodo.com/answers/question/details?questionId=9064u0000004FclAAE&title=Denodo+Web+Service) and [insert operation through postman for multiple unique primary keys](https://community.denodo.com/answers/question/details?questionId=9064u000000L849AAC&title=insert+operation+through+postman+for+multiple+unique+primary+keys).
Hope this helps!