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.

Returns a token representing the Resolvable Credential 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

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

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.

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 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 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

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 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 CSV data record count for the specified variable.

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

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

• If the variable is undefined, or the variable value is blank, the function will resolve to 0.

${_varCsvRecordCount('<variableName>')}

• variableName
  Required; Name of the variable.

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

Resolves to the CSV record value count for the specified variable and record index.

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

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

• If the variable is undefined, or the variable value is blank, the function will resolve to 0.

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

${_varCsvRecordValueCount('variableName', recordIndex)}

• variableName
  Required; Name of the variable.

• recordIndex
  Required; record index number.

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

Resolves to the CSV record value for the specified variable, record index, and variable index.

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

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

• If the variable is undefined, or the variable value is blank, the function will remain unresolved.
• If an index is invalid, the function will remain unresolved.

${_varCsvRecordValue('variableName', recordIndex, valueIndex)}

• variableName
  Required; Name of the variable.

• recordIndex
  Required; record index number.

• valueIndex
  Required; record index number.

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

Resolves to the TSV data record count for the specified variable.

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

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

• If the variable is undefined, or the variable value is blank, the function will resolve to 0.

${_varTsvRecordCount('<variableName>')}

• variableName
  Required; Name of the variable.

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

Resolves to the TSV record value count for the specified variable and record index.

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

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

• If the variable is undefined, or the variable value is blank, the function will resolve to 0.

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

${_varTsvRecordValueCount('variableName', recordIndex)}

• variableName
  Required; Name of the variable.

• recordIndex
  Required; record index number.

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

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

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

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

• If the variable is undefined, or the variable value is blank, the function will remain unresolved.
• If an index is invalid, the function will remain unresolved.

${_varTsvRecordValue('variableName', recordIndex, valueIndex)}

• variableName
  Required; Name of the variable.

• recordIndex
  Required; record index number.

• valueIndex
  Required; record index number.

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

Resolves the variable specified by the variable_name parameter and substitutes the default_value if the variable cannot be resolved.

${_resolve('variable_name'[, 'default_value'])}

• variable_name
  Required; Variable name.
• default_value
  Required; Default value to use if the variable cannot be resolved.

Resolves the variable specified by the variable_name parameter and substitutes the default value if the variable cannot be resolved.

${_resolveadv('variable_name', 'default_value', [use_default_if_blank])}

• variable_name
  Required; Variable name.
• default_value
  Required; Default value to use if the variable cannot be resolved.
• use_default_if_blank
  Optional; Specification (true or false) for whether or not to use the default value if the variable is empty or blank. (If use_default_if_blank is false, _resolveadv behaves like 20152753.) _resolve

Resolves to the JSON output data of the Web Service 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.

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

• 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.

Resolves to the JSON output data of the Web Service 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.

${_responseJsonPathFromTask('siblingName','pathExpression'[,'defaultValue','delimiter',prettyPrint])}

• siblingName
  Required; Name of a sibling task instance.
• 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.

Resolves to the JSON output data of the Web Service 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.

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

• 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.

Resolves to the JSON output data of the Web Service 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 doesn't yield a result, the function will resolve to the default value.

${_responseJsonPathAsArrayFromTask('siblingName','pathExpression'[,'defaultValue',prettyPrint])}

• siblingName
  Required; Name of a sibling task instance.
• 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.