Overview

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

Create a Stored Procedure Task
Modify a Stored Procedure Task
Read a Stored Procedure Task

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.

For information on Task web services that are applicable to all task types, see:

Create a Stored Procedure Task

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

Modify a Stored Procedure 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 Stored Procedure Task properties without modifying related records, use the excludeRelated property.
Example	See Stored Procedure Task: XML and JSON Examples.
Properties	See Properties.
Example Response	Status 200 /OK Successfully updated the <task type> task with sysId <sysId> to version <version>.

Read a Stored Procedure 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 Stored Procedure Task: XML and JSON Examples.) Status 404 /Not Found A task with id "f87848b00a0001037f43e7c81c8ec969" does not exist.
Properties	See Properties.

Stored Procedure Task: XML and JSON Examples

The retainSysIdsand versionproperties are specified as attributes in XML.

The exportReleaseLevel and exportTable properties are specified as attributes in XML.

Examples

XML

JSON

Example for Task

XML

<taskStoredProc exportReleaseLevel="7.2.0.0" exportTable="ops_task_stored_proc"  retainSysIds="true" version="1">
       <actions />
       <variables />
       <notes />
       <virtualResources />
       <exclusiveTasks />
       <storedProcParams>
           <storedProcParam>
               <description />
               <isNull>false</isNull>
               <ivalue>13</ivalue>
               <ovalue />
               <paramMode>Input</paramMode>
               <paramType>INTEGER</paramType>
               <paramVar />
               <pos>1</pos>
               <sysId>08e68258e82149b18b94d4f3527da80b</sysId>
               <variableScope>Self</variableScope>
           </storedProcParam>
           <storedProcParam>
               <description />
               <isNull>false</isNull>
               <ivalue>Parameter 3 Input</ivalue>
               <ovalue />
               <paramMode>Input/Output</paramMode>
               <paramType>VARCHAR</paramType>
               <paramVar>Param3Output</paramVar>
               <pos>3</pos>
               <sysId>8893777c75634d68a056df3943f99931</sysId>
               <variableScope>Self</variableScope>
           </storedProcParam>
           <storedProcParam>
               <description />
               <isNull>false</isNull>
               <ivalue />
               <ovalue />
               <paramMode>Output</paramMode>
               <paramType>TIMESTAMP</paramType>
               <paramVar>Parameter2</paramVar>
               <pos>2</pos>
               <sysId>acf8c0205eee4b3e816c448fd37ed048</sysId>
               <variableScope>Self</variableScope>
           </storedProcParam>
       </storedProcParams>
       <avgRunTime>3</avgRunTime>
       <avgRunTimeDisplay>3 Seconds</avgRunTimeDisplay>
       <cpDuration />
       <cpDurationUnit>Minutes</cpDurationUnit>
       <credentials />
       <credentialsVar />
       <customField1 label="Domain">web.com</customField1>
       <customField2 />
       <efDayConstraint>Nth</efDayConstraint>
       <efDuration>00:00:00:00</efDuration>
       <efEnabled>false</efEnabled>
       <efNthAmount>10</efNthAmount>
       <efOffsetDuration />
       <efOffsetDurationUnit>Minutes</efOffsetDurationUnit>
       <efOffsetPercentage>0</efOffsetPercentage>
       <efOffsetType>Percentage</efOffsetType>
       <efTime>00:00</efTime>
       <efType>Time</efType>
       <executionRestriction>Run</executionRestriction>
       <firstRun>2021-03-15 13:59:37 -0400</firstRun>
       <holdResources>false</holdResources>
       <lastRun>2021-03-16 17:12:42 -0400</lastRun>
       <lastRunTime>9</lastRunTime>
       <lastRunTimeDisplay>9 seconds</lastRunTimeDisplay>
       <lfDayConstraint>Nth</lfDayConstraint>
       <lfDuration>00:00:00:00</lfDuration>
       <lfEnabled>false</lfEnabled>
       <lfNthAmount>1</lfNthAmount>
       <lfOffsetDuration />
       <lfOffsetDurationUnit>Minutes</lfOffsetDurationUnit>
       <lfOffsetPercentage>0</lfOffsetPercentage>
       <lfOffsetType>Percentage</lfOffsetType>
       <lfTime>00:00</lfTime>
       <lfType>Time</lfType>
       <lsDayConstraint>Nth</lsDayConstraint>
       <lsDuration>00:00:00:00</lsDuration>
       <lsEnabled>false</lsEnabled>
       <lsNthAmount>7</lsNthAmount>
       <lsTime>00:00</lsTime>
       <lsType>Time</lsType>
       <maxRunTime>9</maxRunTime>
       <maxRunTimeDisplay>9 Seconds</maxRunTimeDisplay>
       <minRunTime>3</minRunTime>
       <minRunTimeDisplay>3 Seconds</minRunTimeDisplay>
       <name>uc - Test Email</name>
       <opswiseGroups /> 
       <resolveNameImmediately>false</resolveNameImmediately>
       <resPriority>10</resPriority>
       <restrictionPeriod>Span</restrictionPeriod>
       <restrictionPeriodAfterDate>2017-11-10</restrictionPeriodAfterDate>
       <restrictionPeriodAfterTime>10:30</restrictionPeriodAfterTime>
       <restrictionPeriodBeforeDate>2017-11-20</restrictionPeriodBeforeDate>
       <restrictionPeriodBeforeTime>15:00</restrictionPeriodBeforeTime>
       <restrictionPeriodDateList />
       <runCount>32</runCount>
       <runTime>108</runTime>
       <startHeld>false</startHeld>
       <startHeldReason /> 
       <summary>Test Email</summary>
       <sysId>fb59a227517a421a92c15ff5aefe3b66</sysId>
       <timeZonePref>-- System Default --</timeZonePref>
       <twDelayAmount />
       <twDelayDuration>00:00:00:00</twDelayDuration>
       <twDelayType>None</twDelayType>
       <twWaitAmount />
       <twWaitDayConstraint>NONE</twWaitDayConstraint>
       <twWaitDuration>00:00:00:00</twWaitDuration>
       <twWaitTime>00:00</twWaitTime>
       <twWaitType>None</twWaitType>
       <twWorkflowOnly>-- System Default --</twWorkflowOnly>
       <userEstimatedDuration />
       <autoCleanup>false</autoCleanup>
       <columnName />
       <connection>uc - Db Connection</connection>
       <connectionVar />
       <exitCodes />
       <maxRows />
       <parameterPosition>1</parameterPosition>
       <resultOp>=</resultOp>
       <resultProcessing>Skip Result Processing</resultProcessing>
       <resultValue />
       <retryIndefinitely>false</retryIndefinitely>
       <retryInterval>60</retryInterval>
       <retryMaximum>0</retryMaximum>
       <retrySuppressFailure>false</retrySuppressFailure>
       <storedProcName>sproc1</storedProcName>
