Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

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
titleXML
<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
titleJSON
{
  "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.

...