Returns a conditional value depending on the equality of two string parameters.
 
(Returns if_value if string value1 is equal to string value2; otherwise, else_value is returned.)

${_ifEqual('value1', 'value2', 'if_value', 'else_value'[, ignore_case])}

• value1
  Required; First string.
• value2
  Required; Second string.
• if_value
  Required; Return value if value1 equals value2.
• else_value
  Required; Return value if value1 does not equal value2.
• ignore_case
  Optional; Specification (true or false) whether or not to ignore case when comparing value1 and value2. Default is false.

Returns a conditional value depending on the value of a boolean parameter.
 
Returns if_value if value is true; otherwise, else_value is returned.

${_ifTrue(value, 'if_value', 'else_value')}

• value
  Required; Boolean value (true or false).
• if_value
  Required; Return value if value is true.
• else_value
  Required; Return value if value is false.

Returns a token representing the Credentials#Resolvable Credentials Key Location that you want to embed.

${_credentialKeyLoc('<credential_name>')}

• credential_name
  Required; Name of the Credential.

Returns a token representing the Credentials#Resolvable Credentials Passphrase that you want to embed.

${_credentialPassphrase('<credential_name>')}

• credential_name
  Required; Name of the Credential.

Returns a token representing the Credentials#Resolvable Credentials Token that you want to embed.

${_credentialToken('<credential_name>')}

• credential_name
  Required; Name of the Credential.

Returns a token representing the Credentials#Resolvable Credentials Runtime User that you want to embed.

${_credentialUser('<credential_name>')}

• credential_name
  Required; Name of the Credential.

Returns a token representing the Credentials#Resolvable Credentials Runtime Password that you want to embed.

${_credentialPwd('<credential_name>')}

• credential_name
  Required; Name of the Credential.

Returns a token representing the property associated with a Database connection.

${_databaseConnection('<database_connection_name>', '<property_name>')}

• database_connection_name
  Required; Name of the Database Connection.

• property_name
  Required; Name of the Database Connection property.

  • description
  • name
  • url
  • driver
  • max_rows
  • type
  • cred_user
  • cred_pwd
  • cred_passphrase
  • cred_key_lock
  • cred_token

Checks if a date argument is equal to today's date in the specified format.
 
Returns true if date is equal to today's date in the specified format; otherwise, false is returned.

${_isToday('date'[, 'format', is_relative])}

• date
  Required; Date to compare to today's date.
• format
  Optional; Format of today's date. Default is yyyy-MM-dd.
• is_relative
  Optional; Specification (true or false) for whether today's date is relative to the trigger/launch time of the task instance. Default is false.

Resolves to the current date and time.

${_date(['format', day_offset, hour_offset, minute_offset])}

Resolves to the current date and time.

${_dateadv(['format', year_offset, month_offset, day_offset, hour_offset, minute_offset])}

Resolves to the current time in milliseconds since Wed Dec 31 1969 19:00:00 GMT-0500 (EST) – the start of Unix epoch time.

${_currentTimeMillis}

n/a

${_formatDate(['date_time', 'format', day_offset, use_business_days, hour_offset, minute_offset, timezone])}

${_formatDateAdv(['date_time', 'format', year_offset, month_offset, day_offset, use_business_days, hour_offset, minute_offset, timezone])}

${_formatDateTz('date_time', 'target_time_zone'[, 'output_format'])}

Returns the day of week for the specified date as a number.

${_dayOfWeek(['date', 'first_dow', first_dow_value])}

${_daysBetween('date1', 'date2')}

${_nonBusinessDayOfMonth(index, ['date', 'format', reverse])}

${_businessDayOfMonth(index, ['date', 'format', reverse])}

Returns the Nth day of month for the month of the date specified. Optionally, can start from the end of the month.

${_dayOfMonth(index, ['date', 'format', reverse])}

${_businessDaysBetween('date1', 'date2')}

Return the sum of the augend added with the addend.

${_add(augend, addend)}

• augend
  Integer to which the addend is being added.
• addend
  Integer being added to the augend.

Return the quotient of the dividend divided by divisor.

${_divide(dividend, divisor)}

• dividend
  Integer being divided by the divisor.
• divisor
  Integer being used to divide the dividend.

Return the product of the multiplicand multiplied with the multiplier.

