Resolves to the output data, of the specified outputType, of the task instance that is resolving the function.

• If the output record of the specified ouptutType cannot be found, the function will remain unresolved.

${_output('outputType'[, 'defaultValue'])}

• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• defaultValue
  Optional; Default value to return if the output data is not found. Default is empty ('').

Resolves to the output data, of the specified outputType, of the task instance specified by the siblingName parameter.
 
The sibling task instance must be within the same workflow, and the Execution User of the task instance that is resolving the function must have Read permission for the sibling task instance.

• If the output record of the specified outputType cannot be found, the function will remain unresolved.

${_outputFromTask('siblingName', 'outputType'[, 'fileExtensiondefaultValue'])}

• siblingName
  Required; Name of a sibling task instance.
• outputType
  Required; Type of output to create a temporary file forresolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG, WEBSERVICE, SQL, STOREDPROC.
• fileExtensiondefaultValue
  Optional; The extension to use for the temporary file. Can be a maximum of 10 characters.
  • For SQL and STOREDPROC outputType, the result set is translated to comma-separated values (csv), or tab-separated values (tsv), and, therefore, only csv (default) and tsv are supported file extensions.
  • For any other outputType, the default file extension is txt.

Returns all SQL warnings from the current SQL or Stored Procedure task. Columns are separated by the specified separator and rows are separated by a new line.

${_SQLWarnings(['separator'])}

• separator
  Optional; Column separator. Default is comma (,).

Converts all of the characters in the variable to lower case using the rules of the default locale.

${_varToLowerCase('variableName')}

• variableName
  Required; Name of the variable being passed into the function.

Returns the length of value.

• Default value to return if the output data is not found. Default is empty ('').

Resolves to the number of lines of output data, of the specified outputType, of the task instance that is resolving the function.

• If the output record of the specified ouptutType cannot be found, the function will remain unresolved.

${_outputNumberOfLines('outputType')}

• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.

${_outputNumberOfLines('STDOUT')}
> 6

Resolves to the number of lines of output data, of the specified outputType, of the task instance specified by the siblingName parameter.

• The sibling task instance must be within the same workflow, and the Execution User of the task instance that is resolving the function must have Read permission for the sibling task instance.
• If the output record of the specified outputType cannot be found, the function will remain unresolved.

${_outputNumberOfLinesFromTask('siblingName', 'outputType')}

• siblingName
  Required; Name of a sibling task instance.
• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.

${_outputNumberOfLinesFromTask('test', 'STDOUT')}
> 8

Resolves to the specified line(s) of output data, of the specified outputType, of the task instance that is resolving the function.

• If the output record of the specified ouptutType cannot be found, the function will remain unresolved.

${_outputLines('outputType', startLine, numberOfLines[, 'defaultValue', 'resultDelimiter'])}

• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• startLine
  Required; Start line, where 1 is the first line and -1 is the last line.
• numberOfLines
  Required; Number of lines to return starting from the startLine.
• defaultValue
  Optional; Default value to return if no lines qualify. Default is empty ('')
• resultDelimiter
  Optional; Delimiter to use when concatenating matching lines. If not specified, "\n" or "\r\n" depending on original output line endings.

Resolves to the specified line(s) of output data, of the specified outputType, of the task instance specified by the siblingName parameter.
 
The sibling task instance must be within the same workflow, and the Execution User of the task instance that is resolving the function must have Read permission for the sibling task instance.

• If the output record of the specified outputType cannot be found, the function will remain unresolved.

${_outputLinesFromTask('siblingName', 'outputType', startLine, numberOfLines[, 'defaultValue', 'resultDelimiter'])}

• siblingName
  Required; Name of a sibling task instance.
• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• startLine
  Required; Start line, where 1 is the first line and -1 is the last line.
• numberOfLines
  Required; Number of lines to return starting from the startLine.
• defaultValue
  Optional; Default value to return if no lines qualify. Default is empty ('').
• resultDelimiter
  Optional; Delimiter to use when concatenating matching lines. If not specified, "\n" or "\r\n" depending on original output line endings.

Resolves to the line(s) of output data that match the specified regular expression, of the specified outputType, of the task instance that is resolving the function by specifying a regular expression.

• The complete output line is returned.
• If the output record of the specified ouptutType cannot be found, the function will remain unresolved.

${_outputLinesByRegex('outputType', 'regexPattern'[, maxCount, numberOfLinesBefore, numberOfLinesAfter, 'defaultValue', 'resultDelimiter'])}

• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• regexPattern
  Required; Regular expression used for determining if a line matches. Regular expression must match the whole line (see Example, below).
• maxCount
  Optional; Maximum number of matching lines to return. Default is 1.
