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?
05-11-2020 01:19:53 -0500

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]( section of the Virtual DataPort VQL Guide and [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)]( 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
You must sign in to add an answer. If you do not have an account, you can register here