You can translate the question and the replies:

VQL to Redeploy ALL Deployed REST Web Services

Is there a VQL command that can redeploy all deployed REST web services? Applying Update 20200310 caused all deployed REST web services to be inaccessible (HTML 404), which we already anticipated as noted in the Update notes. I just want a better alternative than manually selecting a database, then manually picking only the deployed web services, then manually clicking redeploy, and then repeat the entire process for each database that has a deployed web service. The service outage for such a manual process will be relatively longer than a VQL command, if one exists. Thanks
user
20-05-2020 12:30:13 -0400

1 Answer

Hi, I would make use of Denodo’s predefined stored procedure **WEBCONTAINER_ELEMENT_STATUS** and **REDEPLOY WEBSERVICE** statement to achieve this. I would first get all the web service names which are already deployed using the ‘WEBCONTAINER_ELEMENT_STATUS’ stored procedure. Then reiterate through the list of web services and redeploy each web service using ‘REDEPLOY WEBSERVICE’ statement. You can refer to the document on the predefined stored procedure [WEBCONTAINER_ELEMENT_STATUS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/webcontainer_elements_status#webcontainer-element-status) and [Statements to Deploy & Redeploy Web Services](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/publication_of_web_services/deploying_and_exporting_soap_and_rest_web_services/deploying_and_exporting_soap_and_rest_web_services). Hope this helps!
Denodo Team
21-05-2020 06:15:54 -0400
You must sign in to add an answer. If you do not have an account, you can register here