• numberOfLinesBefore
  Optional; Number of lines before each matching line to return along with the matching line. Default is 0.
• numberOfLinesAfter
  Optional; Number of lines after each matching line to return along with the matching line. Default is 0.
• defaultValue
  Optional; Default value to return if no lines match the regular expression. Default is empty ('').
• resultDelimiter
  Optional; Delimiter to use when concatenating matching lines. If not specified, "\n" or "\r\n" depending on original output line endings.

STDOUT contains:
Some_Text
ABC=Some_String
More_Text
 
${_outputLinesByRegex('STDOUT', '^ABC=')} Returns empty (the whole Line was not matched)
${_outputLinesByRegex('STDOUT', '^ABC=.*')} Returns ABC=Some_String

Resolves to the line(s) of output data that match the specified regular expression, of the specified outputType, of the task instance specified by the siblingName parameter.
 
The sibling task instance must be within the same workflow, and the Execution User of the task instance that is resolving the function must have Read permission for the sibling task instance.

• If the output record of the specified outputType cannot be found, the function will remain unresolved.

${_outputLinesByRegexFromTask('siblingName', 'outputType', 'regexPattern'[, maxCount, numberOfLinesBefore, numberOfLinesAfter, 'defaultValue', 'resultDelimiter'])}

• siblingName
  Required; Name of a sibling task instance.
• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• regexPattern
  Required; Regular expression used for determining if a line matches.
• maxCount
  Optional; Maximum number of matching lines to return. Default is 1.
• numberOfLinesBefore
  Optional; Number of lines before each matching line to return along with the matching line. Default is 0.
• numberOfLinesAfter
  Optional; Number of lines after each matching line to return along with the matching line. Default is 0.
• defaultValue
  Optional; Default value to return if no lines match the regular expression. Default is empty ('').
• resultDelimiter
  Optional; Delimiter to use when concatenating matching lines. If not specified, "\n" or "\r\n" depending on original output line endings.

Resolves to the XML output data of the task instance that is resolving the function, corresponding to the evaluated XPath expression.

• If the output record cannot be found, the function will remain unresolved.

• If the output record is found, but the path expression does not yield a result, the function will resolve to the default value.