${_multiply(multiplicand, multiplier)}

• multiplicand
  Integer being multiplied by the multiplier.
• multiplier
  Integer being used to multiply the multiplicand.

Return the absolute value of the parameter.

{_abs(parameter)}

• parameter
  Integer (positive or negative value).

Return the modulo (remainder) of the dividend divided by divisor.

${_mod(dividend, divisor)}

• dividend
  Integer being divided by the divisor.
• divisor
  Integer being used to divide the dividend.

Return the difference of the subtrahend subtracted from the minuend.

${_subtract(minuend, subtrahend)}

• minuend
  Integer from which the subtrahend is being subtracted.
• subtrahend
  Integer being subtracted from the minuend.

Resolves to a delimited list of business service names the task instance is a member of.

${_businessServices(['resultDelimiter'])}

• resultDelimiter
  Optional; Delimiter to use when concatenating business service names. If not specified, ", " will be used.

Resolves to the record count of CSV data for the specified output Type.

• If the output record of the specified ouptutType cannot be found, the function will remain unresolved.
• If the output is blank, the function will resolve to 0.

${_outputCsvRecordCount('<outputType>')}

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

data="A","B","C","D"\n
     "E","F","G","H"
${_outputCsvRecordCount('STDERR')}
> 2

Resolves to the value of CSV data for the specified record index & value index of the specified outputType.

• If the output record of the specified ouptutType cannot be found, the function will remain unresolved.
• If the output is blank, the function will remain unresolved.
• If an index is invalid, the function will remain unresolved.

${_outputCsvRecordValue('outputType', recordIndex, valueIndex)}

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

• recordIndex
  Required; record index number.

• valueIndex
  Required; record index number.

data="A","B","C","D"\n
     "E","F","G","H"
${_varCsvRecordValue('STDOUT','1', '2')}
> G

Resolves to the record count of TSV data for the specified outputType value.

• If the output record of the specified ouptutType cannot be found, the function will remain unresolved.
• If the output is blank, the function will resolve to 0.

${_outputTsvRecordCount('<outputType>')}

• outputType
  Required; Name of the variable.

data="A" "B" "C" "D"\n
     "E" "F" "G" "H"
${_outputTsvRecordCount('STDERR')}
> 2

Resolves to the count of TSV data for the specified record index of the specified outputType.

• If the output record of the specified ouptutType cannot be found, the function will remain unresolved.
• If the output is blank, the function will resolve to 0.
  
• If an index is invalid, the function will resolve to 0.

${_outputTsvRecordValueCount('outputType', recordIndex)}

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

• recordIndex
  Required; record index number.

data="A"  "B" "C" "D"\n
     "E"  "F"  "G"  "H"
${_outputTsvRecordValueCount('STDERR','1')}
> 4

Resolves to the value of TSV data for the specified record index & value index of the specified outputType.

• If the output record of the specified ouptutType cannot be found, the function will remain unresolved.
• If the output is blank, the function will remain unresolved.
• If an index is invalid, the function will remain unresolved.

${_outputTsvRecordValue('outputType', recordIndex, valueIndex)}

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

• recordIndex
  Required; record index number.

• valueIndex
  Required; record index number.

data="A"  "B" "C" "D"\n
     "E"  "F" "G" "H"
${_outputTsvValue('my_variable','1', '2')}
> G

Resolves to the record count of CSV 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.

• If the output is blank, the function will resolve to 0.

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

• siblingName
  Required; Name of a sibling task instance.

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

data="A","B","C","D"\n
     "E","F","G","H"
${_outputCsvRecordCountFromTask('task-1','STDERR')}
> 2

Resolves to the value of CSV output data, of the specified outputType, recordIndex & valueIndexof 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.

• If the output is blank, the function will remain unresolved.
• If an index is invalid, the function will remain unresolved.

${_outputCsvRecordValueFromTask('siblingName','outputType', recordIndex, valueIndex)}

• siblingName
  Required; Name of a sibling task instance.

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

• recordIndex
  Required; record index number.

• valueIndex
  Required; record index number.

data="A","B","C","D"\n
     "E","F","G","H"
${_outputCsvRecordValueFromTask('task-1','STDOUT','1', '2')}
> G

Resolves to the record count of TSV 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.

