Returns a token representing the Resolvable Credential 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 Resolvable Credential Credentials#Resolvable Credentials Passphrase that you want to embed.

${_credentialPassphrase('<credential_name>')}

• credential_name
  Required; Name of the Credential.

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

${_credentialToken('<credential_name>')}

• credential_name
  Required; Name of the Credential.

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

${_credentialUser('<credential_name>')}

• credential_name
  Required; Name of the Credential.

${_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])}

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

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

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

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

• 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 Data Script Scripts#Data Scripts that you want to embed Scripts#Embedding a Data Script.

${_scriptPath('script_name')}

• script_name
  Required; Name of the Data Script.

Randomly generates a String with a specified length.

${_randomString(length[, 'excludeCharacters', 'defaultCharacters'])}

Replaces each substring of value that matches the specified regular expression Wildcards and Regular Expressions, regex, with the specified replacement.

${_replaceAll('value', 'regex', 'replacement')}

• value
  Required; Input string.
• regex
  Required; Regular expression.
• replacement
  Required; Replacement string.

Replaces each substring of variableName that matches the specified regular expression Wildcards and Regular Expressions, regex, with the specified replacement.

${_varReplaceAll('variableName', 'regex', 'replacement')}

• variableName
  Required; Name of the variable being passed into the function.
• regex
  Required; Regular expression.
• replacement
  Required; Replacement string.

Resolves to the evaluated JsonPath expression applied to the value of the specified variable.

• If the variable is unresolved, the function will remain unresolved.

• If the variable is undefined, blank, or the path expression does not yield a result, the function will resolve to the default value.

${_varJsonPath('variableName', 'pathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}

variableName
Required; The name of the variable to apply the JsonPath expression to.

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 will be pretty printed (indented). Default is false.

my_variable=
{
  "code": 10
}

${_varJsonPath('my_variable', '$.code')}
> 10

Resolves to the evaluated JsonPath expression applied to the value of the specified variable.

• If the variable is unresolved, the function will remain unresolved.

• If the variable is undefined, blank, or the path expression does not yield a result, the function will resolve to the default value.

${_varJsonPathAsArray('variableName', 'pathExpression'[, 'defaultValue', prettyPrint])}

variableName
Required; The name of the variable to apply the JsonPath expression to.

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 will be pretty printed (indented). Default is false.

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

${_varJsonPathAsArray('my_variable', '$[*].message', '', true)}
>
[
    "Hello",
    "World!"
]