</taskStoredProc>

JSON

{
  "type": "taskStoredProc",
  "actions": {
    "abortActions": [],
    "emailNotifications": [],
    "setVariableActions": [],
    "snmpNotifications": [],
    "systemOperations": []
  },
  "autoCleanup": false,
  "avgRunTime": 3,
  "avgRunTimeDisplay": "3 Seconds",
  "columnName": null,
  "connection": "uc - Db Connection",
  "connectionVar": null,
  "cpDuration": null,
  "cpDurationUnit": "Minutes",
  "credentials": null,
  "credentialsVar": null,
  "customField1": {
    "label": "Domain",
    "value": "http://qa-cntlr-mssql:8080/uc/"
  },
  "customField2": {
    "label": null,
    "value": null
  },
  "efDayConstraint": "Nth Day",
  "efDuration": "00:00:00:00",
  "efEnabled": false,
  "efNthAmount": 10,
  "efOffsetDuration": null,  
  "efOffsetDurationUnit": "Minutes",
  "efOffsetPercentage": 0,
  "efOffsetType": "Percentage",
  "efTime": "00:00",
  "efType": "Time",
  "excludeRelated": false,
  "exclusiveTasks": [],
  "executionRestriction": "Run",
  "exportReleaseLevel": "7.2.0.0",
  "exportTable": "ops_task_stored_proc",
  "firstRun": "2021-03-15 13:59:37 -0400",
  "holdResources": false,
  "lastRun": "2021-03-16 17:12:42 -0400",
  "lastRunTime": 9,
  "lastRunTimeDisplay": "9 Seconds",
  "lfDayConstraint": "Nth Day",
  "lfDuration": "00:00:00:00",
  "lfEnabled": false,
  "lfNthAmount": 1,
  "lfOffsetDuration": null,  
  "lfOffsetDurationUnit": "Minutes",
  "lfOffsetPercentage": 0,
  "lfOffsetType": "Percentage",
  "lfTime": "00:00",
  "lfType": "Time",
  "lsDayConstraint": "Nth Day",
  "lsDuration": "00:00:00:00",
  "lsEnabled": false,
  "lsNthAmount": 7,
  "lsTime": "00:00",
  "lsType": "Time",
  "maxRows": null,
  "maxRunTime": 9,
  "maxRunTimeDisplay": "9 Seconds",
  "minRunTime": 3,
  "minRunTimeDisplay": "3 Seconds",
  "name": "uc - Test Email",
  "notes": [],
  "opswiseGroups": null, 
  "parameterPosition": 1,
  "resolveNameImmediately": false,
  "resPriority": 10,
  "restrictionPeriod": "Span",
  "restrictionPeriodAfterDate": "2017-11-10",
  "restrictionPeriodAfterTime": "10:30",
  "restrictionPeriodBeforeDate": "2017-11-20",
  "restrictionPeriodBeforeTime": "15:00",
  "restrictionPeriodDateList": [],
  "resultOp": "=",
  "resultProcessing": "Skip Result Processing",
  "resultValue": null,
  "retainSysIds": true,
  "retryIndefinitely": false,
  "retryInterval": 60,
  "retryMaximum": 0,
  "retrySuppressFailure": false,
  "runCount": 32,
  "runTime": 108,
  "startHeld": false,
  "startHeldReason": null,  
  "storedProcName": "sproc1",
  "storedProcParams": [
  {
    "description": null,
    "isNull": false,
    "ivalue": "13",
    "ovalue": null,
    "paramMode": "Input",
     "paramType": "INTEGER",
    "paramVar": null,
    "pos": 1,
    "sysId": "08e68258e82149b18b94d4f3527da80b",
    "variableScope": "Self"
  },
  {
    "description": null,
    "isNull": false,
    "ivalue": "Parameter 3 Input",
    "ovalue": null,
    "paramMode": "Input/Output",
    "paramType": "VARCHAR",
    "paramVar": Param3Output,
    "pos": 3,
    "sysId": "8893777c75634d68a056df3943f99931",
    "variableScope": "Self"
  },
  {
    "description": null,
    "isNull": false,
    "ivalue": null,
    "ovalue": null,
    "paramMode": "Output",
    "paramType": "TIMESTAMP",
    "paramVar": Parameter2,
    "pos": 2,
    "sysId": "acf8c0205eee4b3e816c448fd37ed048",
    "variableScope": "Self"
  }
  ],
  "summary": "Test Email",
  "sysId": "fb59a227517a421a92c15ff5aefe3b66",
  "timeZonePref": "-- System Default --",
  "twDelayAmount": null,
  "twDelayDuration": "00:00:00:00",
  "twDelayType": "None",
  "twWaitAmount": null,
  "twWaitDayConstraint": "NONE",
  "twWaitDuration": "00:00:00:00",
  "twWaitTime": "00:00",
  "twWaitType": "None",
  "twWorkflowOnly": "-- System Default --",
  "userEstimatedDuration": null,
  "variables": [],
  "version": 1,
  "virtualResources": []
}

See Task Web Services - Task Actions for XML and JSON examples of task actions.

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

Properties

See All Tasks Properties
See Stored Procedure Task Properties

Browser not supported