...

Universal Controller supports the following RESTful-based web services for SQL Task operations, which are listed alphabetically on this page.

Formatting specifications for each web service, including details about parameter requirements, are provided.

Links to detailed information about the properties used in these web services also is located on this page.

...

Anchor

	Create a SQL Task
	Create a SQL Task

Create a SQL Task

	Description
URI	http://host_name/uc/resources/task
HTTP Method	POST
Description	Creates a new SQL task.
Example URI	http://localhost:8080/uc/resources/task To persist sysIds, use the retainSysIds property.
Consumes Content-Type	application/xml, application/json
Produces Content-Type	n/a
Example	See SQL Task: XML and JSON Examples, below.
Properties	See SQL Task Web Services#Properties 63547917.
Example Response	Status 200 /OK Successfully created the <task type> task with sysId <sysId>.

Anchor

	Modify a SQL Task
	Modify a SQL Task

Modify a SQL Task

	Description
URI	http://host_name/uc/resources/task
Consumes Content-Type	application/xml, application/json
Produces Content-Type	n/a
HTTP Method	PUT
Description	Modifies the task specified by the sysId in the request. To modify SQL Task properties without modifying related records, use the excludeRelated property.
Example	See SQL Task: XML and JSON Examples.
Properties	See SQL Task Web Services#Properties 63547917.
Example Response	Status 200 /OK Successfully updated the <task type> task with sysId <sysId> to version <version>.

Anchor

	Read a SQL Task
	Read a SQL Task

	Description
URI	http://host_name/uc/resources/task
HTTP Method	GET
Description	Retrieves information on the specified task.
Request Parameters	`taskid` or `taskname`
Mutually Exclusive Parameters	`taskid` and `taskname`
Example URI	http://localhost:8080/uc/resources/task?taskname=testTask http://localhost:8080/uc/resources/task?taskid=d26265a2c4f345359d9b356f18a462c1
Consumes Content-Type	n/a
Produces Content-Type	application/xml, application/json
Example Response	Status 200 /OK (See SQL Task: XML and JSON Examples.) Status 404 /Not Found A task with id "f87848b00a0001037f43e7c81c8ec969" does not exist.
Properties	See SQL Task Web Services#Properties 63547917.

Anchor

	SQL Task XML and JSON Examples
	SQL Task XML and JSON Examples

The retainSysIds and version properties are specified as attributes in XML.

...

See Task Web Services - Task-Related Records for XML and JSON examples of task-related records.

Anchor

	Properties
	Properties