You can translate the question and the replies:

Data Service payload reroute

Hi, I can have scenarios where result set of a request can be huge. And Consumer does not prefer paginated REST access. Is it possible to take the request via REST and generate a file for payload and send the file to a file store for consumer to pickup?
user
20-02-2019 13:43:30 -0500
code

1 Answer

Hi, I would recommend you to create a base view over the web service datasource using Virtual DataPort Administration Tool and then use Denodo Scheduler to export the results by following the below steps: * Create a New [VDP Data Source](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/data_sources/vdp_data_sources) in Scheduler for the Virtual database. * Create a new VDP [job](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/jobs/jobs). * In the [Extraction section](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/vdp_extraction_section), select VDP Data Source and pass the Parameterized Query to fetch the data from Virtual Dataport Server. For eg: `Select * from <REST_BaseView>` * In the Exporter section, create a new exporter(CSV, JDBC or SQL). This file can be used to store manually in a remote location. For more details, you can refer to [Creating and Scheduling Jobs](https://community.denodo.com/docs/html/browse/7.0/scheduler/administration/creating_and_scheduling_jobs/creating_and_scheduling_jobs) which explains in detail how to use Denodo Scheduler. If you are looking to expose the REST Web services from Denodo to the consumer and if the data load is high you could use the $filter option to restrict the data set. For more details, you can refer to the [Parameters of the Web Service RESTful and REST Web Services](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/restful_architecture/restful_web_service/input_parameters_of_the_restful_web_service#parameters-supported-by-the-denodo-restful-web-service-and-published-rest-web-services) of the Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
22-02-2019 07:25:08 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here