• If the output is blank, the function will resolve to 0.

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

• siblingName
  Required; Name of a sibling task instance.

• outputType
  Required; Name of the variable.

data="A" "B" "C" "D"\n
     "E" "F" "G" "H"
${_outputTsvRecordCountFromTask('task-1','STDERR')}
> 2

Resolves to the value count of TSV output data, of the specified outputType, & recordIndexof 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.

• If the output is blank, the function will resolve to 0.
  
• If an index is invalid, the function will resolve to 0.

${_outputTsvRecordValueCountFromTask('siblingName','outputType', 'recordIndex')}

• siblingName
  Required; Name of a sibling task instance.

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

• recordIndex
  Required; record index number.

data="A"  "B" "C" "D"\n
     "E"  "F"  "G"  "H"
${_outputTsvRecordValueCountFromTask('task-1','STDERR','1')}
> 4

Resolves to the value of TSV output data, of the specified outputType, recordIndex & valueIndexof 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.

• If the output is blank, the function will remain unresolved.
• If an index is invalid, the function will remain unresolved.

${_outputTsvRecordValueFromTask('siblingName','outputType', recordIndex, valueIndex)}

• siblingName
  Required; Name of a sibling task instance.

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

• recordIndex
  Required; record index number.

• valueIndex
  Required; record index number.

data="A"  "B" "C" "D"\n
     "E"  "F" "G" "H"
${_outputTsvRecordValueFromTask('task-1','STDOUT','1', '2')}
> G

Resolves to the count of comma delimited 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.

• If the output is blank, the function will resolve to 0.

${_outputDelimitedValueCount('outputType', [delimiter])}

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

• delimiter
  Optional;delimiter to split the output. default delimiter is comma(,).

data= A,B,C,D
${_outputDelimitedValueCount('STDOUT')}
> 4

Resolves to the value of specified valueIndex for comma delimited 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.

• If the output is blank, the function will remain unresolved.
• If an index is invalid, the function will remain unresolved.

${_outputDelimitedValue('outputType', valueIndex,[delimiter])}

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

• valueIndex
  Required; record index number.

• delimiter
  Optional; delimiter to split the output. default delimiter is comma(,).

data=A,B,C,D
${_outputDelimitedValue('STDOUT','2')}
> C

Resolves to the count of comma delimited output data, of the specified outputType, of the task instance specified by the siblingName parameter.

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

• If the output is blank, the function will resolve to 0.

${_outputDelimitedValueCountFromTask('siblingName','outputType', [delimiter])}

• siblingName
  Required; Name of a sibling task instance.

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

• delimiter
  Optional;delimiter to split the output. default delimiter is comma(,).

data=A,B,C,D
${_outputDelimitedValueCountFromTask('task-1','STDOUT')}
> 4

Resolves to the value of specified valueIndex for comma delimited output data, of the specified outputType, of the task instance specified by the siblingName parameter.

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

• If the output is blank, the function will remain unresolved.
• If an index is invalid, the function will remain unresolved.

${_outputDelimitedValueFromTask('siblingName','outputType', valueIndex,[delimiter])}

• siblingName
  Required; Name of a sibling task instance.

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

• valueIndex
  Required; record index number.

• delimiter
  Optional;delimiter to split the output. default delimiter is comma(,).

data=A:B:C:D
${_outputDelimitedValueFromTask('task-1','STDOUT','2')}
> C

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'[, 'defaultValue'])}

• siblingName
  Required; Name of a sibling task instance.
• 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 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('<sap_connection_name>', '<property_name>')}

• sap_connection_name
  Required; Name of the SAP Connection.

• property_name
  Required; Name of the SAP Connection property.

  • description

  • name

  • sap_ashost

  • sap_client

  • sap_connection_type

  • sap_group

  • sap_gwhost

  • sap_gwserv

  • sap_mshost

  • sap_mysapsso2

  • sap_r3name

  • sap_saprouter

  • sap_snc_lib

  • sap_snc_mode

  • sap_snc_myname

  • sap_snc_partnername

  • sap_snc_qop

  • sap_snc_sso

  • sap_sysnr

  • sap_use_symbolic_names

  • sap_x509cert

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

Returns a token representing the path to a Scripts#Data Scripts that you want to Scripts#Embedding a Data Script.

${_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.