Stored Procedure Task Web Services

Owned by Former user (Deleted)
Mar 16, 2022
8 min read

Overview

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.
 

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

Consumes Content-Type

n/a

Produces Content-Type

application/xml, application/json

Example Response

Properties

See Properties.

Stored Procedure Task: XML and JSON Examples

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

The exportReleaseLevel and /wiki/spaces/UC71x/pages/5179227 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