The stored procedure
WEBCONTAINER_ELEMENTS returns information about
the Web services (SOAP and REST) and widgets of all the Virtual DataPort
databases. You can filter by database, type of Web service, name of the
service, look only for services that are deployed, etc.
This stored procedure is deprecated and it may be removed in the next major version of the Denodo Platform. Use the procedure WEBCONTAINER_ELEMENT_STATUS instead because it provides more information than this one.
The section Features Deprecated in Denodo Platform 8.0 lists all the features that are deprecated.
WEBCONTAINER_ELEMENTS ( input_database_name : text , <input_service> , <input_service_type> , input_service_name : text , input_description : text , input_modified : boolean , input_deployed : boolean ) <input_service> ::= 'webservice' | 'widget' <input_service_type> ::= 'REST' | 'SOAP' | 'SOAP/REST'
All the parameters are optional. If a parameter is
procedure does not filter by that parameter.
input_database_name: name of the database where you want to search for Web services and/or widgets. If
null, it searches all the databases for services.
input_service: type of service you are looking for. The value is case insensitive.
To search for widgets, enter
To search for Web services, enter “
To search both, enter
input_service_type: type of service that you are looking for. Widgets do not have subtypes, so when you are looking for them, just enter the value
serviceparameter and set this to
To search for REST Web services, enter
To search for SOAP Web services, enter
To search for Web services imported from Virtual DataPort 4.7 or earlier, enter
input_service_name: if provided, the procedure returns the services whose name contains this value. Take into account that if the parameter
null, the procedure returns the services of all the databases that match this name. Not just the one that you currently connected to.
input_description: if provided, the procedure returns the services whose description contains this value.
true, it returns all the services that are deployed and that have been modified after being deployed. If
false, it returns all the services that are deployed and that have not been modified afterwards.
true, it returns all the services that are configured to be deployed. If
false, it returns the services that are not configured to be deployed. This means that while Virtual DataPort is starting, this procedure may return
truebut the service is not yet available but it will be soon.
This procedure only returns information about the Web services and widgets that belong to databases on which the user is an administrator. The implications of this are the following:
If the user is an administrator, the procedure will return information about all the Web services and widgets.
The procedure will return information about the Web services and widgets of the databases of which the user is a local administrator.
This procedure does not return a “privileges error”. For example, let us say that:
A user requests information about the Web services of all the databases.
The Server has two databases:
This user only is a local administrator of the
testingdatabase but not the
In this scenario, the procedure only returns information about the Web
services of the
testing database and not about the Web services of
Obtain all the REST Web services of the database
SELECT service, service_type, service_name,description, deployed, modified, context, user FROM WEBCONTAINER_ELEMENTS() WHERE input_database_name = 'test' AND input_service_type = 'REST';
Obtain all the deployed Web services and auxiliary Web services for widgets:
SELECT database_name, service, service_type, service_name,description, deployed, modified, context, user FROM WEBCONTAINER_ELEMENTS() WHERE input_deployed = true;
Obtain all the deployed Web services whose definition has changed since they were deployed:
SELECT database_name, service, service_type, service_name,description, deployed, modified, context, user FROM WEBCONTAINER_ELEMENTS() WHERE input_deployed = true AND input_modified = true;
In this case, setting the last parameter (
null is equivalent because only deployed services are marked as