${_outputXPath('outputType', 'xPathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}

• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• xPathExpression
  Required; XPath expression. https://www.w3schools.com/xml/xpath_intro.asp
• defaultValue
  Optional; Default value to return if the result is not found. Default is empty ('').
• delimiter
  Optional; If xPathExpression evaluates to multiple results, the delimiter to be used to separate those results. Default is new line character (\n).
• prettyPrint
  Optional; Specification (true or false) for whether or not XML output will be pretty printed (indented). Default is false.

XML

<message>
  <code>10</code>
</message>

Function

${_outputXPath('STDOUT', '//code/text()')}

Result

10

Resolves to the XML output data of the task instance specified by the siblingName, corresponding to the evaluated XPath expression.

The sibling task instance must be within the same workflow and the Execution User of the task instance that is resolving the function must have Read permission for the sibling task instance.

• If the output record cannot be found, the function will remain unresolved.

• If the output record is found but the path expression does not yield a result, the function will resolve to the default value.

${_outputXPathFromTask('siblingName', 'outputType', 'xPathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}

• siblingName
  Required; Name of a sibling task instance.
• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• xPathExpression
  Required; XPath expression. https://www.w3schools.com/xml/xpath_intro.asp
• defaultValue
  Optional; Default value to return if the result is not found. Default is empty ('').
• delimiter
  Optional; If xPathExpression evaluates to multiple results, the delimiter to be used to separate those results. Default is new line character (\n).
• prettyPrint
  Optional; Specification (true or false) for whether or not XML output will be pretty printed (indented). Default is false.

XML

<message>
  <code>10</code>
</message>

Function

10

Resolves to the JSON output data of the task instance that is resolving the function, corresponding to the evaluated JsonPath expression.

• If the output record cannot be found, the function will remain unresolved.

• If the output record is found but the path expression does not yield a result, the function will resolve to the default value.

${_outputJsonPath('outputType', 'pathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}

• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• PathExpression
  Required; JsonPath expression. https://github.com/json-path/Jsonpath
• defaultValue
  Optional; Default value to return if the result is not found. Default is empty ('').
• delimiter
  Optional; If pathExpression evaluates to multiple results, the delimiter to be used to separate those results. Default is new line character (\n).
• prettyPrint
  Optional; Specification (true or false) for whether or not JSON output will be pretty printed (indented). Default is false.

JSON

{
  "code": 10
}

Function

${_outputJsonPath('STDOUT', '$.code')}

Result

10

Resolves to the JSON output data of the task instance specified by the siblingName, corresponding to the evaluated JsonPath expression.

The sibling task instance must be within the same workflow and the Execution User of the task instance that is resolving the function must have Read permission for the sibling task instance.

• If the output record cannot be found, the function will remain unresolved.

• If the output record is found but the path expression does not yield a result, the function will resolve to the default value

• siblingName
  Required; Name of a sibling task instance.
• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• PathExpression
  Required; JsonPath expression. https://github.com/json-path/Jsonpath
• defaultValue
  Optional; Default value to return if the result is not found. Default is empty ('').
• delimiter
  Optional; If pathExpression evaluates to multiple results, the delimiter to be used to separate those results. Default is new line character (\n).
• prettyPrint
  Optional; Specification (true or false) for whether or not JSON output will be pretty printed (indented). Default is false.

JSON

{
  "code": 10
}

Function

${_outputJsonPathFromTask('Sibling_With_JSON_Output', 'STDOUT', '$.code')}

Result

10

Resolves to the JSON output data of the task instance that is resolving the function, corresponding to the evaluated JsonPath expression.

• If the output record cannot be found, the function will remain unresolved.

• If the output record is found but the path expression does not yield a result, the function will resolve to the default value.

• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• PathExpression
  Required; JsonPath expression. https://github.com/json-path/Jsonpath
• defaultValue
  Optional; Default value to return if the result is not found. Default is empty ('').
• prettyPrint
  Optional; Specification (true or false) for whether or not JSON output will be pretty printed (indented). Default is false.

JSON

[
  {
    "message" : "Hello",
    "code" : 10
  },
  {
    "message" : "World!",
    "code" : 20
  }
]

Function

${_outputJsonPathAsArray('STDOUT', '$[*].message', '', true)}

Result

[
    "Hello",
    "World!"
]

Resolves to the JSON output data of the task instance specified by the siblingName, corresponding to the evaluated JsonPath expression.

The sibling task instance must be within the same workflow and the Execution User of the task instance that is resolving the function must have Read permission for the sibling task instance.

• If the output record cannot be found, the function will remain unresolved.

• If the output record is found but the path expression does not yield a result, the function will resolve to the default value.

• siblingName
  Required; Name of a sibling task instance.
• outputType
  Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
• PathExpression
  Required; JsonPath expression. https://github.com/json-path/Jsonpath
• defaultValue
  Optional; Default value to return if the result is not found. Default is empty ('').
• prettyPrint
  Optional; Specification (true or false) for whether or not JSON output will be pretty printed (indented). Default is false.

JSON

[
  {
    "message" : "Hello",
    "code" : 10
  },
  {
    "message" : "World!",
    "code" : 20
  }
]

Function

${_outputJsonPathAsArrayFromTask('Sibling_With_JSON_Output', 'STDOUT', '$[*].message')}

Result
["Hello","World!"]

Returns a token representing the path to a temporary file containing the specified task instance output data.

• $(ops_output_path_<instanceId>_<outputType>_<fileExtension>)

The resolved token is supported within the Command, Parameters, and Script of a Windows and Linux/Unix Task.

${_outputPath('outputType'[, 'fileExtension'])}


• outputType
  Required; Type of output to create a temporary file for: STDOUT, STDERR, FILE, EXTENSION, JOBLOG, WEBSERVICE, SQL, STOREDPROC.
• fileExtension
  Optional; The extension to use for the temporary file. Can be a maximum of 10 characters.
  • For SQL and STOREDPROC outputType, the result set is translated to comma-separated values (csv), or tab-separated values (tsv), and, therefore, only csv (default) and tsv are supported file extensions.
  • For any other outputType, the default file extension is txt.

Returns a token representing the path to a temporary file containing the specified sibling task instance output data.

• $(ops_output_path_<instanceId>_<outputType>_<fileExtension>)

The resolved token is supported within the Command, Parameters, and Script of a Windows and Linux/Unix Task.

${_outputPathFromTask('siblingName', 'outputType'[, 'fileExtension'])}


• siblingName
  Required; Name of a sibling task instance.
• outputType
  Required; Type of output to create a temporary file for: STDOUT, STDERR, FILE, EXTENSION, JOBLOG, WEBSERVICE, SQL, STOREDPROC.
• fileExtension
  Optional; The extension to use for the temporary file. Can be a maximum of 10 characters.
  • For SQL and STOREDPROC outputType, the result set is translated to comma-separated values (csv), or tab-separated values (tsv), and, therefore, only csv (default) and tsv are supported file extensions.
  • For any other outputType, the default file extension is txt.

Returns a token representing the property associated with an SAP connection

${_sapConnection('<sapConnection_name>', '<property-name>')}

• sapConnection_name
  Required; Name of the SAP Connection.

• property_name
  Required; Name of the SAP Connection property.

${_sapConnection('sap1', 'sap_connection_type')}
→ $(ops_unv_sap_connection_sap_connection_type_3ac17d7f3ecb4df0b81aec9c7a24a38c)

Returns a token representing the path to a Data Script that you want to embed.

${_scriptPath('script_name')}

• script_name
  Required; Name of the Data Script.

Returns the column names for the SQL results from the current SQL or Stored Procedure task. Column names are separated by the specified separator.

${_resultsColumnNames(['separator'])}

• separator
  Optional; Column name separator. Default is comma (,).

Returns the column names for the SQL results from a sibling SQL or Stored Procedure task, within the same workflow. Column names are separated by the specified separator.

${_resultsColumnNamesFromTask('name'[, 'separator'])}

• name
  Required; Name of the sibling task that the results should come from. The task must be within the same workflow.
• separator
  Optional; Column name separator. Default is comma (,).

Returns all SQL results from the current SQL or Stored Procedure task. Columns are separated by the specified separator and rows are separated by a new line.

${_resultsAll(['separator', 'rowSeparator'])}

• separator
  Optional; Column separator. Default is comma (,).
• rowSeparator
  Optional; Overrides default New Line character.

Returns all SQL results from a sibling SQL or Stored Procedure task, within the same workflow. Columns are separated by the specified separator and rows are separated by a new line.

${_resultsAllFromTask('name'[, 'separator', 'rowSeparator'])}

• name
  Required; Name of the task that the results should come from. The task must be within the same workflow.
• separator
  Optional; Column separator. Default is comma (,).
• rowSeparator
  Optional; Overrides default New Line character.

Returns all SQL warnings from the current SQL or Stored Procedure task. Columns are separated by the specified separator and rows are separated by a new line.

${_SQLWarnings(['separator'])}

• separator
  Optional; Column separator. Default is comma (,).

Returns all SQL warnings from a sibling SQL or Stored Procedure task, within the same workflow. Columns are separated by the specified separator and rows are separated by a new line.

${_SQLWarningsFromTask('name'[, 'separator'])}

• name
  Required; Name of the sibling task that the warnings should come from. The task must be within the same workflow.
• separator
  Optional; Column separator. Default is comma (,).

Returns the string value of a row/column from a previously executed SQL task within the same workflow, or from the current SQL task.

${_resultsColumn('name', 'colname'[, rownum, 'default_value'])}

• name
  Required; Name of a sibling SQL task within the same workflow from which you want the function to fetch results. If you want to execute the function against the current task, use an empty string for the name parameter.
• colname
  Required; Name of column to retrieve.
• rownum
  Optional; Numeric row number in result set to retrieve. Default is 1.
• default_value
  Optional; Default value to return if result not found.

Returns the string value of a row/column from a previously executed SQL task within the same workflow, or from the current SQL task.

${_resultsColumnByNo('name', colnum[, rownum, 'default_value'])}

• name
  Required; Name of a sibling SQL task within the same workflow from which you want the function to fetch results. If you want to execute the function against the current task, use an empty string for the name parameter.
• colnum
  Required; Number of column to retrieve. First column in result is 1, second is 2, and so on.
• rownum
  Optional; Numeric row number in result set to retrieve. Default is 1.
• default_value
  Optional; Default value to return if result not found.

Returns the string values of columns in a specific row in CSV (comma-separated values) format, from a previously executed SQL task within the same workflow, or from the current SQL task.

${_resultsColumnsCSV('name'[, rownum])}

• name
  Required; Name of a sibling SQL task within the same workflow from which you want the function to fetch results. If you want to execute the function against the current task, use an empty string for the name parameter.
• rownum
  Optional; Numeric row number in result set to retrieve. Default is 1.

\t

Insert a tab in the text at this point.

\b

Insert a backspace in the text at this point.

\n

Insert a newline in the text at this point.

\r

Insert a carriage return in the text at this point.

\f

Insert a formfeed in the text at this point.

\'

Insert a single quote character in the text at this point.

\"

Insert a double quote character in the text at this point.

\\

Insert a backslash character in the text at this point.

Converts all of the characters in the value to lower case using the rules of the default locale.

${_toLowerCase('value')}

• value
  Required; Any stringString to convert to lower case.

Converts all of the characters in the variable to lower case using the rules of the default locale.

${_varLengthvarToLowerCase('variableName'[, useEmptyForUndefined])}

• variableName
  Required; Name of the variable being passed into the function

• .

Converts all of the characters in the value to upper case using the rules of the default locale.

${_substringtoUpperCase('value', beginIndex[, endIndex])}

• value
  Required; String to

• convert to upper case.

Converts all of the characters in the variable to upper case using the rules of the default locale.

${_

varToUpperCase('