Each row in the SYSWEBSERVICE system view holds a description of a web service. The underlying system table for this view is ISYSWEBSERVICE.
|Column name||Column type||Column constraint|
|service_id||UNSIGNED INT||NOT NULL|
|object_id||UNSIGNED BIGINT||NOT NULL|
service_id A unique identifying number for the web service.
object_id The ID of the webservice.
service_name The name assigned to the web service.
service_type The type of the service; for example, RAW, HTTP, XML, SOAP, or DISH.
auth_required (Y/N) Indicates whether all requests must contain a valid user name and password.
secure_required (Y/N) Indicates whether insecure connections, such as HTTP, are to be accepted, or only secure connections, such as HTTPS.
url_path Controls the interpretation of URLs.
user_id If authentication is enabled, identifies the user, or group of users, that have permission to use the service. If authentication is disabled, specifies the account to use when processing requests.
parameter A prefix that identifies the SOAP services to be included in a DISH service.
statement A SQL statement that is always executed in response to a request. If NULL, arbitrary statements contained in each request are executed instead. Ignored for services of type DISH.
remarks Remarks about the webservice. This value is stored in the ISYSREMARK system table.
PRIMARY KEY (service_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL