Versions Compared

Key

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

...

Anchor
Stored Procedure Task XML and JSON Examples
Stored Procedure Task XML and JSON Examples
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

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.

...