You can translate the question and the replies:

Post operation

Is it possible to push the derived view data into target systems using API post operation in denodo?
user
05-11-2020 01:19:53 -0500
code

1 Answer

Hi, In order to store/insert the data of the view in external database I would "CREATE_REMOTE_TABLE" option. When creating a remote table, Denodo automatically perform the following: * Creates the table with the appropriate schema in an external database. * Inserts the result of the query in this table. * Optionally, it creates a base view in Virtual DataPort associated to this new table. For more details, you can refer to [CREATE_REMOTE_TABLE](https://community.denodo.com/docs/html/browse/latest/vdp/vql/stored_procedures/predefined_stored_procedures/create_remote_table#create-remote-table) section of the Virtual DataPort VQL Guide and [Remote Tables](https://community.denodo.com/docs/html/browse/8.0/vdp/administration/remote_tables/remote_tables#remote-tables) sections of the Virtual DataPort Administration Guide. In case if I like to insert data into web service (For example: JSON) using POST method in Denodo Platform. I would follow below steps: * Create JSON data source and select "Data route" as "HTTP Client". * Click on configure and select HTTP Method as "POST". * Under the URL section, provide the correct api where I would like to insert data. * Click on Post body and provide the derived view data in JSON Format. * Click Ok and save. For more details, you can refer to [INSERT Queries (POST)](https://community.denodo.com/docs/html/browse/latest/vdp/administration/restful_architecture/restful_web_service/idu_requests#insert-queries-post) section of the Virtual DataPort Administration Guide. In case, if you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
06-11-2020 07:33:16 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here