Page Comparison

...

Universal Controller supports the following RESTful-based web services for Stored Procedure 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.

...

	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 63548171 Properties.
Example Response	Status 200 /OK Successfully created the <task type> task with sysId <sysId>.

...

	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 63548171 Properties.
Example Response	Status 200 /OK Successfully updated the <task type> task with sysId <sysId> to version <version>.

...

	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 63548171 Properties.

Anchor

	Stored Procedure Task XML and JSON Examples
	Stored Procedure Task XML and JSON Examples

...

Examples

XML

JSON

Example for Task

Expand

title	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>

Expand

title	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.

...

Versions Compared

Old Version 2

New Version Current

Key