Overview

Variables and functions can be used in free-text fields within tasks and workflows. When a variable or function is specified in a free-text field, the Controller inserts its value into the field when the task or workflow is run.

Also, triggers can pass variables and functions into the tasks and workflows they launch.

Universal Controller supports a number of functions that can be specified in free-text fields. They are resolved when a task instance runs or when a Set Variable action containing a function is executed.

Functions are entered using the following formats:

${_function}
${_function(arg1, ..., argN)}

Formatting Rules

Functions must be written either:
- In all lower-case characters.
- Exactly as shown in the tables on this page.
Functions have zero, one, or multiple parameters.
Each function parameter is one of three specific types:
- String
- Integer
- Boolean
String parameters must be enclosed in single or double quotation marks.
Integer and Boolean parameters can be enclosed in single or double quotation marks.
Optional parameters are identified on this page by being enclosed in [square brackets]. When copying a function from the documentation, be sure to remove the square brackets; otherwise, the function will not resolve.
If a function has more than one optional parameter, any optional parameters preceding a specified optional parameter must be included in the function's parameter list. For example:
- For function ${_responseJsonPath('pathExpression'[,'defaultValue','delimiter',prettyPrint])}, usage ${_responseJsonPath('.outputData','','',true)} would be valid, whereas ${_responseJsonPath('.outputData',,,true)} would not be valid.
- For function ${_formatDate(['date_time', 'format', day_offset, use_business_days, hour_offset, minute_offset, timezone])}, usage ${_formatDate('2018-09-01','',0,true)} would be valid, whereas ${_formatDate('2018-09-01','',,true)} would not be valid.
All functions allow nesting to two levels. That is, a function can be an argument to another function, which itself can be an argument to another function.
- You must use a double underscore preceding the name of a first-level nested function.
- You must use a triple underscore preceding the name of a second-level nested function.
For example, for 2nd day of next month less one Business Day:

${_formatDate('${__dayOfMonth(2,'${___dateadv('yyyy-MM-dd',0,1)}')}','',-1,true)}

Function Categories

Functions are listed alphabetically within the following categories on this page:

Conditional Functions
Credential Functions
Database Connection Functions
Date Functions
Mathematical Functions
Output Functions
Other Task Functions
SAP Connection Function
Script Functions
SQL/Stored Procedure Functions
String Functions
System Functions
Universal Task Functions
Web Service Functions

Conditional Functions

Return Conditional Value Depending on Equality of String Parameters

Description	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.)
Syntax	`${_ifEqual('value1', 'value2', 'if_value', 'else_value'[, ignore_case])`}
Parameters	`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.
Examples	${_ifEqual('abc','def','YES','NO')} ${_ifEqual('abc','ABC','YES','NO',true)} ${_ifEqual('2015-08-15','${__date()}','17:00','18:00')}

Return Conditional Value Depending on Value of Boolean Parameter

Description	Returns a conditional value depending on the value of a boolean parameter. Returns `if_value` if `value` is true; otherwise, `else_value` is returned.
Syntax	`${_ifTrue(value, 'if_value', 'else_value')`}
Parameters	`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.
Example	${_ifTrue(${__isToday('Mon', 'E')},'20:00','22:00')}

Credential Functions

Return Key Location of a Credential

Description	Returns a token representing the Credentials#Resolvable Credentials Key Location that you want to embed.
Syntax	`${_credentialKeyLoc('<credential_name>')`}
Parameters	`credential_name` Required; Name of the Credential.
Example	`${_credentialKeyLoc('RCredentialXYZ')} → $(ops_unv_cred_key_loc_c89e7b2caf4247909bc46041df8a2643)`

Return Passphrase of a Credential

Description	Returns a token representing the Credentials#Resolvable Credentials Passphrase that you want to embed.
Syntax	`${_credentialPassphrase('<credential_name>')`}
Parameters	`credential_name` Required; Name of the Credential.
Example	`${_credentialPassphrase('RCredentialXYZ')} → $(ops_unv_cred_passphrase_c89e7b2caf4247909bc46041df8a2643)`

Return Token of a Credential

Description	Returns a token representing the Credentials#Resolvable Credentials Token that you want to embed.
Syntax	`${_credentialToken('<credential_name>')`}
Parameters	`credential_name` Required; Name of the Credential.
Example	`${_credentialToken('RCredentialXYZ')} → $(ops_unv_cred_token_c89e7b2caf4247909bc46041df8a264`

Return User Name of a Credential

Description	Returns a token representing the Credentials#Resolvable Credentials Runtime User that you want to embed.
Syntax	`${_credentialUser('<credential_name>')`}
Parameters	`credential_name` Required; Name of the Credential.
Example	`${_credentialUser('RCredentialXYZ')} → $(ops_unv_cred_user_c89e7b2caf4247909bc46041df8a2643)`

Return User Password of a Credential

Description	Returns a token representing the Credentials#Resolvable Credentials Runtime Password that you want to embed.
Syntax	`${_credentialPwd('<credential_name>')`}
Parameters	`credential_name` Required; Name of the Credential.
Example	`${_credentialPwd('RCredentialXYZ')} → $(ops_unv_cred_pwd_c89e7b2caf4247909bc46041df8a2643)`

Database Connection Functions

Returns Property of a Database Connection

Description	Returns a token representing the property associated with a Database connection.
Syntax	`${_databaseConnection('<database_connection_name>', '<property_name>')`}
Parameters	`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`
Example	`${_databaseConnection('db1', 'type')}→ $(ops_unv_db_connection_type_3ac17d7f3ecb4df0b81aec9c7a24a38c)`

Date Functions

Checks if Date Argument Equals Today's Date

Description	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.
Syntax	`${_isToday('date'[, 'format', is_relative])`}
Parameters	`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.
Examples	${_isToday('Wed', 'E')} ${_isToday('${__dayOfMonth(1,'','',true)}')}

Resolve to Current Date and Time

Description	Resolves to the current date and time.
Syntax	`${_date(['format', day_offset, hour_offset, minute_offset])`}
Parameters	`format` Optional; Date format. Default format is yyyy-MM-dd HH:mm:ss Z. For details on the `format` parameter, see https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html `day_offset` Optional; +/- number of days to offset. `hour_offset` Optional; +/- number of hours to offset. `minute_offset` Optional; +/- number of minutes to offset.
Examples	${_date} --> 2012-07-14 12:43:06 -0400 ${_date()} --> 2012-07-14 12:43:06 -0400 ${_date('yyyy-MM-dd', 5)} --> 2012-07-19 ${_date('yyyy-MM-dd HH:mm:ss', -2, -1)} --> 2012-07-12 11:43:06 ${_date('', 0, 0, 10)} --> 2012-07-14 12:53:06 -0400

Resolve to Current Date and Time (Advanced)

Description	Resolves to the current date and time.
Syntax	`${_dateadv(['format', year_offset, month_offset, day_offset, hour_offset, minute_offset])`}
Parameters	`format` Date format. Default format is yyyy-MM-dd HH:mm:ss Z. For details on the `format` parameter, see https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html `year_offset` Optional; +/- number of years to offset. `month_offset` Optional; +/- number of months to offset. `day_offset` Optional; +/- number of days to offset. `hour_offset` Optional; +/- number of hours to offset. `minute_offset` Optional; +/- number of minutes to offset.
Examples	${_dateadv} --> 2012-07-29 09:31:42 -0700 ${_dateadv('yyyy-MMM', -1)} --> 2011-Jul ${_dateadv('yyyy-MMM', 0, -1)} --> 2012-Jun

Resolve to Current Unix Epoch Time

Description	Resolves to the current time in milliseconds since Wed Dec 31 1969 19:00:00 GMT-0500 (EST) – the start of Unix epoch time.
Syntax	`${_currentTimeMillis}`
Parameters	n/a

Return Date with Offsets

Description	Returns the date after applying offsets. Optionally, can specify the output format. Whether a holiday is treated as a business day or a non-business day is specified by the Properties#Exclude Holidays for Business Days Universal Controller system property.
Syntax	`${_formatDate(['date_time', 'format', day_offset, use_business_days, hour_offset, minute_offset, timezone])`}
Parameters	`date_time` Date and time in any of the following formats: yyyy-MM-dd yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm Z yyyy-MM-dd HH:mm:ss Z. yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss.SSS Z. Default is the current date and time. `format` Format of returned date. If date_time specifies a time, the default format is yyyy-MM-dd HH:mm; otherwise, the default format is yyyy-MM-dd. For details on the `format` parameter, see https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html `day_offset` +/- number of days to offset. `use_business_days` Specification (`true` or `false`) for whether `day_offset` is for business days. Default is false. `hour_offset` +/- number of hours to offset. `minute_offset` +/- number of minutes to offset. `timezone` Time Zone that the date is formatted in.
Example	${_formatDate} --> 2018-08-24 15:37 ${_formatDate()} --> 2018-08-24 15:37 ${_formatDate('','MMddyyyy',5)} --> 08292018 ${_formatDate('2018-09-01','',5)} --> 2018-09-06 ${_formatDate('2018-09-01','',-5)} --> 2018-08-27 ${_formatDate('2018-10-13 12:13:14 -0400','',5,true,0,0,'Australia/Sydney')} --> 2018-10-14 03:13:14 +1100

Return Date with Offsets (Advanced)

Description	Returns the date after applying offsets. Optionally, can specify the output format. Whether a holiday is treated as a business day or a non-business day is specified by the Properties#Exclude Holidays for Business Days Universal Controller system property.
Syntax	`${_formatDateAdv(['date_time', 'format', year_offset, month_offset, day_offset, use_business_days, hour_offset, minute_offset, timezone])`}
Parameters	`date_time` Date and time in any of the following formats: yyyy-MM-dd yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm Z yyyy-MM-dd HH:mm:ss Z. yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss.SSS Z. Default is the current date and time. `format` Format of returned date. If date_time specifies a time, the default format is yyyy-MM-dd HH:mm; otherwise, the default format is yyyy-MM-dd. For details on the `format` parameter, see https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html `year_offset` Optional; +/- number of years to offset. `month_offset` Optional; +/- number of months to offset. `day_offset` Optional; +/- number of days to offset. `use_business_days` Optional; Specification (true or false) for whether `day_offset` is for business days. Default is false. `hour_offset` +/- number of hours to offset. `minute_offset` +/- number of minutes to offset. `timezone` Time Zone that the date is formatted in.
Examples	${_formatDateAdv} --> 2012-08-24 15:55 ${_formatDateAdv()} --> 2012-08-24 15:55 ${_formatDateAdv('','MMddyyyy',1)} --> 08242013 ${_formatDateAdv('2012-09-01','',0,1)} --> 2012-10-01 ${_formatDateAdv('2012-09-01','',0,-1)} --> 2012-08-01 ${_formatDateAdv('2012-09-01','',0,0,5,false)} --> 2012-09-06

Return Date with Time Zone

Description	Returns the Date and Time in another time zone.
Syntax	`${_formatDateTz('date_time', 'target_time_zone'[, 'output_format'])`}
Parameters	`date_time` Date and time in any of the following formats: yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm Z yyyy-MM-dd HH:mm:ss Z. yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss.SSS Z. `target_time_zone` Time zone in which to format the date and time. `output_format` Optional; Format of the date and time in the other time zone.
Examples	${_formatDateTz('2018-10-13 01:02:03 -0400', 'Australia/Sydney')} --> 2018-10-13 16:02:03 +1100 ${_formatDateTz('2018-10-13 01:02:03 -0400', 'Australia/Sydney','yyyy-MM-dd HH:mm Z')} --> 2018-10-13 16:02 +1100 ${_formatDateTz('${ops_launch_time}', '${ops_time_zone}')} = ${_formatDateTz('2018-06-13 15:35:00 -0400', 'Europe/Berlin')} = 2018-06-13 21:35:00 +0200

Return Day of Week

Description	Returns the day of week for the specified date as a number.
Syntax	`${_dayOfWeek(['date', 'first_dow', first_dow_value])`}
Parameters	`date` Date in any of the following formats: yyyy-MM-dd yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm Z yyyy-MM-dd HH:mm:ss Z. yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss.SSS Z. Default is the current date. `first_dow` Optional; Specification for whether the week starts on Sunday or Monday. Values are sun and mon (not case-sensitive). Default is sun. `first_dow_value` Optional; Starting value for the first day of week. Value must be a non-negative number. Default is 1.
Example	${_dayOfWeek} --> 6 ${_dayOfWeek()} --> 6 ${_dayOfWeek('2012-07-04')} --> 4 ${_dayOfWeek('2012-07-04', 'mon')} --> 3

Return Days between Dates

Description	Returns the number of days between date1 and date2. If return value is > 0, date2 is after date1. If return value is < 0, date2 is before date1. If return value is 0, date1 is equal to date2. The start date is inclusive, but the end date is not.
Syntax	`${_daysBetween('date1', 'date2')`}
Parameters	`date1` Required. `date2` Required. date1 and date2 are specified in any of the following formats: yyyy-MM-dd yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm Z yyyy-MM-dd HH:mm:ss Z. yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss.SSS Z.
Example	${_daysBetween('2012-08-01','2012-09-01')} --> 31

Return Non-Business Day of Month

Description	Returns the Nth non-business day of month for the month of the date specified. Optionally, can start from the end of the month. Whether a holiday is treated as a business day or a non-business day is specified by the Properties#Exclude Holidays for Business Days Universal Controller system property.
Syntax	`${_nonBusinessDayOfMonth(index, ['date', 'format', reverse])`}
Parameters	`index` Required; Nth non-business day of month. `date` Date (and time) is specified in any of the following formats: yyyy-MM-dd yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm Z yyyy-MM-dd HH:mm:ss Z. yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss.SSS Z. Default is the current date. `format` Optional; Format of returned date. Default is yyyy-MM-dd. For details on the `format` parameter, see https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html `reverse` Optional; Specification (true or false) for starting from the end of the month. Default is false.
Examples	${_nonBusinessDayOfMonth(1)} --> 2012-08-04 ${_nonBusinessDayOfMonth(1,'2012-09-01')} --> 2012-09-01 ${_nonBusinessDayOfMonth(1,'2012-09-01','',true)} --> 2012-09-30

Return Nth Business Day of Month

Description	Returns the Nth business day of month for the month of the date specified. Optionally, can start from the end of the month. Whether a holiday is treated as a business day or a non-business day is specified by the Properties#Exclude Holidays for Business Days Universal Controller system property.
Syntax	`${_businessDayOfMonth(index, ['date', 'format', reverse])`}
Parameters	`index` Required; Nth business day of month. `date` Date (and time) is specified in any of the following formats: yyyy-MM-dd yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm Z yyyy-MM-dd HH:mm:ss Z. yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss.SSS Z. Default is the current date. `format` Optional; Format of returned date. Default is yyyy-MM-dd. For details on the `format parameter`, see https://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html `reverse` Optional; Specification (`true` or `false`) for starting from the end of the month. Default is false.
Examples	${_businessDayOfMonth(1)} --> 2012-08-01 ${_businessDayOfMonth(1,'2012-09-01')} --> 2012-09-04 ${_businessDayOfMonth(1,'2012-09-01','',true)} --> 2012-09-28

Return Nth Day of Month

Description	Returns the Nth day of month for the month of the date specified. Optionally, can start from the end of the month.
Syntax	`${_dayOfMonth(index, ['date', 'format', reverse])`}
Parameters	`index` Required; Nth day of month. `date` Date (and time) is specified in any of the following formats: yyyy-MM-dd yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm Z yyyy-MM-dd HH:mm:ss Z. yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss.SSS Z. Default is the current date. `format` Optional; Format of returned date. Default is yyyy-MM-dd. `reverse` Optional; Specification (true or false) for starting from the end of the month. Default is false.
Examples	${_dayOfMonth(5)} --> 2012-08-05 ${_dayOfMonth(15,'2012-09-01','MM/dd/yyyy')} --> 09/15/2012 ${_dayOfMonth(1,'2012-09-01','',true)} --> 2012-09-30

Return Number of Business Days between Dates

Description	Returns the number of business days between date1 and date2. If return value is > 0, `date2` is after `date1`. If return value is < 0, `date2` is before `date1`. If return value is 0, `date1` is equal to `date2`. The start date is inclusive, but the end date is not. Whether a holiday is treated as a business day or a non-business day is specified by the Properties#Exclude Holidays for Business Days Universal Controller system property.
Syntax	`${_businessDaysBetween('date1', 'date2')`}
Parameters	`date1` Required. `date2` Required. date1 and date2 are specified in any of the following formats: yyyy-MM-dd yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm Z yyyy-MM-dd HH:mm:ss Z. yyyy-MM-dd HH:mm:ss.SSS yyyy-MM-dd HH:mm:ss.SSS Z.
Example	${_businessDaysBetween('2012-08-01','2012-09-01')} --> 23

Mathematical Functions

Add

Description	Return the sum of the augend added with the addend.
Syntax	`${_add(augend, addend)`}
Parameters	`augend` Integer to which the `addend` is being added. `addend` Integer being added to the `augend`.
Example	${_add('77', '33')} --> 110 Using Variables for augend and addend (${augend} = 17, ${addend} = 5): ${_add('${augend}','${addend}')} --> 22

Divide

Description	Return the quotient of the dividend divided by divisor.
Syntax	`${_divide(dividend, divisor)`}
Parameters	`dividend` Integer being divided by the `divisor`. `divisor` Integer being used to divide the `dividend`.
Example	${_divide('7','20')} --> 0 ${_divide('20','7')} --> 2 ${_divide('20','5')} --> 4 Using Variables for dividend and divisor (${dividend} = 100, ${divisor} = 5) ${_divide('${dividend}','${divisor}')} --> 20

Multiply

Description	Return the product of the multiplicand multiplied with the multiplier.
Syntax	`${_multiply(multiplicand, multiplier)`}
Parameters	`multiplicand` Integer being multiplied by the `multiplier`. `multiplier` Integer being used to multiply the `multiplicand`.
Example	${_multiply('7','20')} --> 140 Using Variables for multiplicand and multiplier (${multiplicand} = 100, ${multiplier} = 5): ${_multiply('${multiplicand}','${multiplier}')} --> 500

Return Absolute Value

Description	Return the absolute value of the parameter.
Syntax	`{_abs(parameter)`}
Parameters	`parameter` Integer (positive or negative value).
Example	${_abs('-1200')} --> 1200 ${_abs('1200')} --> 1200 Using Variables for parameter (${parameter} = -100): ${_abs('${parameter}')} --> 100

Return Modulo

Description	Return the modulo (remainder) of the dividend divided by divisor.
Syntax	`${_mod(dividend, divisor)`}
Parameters	`dividend` Integer being divided by the `divisor`. `divisor` Integer being used to divide the `dividend`.
Example	${_mod('10', '2')} --> 0 ${_mod('10', '3')} --> 1 ${_mod('70', '65')} --> 5 Using Variables for dividend and divisor (${dividend} = 23, ${divisor} = 5): ${_mod('${dividend}','${divisor}')} --> 3

Subtract

Description	Return the difference of the subtrahend subtracted from the minuend.
Syntax	`${_subtract(minuend, subtrahend)`}
Parameters	`minuend` Integer from which the `subtrahend` is being subtracted. `subtrahend` Integer being subtracted from the `minuend`.
Example	${_subtract('77','33')} --> 44 ${_subtract('33','77')} --> -44 Using Variables for minuend and subtrahend (${minuend} = 100, ${subtrahend} = 5): ${_subtract('${minuend}','${ subtrahend }')} --> 95

Other Task Functions

Business Services Membership

Description	Resolves to a delimited list of business service names the task instance is a member of.
Syntax	`${_businessServices(['resultDelimiter'])`}
Parameters	`resultDelimiter` Optional; Delimiter to use when concatenating business service names. If not specified, ", " will be used.
Example	If a task instance is a member of business services A, B, and C. `${_businessServices()}` `A, B, C` `${_businessServices('\n')} A B C` If a task instance is not a member of any business service, the function will evaluate to empty.

Output Functions

(For Web Service output, see Web Service Functions.)

Note

A prerequisite for the use of these functions is that Automatic Output Retrieval and Wait For Output are selected at task level, with the exception of the EXTENSION output type.

Output CSV Record Count

Description	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.
Syntax	${_outputCsvRecordCount('<outputType>')}
Parameters	`outputType` Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
Example	`data="A","B","C","D"\n "E","F","G","H" ${_outputCsvRecordCount('STDERR')} > 2`

Output CSV Record Value Count

Description	Resolves to the count of CSV 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
Syntax	${_outputCsvRecordValueCount('outputType', recordIndex)}
Parameters	`outputType` Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG. `recordIndex` Required; record index number.
Example	`data="A","B","C","D"\n "E","F","G","H" ${_outputCsvRecordValueCount('STDERR','1')} > 4`

Output CSV Record Value

Description	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.
Syntax	${_outputCsvRecordValue('outputType', recordIndex, valueIndex)}
Parameters	`outputType` Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG. `recordIndex` Required; record index number. `valueIndex` Required; record index number.
Example	`data="A","B","C","D"\n "E","F","G","H" ${_varCsvRecordValue('STDOUT','1', '2')} > G`

Output TSV Record Count

Description	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.
Syntax	${_outputTsvRecordCount('<outputType>')}
Parameters	`outputType` Required; Name of the variable.
Example	`data="A" "B" "C" "D"\n "E" "F" "G" "H" ${_outputTsvRecordCount('STDERR')} > 2`

Output TSV Record Value Count

Description	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.
Syntax	${_outputTsvRecordValueCount('outputType', recordIndex)}
Parameters	`outputType` Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG. `recordIndex` Required; record index number.
Example	`data="A" "B" "C" "D"\n "E" "F" "G" "H" ${_outputTsvRecordValueCount('STDERR','1')} > 4`

Output TSV Record Value

Description	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.
Syntax	${_outputTsvRecordValue('outputType', recordIndex, valueIndex)}
Parameters	`outputType` Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG. `recordIndex` Required; record index number. `valueIndex` Required; record index number.
Example	`data="A" "B" "C" "D"\n "E" "F" "G" "H" ${_outputTsvValue('my_variable','1', '2')} > G`

Output CSV Record Count From Task

Description	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.
Syntax	${_outputCsvRecordCountFromTask('siblingName', 'outputType')}
Parameters	`siblingName` Required; Name of a sibling task instance. `outputType` Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
Example	`data="A","B","C","D"\n "E","F","G","H" ${_outputCsvRecordCountFromTask('task-1','STDERR')} > 2`

Output CSV Record Value Count From Task

Description	Resolves to the value count of CSV 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.
Syntax	${_outputCsvRecordValueCountFromTask('siblingName', 'outputType', 'recordIndex')}
Parameters	`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.
Example	`data="A","B","C","D"\n "E","F","G","H" ${_outputCsvRecordValueCountFromTask('task-1','STDERR','1')} > 4`

Output CSV Record Value From Task

Description	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.
Syntax	${_outputCsvRecordValueFromTask('siblingName','outputType', recordIndex, valueIndex)}
Parameters	`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.
Example	`data="A","B","C","D"\n "E","F","G","H" ${_outputCsvRecordValueFromTask('task-1','STDOUT','1', '2')} > G`

Output TSV Record Count From Task

Description	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.
Syntax	${_outputTsvRecordCountFromTask('siblingName','outputType')}
Parameters	`siblingName` Required; Name of a sibling task instance. `outputType` Required; Name of the variable.
Example	`data="A" "B" "C" "D"\n "E" "F" "G" "H" ${_outputTsvRecordCountFromTask('task-1','STDERR')} > 2`

Output TSV Record Value Count From Task

Description	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.
Syntax	${_outputTsvRecordValueCountFromTask('siblingName','outputType', 'recordIndex')}
Parameters	`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.
Example	`data="A" "B" "C" "D"\n "E" "F" "G" "H" ${_outputTsvRecordValueCountFromTask('task-1','STDERR','1')} > 4`

Output TSV Record Value From Task

Description	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.
Syntax	${_outputTsvRecordValueFromTask('siblingName','outputType', recordIndex, valueIndex)}
Parameters	`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.
Example	`data="A" "B" "C" "D"\n "E" "F" "G" "H" ${_outputTsvRecordValueFromTask('task-1','STDOUT','1', '2')} > G`

Output Delimited Value Count

Description	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.
Syntax	${_outputDelimitedValueCount('outputType', [delimiter])}
Parameters	`outputType` Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG. `delimiter` Optional;delimiter to split the output. default delimiter is comma(,).
Example	`data= A,B,C,D ${_outputDelimitedValueCount('STDOUT')} > 4`

Output Delimited Value

Description	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.
Syntax	${_outputDelimitedValue('outputType', valueIndex,[delimiter])}
Parameters	`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(,).
Example	`data=A,B,C,D ${_outputDelimitedValue('STDOUT','2')} > C`

Output Delimited Value Count From Task

Description	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.
Syntax	${_outputDelimitedValueCountFromTask('siblingName','outputType', [delimiter])}
Parameters	`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(,).
Example	`data=A,B,C,D ${_outputDelimitedValueCountFromTask('task-1','STDOUT')} > 4`

Output Delimited Value From Task

Description	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.
Syntax	${_outputDelimitedValueFromTask('siblingName','outputType', valueIndex,[delimiter])}
Parameters	`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(,).
Example	`data=A:B:C:D ${_outputDelimitedValueFromTask('task-1','STDOUT','2')} > C`

Task Instance Output

Description	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.
Syntax	`${_output('outputType'[, 'defaultValue'])`}
Parameters	`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 ('').

Description

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.

Syntax

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

Parameters

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 ('').

Sibling Task Instance Output

Description	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.
Syntax	`${_outputFromTask('siblingName', 'outputType'[, 'defaultValue'])`}
Parameters	`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 ('').

Description

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.

Syntax

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

Parameters

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 ('').

Task Instance Output Number of Lines

Description	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.
Syntax	`${_outputNumberOfLines('outputType')}`
Parameters	`outputType` Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
Example	`${_outputNumberOfLines('STDOUT')}` `> 6`

Sibling Task Instance Output Number of Lines

Description	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.
Syntax	`${_outputNumberOfLinesFromTask('siblingName', 'outputType')}`
Parameters	`siblingName` Required; Name of a sibling task instance. `outputType` Required; Type of output to resolve: STDOUT, STDERR, FILE, EXTENSION, or JOBLOG.
Example	${`_outputNumberOfLinesFromTask`('test', '`STDOUT`')} `> 8`

Task Instance Output by Specific Line(s)

Description	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.
Syntax	`${_outputLines('outputType', startLine, numberOfLines[, 'defaultValue', 'resultDelimiter'])`}
Parameters	`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.

Description

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.

Syntax

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

Parameters

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.

Sibling Task Instance Output by Specific Line(s)

Description	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.
Syntax	`${_outputLinesFromTask('siblingName', 'outputType', startLine, numberOfLines[, 'defaultValue', 'resultDelimiter'])`}
Parameters	`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.

Description

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.

Syntax

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

Parameters

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.

Task Instance Output by Line(s) Matching Regular Expression

Description	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.
Syntax	`${_outputLinesByRegex('outputType', 'regexPattern'[, maxCount, numberOfLinesBefore, numberOfLinesAfter, 'defaultValue', 'resultDelimiter'])`}
Parameters	`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.
Example	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

Sibling Task Instance Output by Line(s) Matching Regular Expression

Description

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.

Syntax

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

Parameters

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.

Task Instance Output By XPath

Description	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.
Syntax	`${_outputXPath('outputType', 'xPathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}`
Parameters	`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.
Example	`XML` `<message>` `<code>10</code> </message> Function` `${_outputXPath('STDOUT', '//code/text()')} Result` `10`

Sibling Task Instance Output By XPath

Description	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.
Syntax	`${_outputXPathFromTask('siblingName', 'outputType', 'xPathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}`
Parameters	`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.
Example	`XML` `<message> <code>10</code> </message> Function` `${_outputXPathFromTask('Sibling_With_XML_Output', 'STDOUT', '//code/text()')} Result` `10`

Task Instance Output By JsonPath

Description	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. When using a JsonPath function, the output must be ONLY a JSON formatted string. If the output contains leading or trailing text, the function will fail to work properly.
Syntax	`${_outputJsonPath('outputType', 'pathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}`
Parameters	`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 p`athExpression` 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.
Example	`JSON` `{` `"code": 10` `}` `Function` `${_outputJsonPath('STDOUT', '$.code')}` `Result` `10`

Sibling Task Instance Output By JsonPath

Description	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. When using a JsonPath function, the output must be ONLY a JSON formatted string. If the output contains leading or trailing text, the function will fail to work properly.
Syntax	`${_outputJsonPathFromTask('siblingName', 'outputType', 'pathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}`
Parameters	`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 p`athExpression` 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.
Example	`JSON` `{` `"code": 10` `}` `Function` `${_outputJsonPathFromTask('Sibling_With_JSON_Output', 'STDOUT', '$.code')}` `Result` `10`

Task Instance Output By JsonPath As Array

Description	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. When using a JsonPath function, the output must be ONLY a JSON formatted string. If the output contains leading or trailing text, the function will fail to work properly.
Syntax	`${_outputJsonPathAsArray('outputType', 'pathExpression'[, 'defaultValue', prettyPrint])}`
Parameters	`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.
Example	`JSON` `[` `{ "message" : "Hello", "code" : 10 }, { "message" : "World!", "code" : 20 } ]` `Function` `${_outputJsonPathAsArray('STDOUT', '$[*].message', '', true)}` `Result` `[ "Hello", "World!" ]`

Sibling Task Instance Output By JsonPath As Array

Description	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. When using a JsonPath function, the output must be ONLY a JSON formatted string. If the output contains leading or trailing text, the function will fail to work properly.
Syntax	`${_outputJsonPathFromTask('siblingName', 'outputType', 'pathExpression'[, 'defaultValue', prettyPrint])}`
Parameters	`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.
Example	JSON `[ { "message" : "Hello", "code" : 10 }, { "message" : "World!", "code" : 20 } ]` Function `${_outputJsonPathAsArrayFromTask('Sibling_With_JSON_Output',` `'STDOUT', '$[*].message')}` `Result["Hello","World!"]`

Task Instance Output Path

Description	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.
Syntax	`${_outputPath('outputType'[, 'fileExtension'])}`
Parameters	`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.
Example	application.exe -file ${_outputPath('STDOUT')} > application.exe -file $(ops_output_path_1638302212442528629FTPBE4AJQV2FT_stdout_txt) application.exe -file ${_outputPath('SQL')} > application.exe -file $(ops_output_path_1639503212294078671DNPMULGSEVMHT_sql_csv) application.exe -file ${_outputPath('SQL', 'tsv')} > application.exe -file $(ops_output_path_1639503212294078671DNPMULGSEVMHT_sql_tsv) application.exe -file ${_outputPath('EXTENSION', 'json')} > application.exe -file $(ops_output_path_1639503212294187671OAI9SM79CNC2V_extension_json)

Sibling Task Instance Output Path

Description	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.
Syntax	`${_outputPathFromTask('siblingName', 'outputType'[, 'fileExtension'])}`
Parameters	`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.
Example	application.exe -file ${_outputPathFromTask('Sibling_Instance_Name', 'STDERR')} > application.exe -file $(ops_output_path_1639503212294128671YL1B04U3OT55P_stderr_txt) application.exe -file ${_outputPathFromTask('Sibling_Instance_Name', 'STOREDPROC')} > application.exe -file $(ops_output_path_1639503212294197671Q13UV8MSH6355_storedproc_csv) application.exe -file ${_outputPathFromTask('Sibling_Instance_Name', 'STOREDPROC', 'tsv')} > application.exe -file $(ops_output_path_1639503212294197671Q13UV8MSH6355_storedproc_tsv) application.exe -file ${_outputPathFromTask('Sibling_Instance_Name', 'WEBSERVICE', 'json')} > application.exe -file $(ops_output_path_1639503212294088671CAWMP3VNQ468B_webservice_json)

SAP Connection Functions

Returns Property of an SAP Connection

Description	Returns a token representing the property associated with an SAP connection
Syntax	`${_sapConnection('<sap_connection_name>', '<property_name>')}`
Parameters	`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`
Example	`${_sapConnection('sap1', 'sap_connection_type')}→ $(ops_unv_sap_connection_sap_connection_type_3ac17d7f3ecb4df0b81aec9c7a24a38c)`

Script Functions

Returns Path to Data Script

Description	Returns a token representing the path to a Scripts#Data Scripts that you want to Scripts#Embedding a Data Script.
Syntax	`${_scriptPath('script_name')}`
Parameters	`script_name` Required; Name of the Data Script.
Example	Script Name: MyDataScript Script UUID: 507ffdbd0eba4b62b0e31e0fd22f6bec `${_scriptPath('MyDataScript')} --> $(ops_unv_script_path_507ffdbd0eba4b62b0e31e0fd22f6bec)` Note The Agent will replace the resolved token with a path to a temporary file containing the content of the Data Script. For additional details, refer to Scripts#Embedding a Data Script.

Note

_scriptPath requires Agent 6.4.0.0 or later.

SQL/Stored Procedure Functions

Return Column Names for SQL Results from Current Task

Description	Returns the column names for the SQL results from the current SQL or Stored Procedure task. Column names are separated by the specified `separator`.
Syntax	`${_resultsColumnNames(['separator'])`}
Parameters	`separator` Optional; Column name separator. Default is comma (,).

Return Column Names for SQL Results from Sibling Task

Description	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`.
Syntax	`${_resultsColumnNamesFromTask('name'[, 'separator'])`}
Parameters	`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 (,).

Return SQL Results from Current Task

Description	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.
Syntax	`${_resultsAll(['separator', 'rowSeparator'])`}
Parameters	`separator` Optional; Column separator. Default is comma (,). `rowSeparator` Optional; Overrides default New Line character.

Return SQL Results from Sibling Task

Description	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.
Syntax	`${_resultsAllFromTask('name'[, 'separator', 'rowSeparator'])`}
Parameters	`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.

Return SQL Warnings from Current Task

Description	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.
Syntax	`${_SQLWarnings(['separator'])`}
Parameters	`separator` Optional; Column separator. Default is comma (,).

Return SQL Warnings from Sibling Task

Description	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.
Syntax	`${_SQLWarningsFromTask('name'[, 'separator'])`}
Parameters	`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 (,).

Return String Value of Row/Column by Column Name

Description	Returns the string value of a row/column from a previously executed SQL task within the same workflow, or from the current SQL task.
Syntax	`${_resultsColumn('name', 'colname'[, rownum, 'default_value'])`}
Parameters	`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.

Return String Value of Row/Column by Column Number

Description	Returns the string value of a row/column from a previously executed SQL task within the same workflow, or from the current SQL task.
Syntax	`${_resultsColumnByNo('name', colnum[, rownum, 'default_value'])`}
Parameters	`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.

Return String Values of Columns

Description	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.
Syntax	`${_resultsColumnsCSV('name'[, rownum])`}
Parameters	`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.

String Functions

String Functions can accept:

String content in a String parameter.
Variable name in a String parameter (prefixed with _var) from which string content can be obtained.
Integer and Boolean parameters.

For String functions that accept a String value parameter directly, the value parameter can be specified using hard-coded text, variables, functions, or any combination of the three.

Note

When using String functions that accept a String value parameter directly, you should be aware of expectations with respect to escape characters and escape sequences (see Escape Sequences, below).

For String functions that accept a variable name parameter, the fully resolved value of the variable by the specified name will be used as the String value argument. The variable must be fully resolvable and must not contain an unresolved function.

Note

Indexing functions use zero-based numbering; that is, the initial element is assigned the index 0.

Escape Sequences

An escape character preceded by a backslash (\) is an escape sequence (see the following table for a list of escape sequences).

If you are using a String function to manipulate a String value that potentially may contain an escape sequence, you should use the String function that accepts a variable name parameter to allow for passing the value to the function without the escape sequence being interpreted.

Escape Sequences	Escape Sequence Description
\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.

Convert Characters in Value to Lower Case

Description	Converts all of the characters in the `value` to lower case using the rules of the default locale.
Syntax	`${_toLowerCase('value')`}
Parameters	`value` Required; String to convert to lower case.

Convert Characters in Variable to Lower Case

Description	Converts all of the characters in the variable to lower case using the rules of the default locale.
Syntax	`${_varToLowerCase('variableName')`}
Parameters	`variableName` Required; Name of the variable being passed into the function.

Convert Characters in Value to Upper Case

Description	Converts all of the characters in the `value` to upper case using the rules of the default locale.
Syntax	`${_toUpperCase('value')`}
Parameters	`value` Required; String to convert to upper case.

Convert Characters in Variable to Upper Case

Description	Converts all of the characters in the variable to upper case using the rules of the default locale.
Syntax	`${_varToUpperCase('variableName')`}
Parameters	`variableName` Required; Name of the variable being passed into the function.

Escape Characters in Variable Using XML Entities

Description	Escapes the characters in a variable value using XML entities.
Syntax	`${_varEscapeXml('variableName')`}
Parameters	`variableName` Required; Name of the variable being passed into the function. The variable value will be escaped for insertion into XML.
Example	Variable Name: escape_me Variable Value: `1234567890\E-=[]\;',./ ~!@#$%^&()_+{}\|:"<>? ${_varEscapeXml('escape_me')} --> `1234567890\E-=[]\;',./ ~!@#$%^&()_+{}\|:"<>?

Escape Characters in Variable Using JSON String Rules

Description	Escapes the characters in a variable value using JSON string values.
Syntax	`${_varEscapeJson('variableName')`}
Parameters	`variableName` Required; Name of the variable being passed into the function. The variable value will be escaped for insertion into JSON.
Example	Variable Name: escape_me Variable Value: `1234567890\E-=[]\;',./ ~!@#$%^&()_+{}\|:"<>? ${_varEscapeJson('escape_me')} --> `1234567890\\E-=[]\\;',.\/ ~!@#$%^&()_+{}\|:\"<>?

Escape Characters in Variable Using JavaScript String Rules

Description	Escapes the characters in a variable value using JavaScript String rules.
Syntax	`${_varEscapeJavaScript('variableName')`}
Parameters	`variableName` Required; Name of the variable being passed into the function. The variable value will be escaped for insertion into JavaScript.
Example	Variable Name: escape_me Variable Value: `1234567890\E-=[]\;',./ ~!@#$%^&()_+{}\|:"<>? ${_varEscapeJavaScript('escape_me')} --> `1234567890\\E-=[]\\;\',.\/ ~!@#$%^&()_+{}\|:\"<>?

Escape Characters in Variable Using HTML Entities

Description	Escapes the characters in a variable value using HTML entities. (Supports all known HTML 4.0 entities.)
Syntax	`${_varEscapeHtml('variableName')`}
Parameters	`variableName` Required; Name of the variable being passed into the function. The variable value will be escaped for insertion into HTML.
Example	Variable Name: escape_me Variable Value: `1234567890\E-=[]\;',./ ~!@#$%^&()_+{}\|:"<>? ${_varEscapeHtml('escape_me')} --> `1234567890\E-=[]\;',./ ~!@#$%^&()_+{}\|:"<>?

Escape Characters in Variable as a Literal Pattern

Description	Returns a literal regular expression pattern String for the value of the specified variable. This method produces a String that can be used to create a Pattern that would match the String as if it were a literal pattern.
Syntax	`${_varLiteralPattern('variableName')`}
Parameters	`variableName` Required; Name of the variable being passed into the function. The variable value will be escaped for insertion into a regular expression as a literal pattern.
Example	Variable Name: escape_me Variable Value: `1234567890\E-=[]\;',./ ~!@#$%^&()_+{}\|:"<>? ${_varLiteralPattern('escape_me')} --> \Q`1234567890\E\\E\Q-=[]\;',./ ~!@#$%^&()_+{}\|:"<>?\E

Randomly Generate a String

Description	Randomly generates a String with a specified length.
Syntax	`${_randomString(length[, 'excludeCharacters', 'defaultCharacters'])`}
Parameters	`length` Required; String length. `excludeCharacters` Optional; String containing characters to exclude from the default character set. `defaultCharacters` Optional; String for overriding default character set. Note The following characters are included in the default character set, in addition to the space character. ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz1234567890`-=~!@#$%^&*()_+[]\{}\|;':",./<>?
Example	${_randomString(24, '', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890@#$%')} --> 5L8T1RN#$AQWEKPA@BQ19JD

Replace Substring of Value with Regular Expression

Description	Replaces each substring of value that matches the specified Wildcards and Regular Expressions, regex, with the specified replacement.
Syntax	`${_replaceAll('value', 'regex', 'replacement')`}
Parameters	`value` Required; Input string. `regex` Required; Regular expression. `replacement` Required; Replacement string.

Replace Substring of Variable with Regular Expression

Description	Replaces each substring of `variableName` that matches the specified Wildcards and Regular Expressions, regex, with the specified replacement.
Syntax	`${_varReplaceAll('variableName', 'regex', 'replacement')`}
Parameters	`variableName` Required; Name of the variable being passed into the function. `regex` Required; Regular expression. `replacement` Required; Replacement string.

Return Base64 Encoded String

Description	Returns the value of the specified variable encoded using the Base64 encoding scheme.
Syntax	`${_varEncodeBase64('variableName'[, 'charset'])}`
Parameters	`variableName` Required; Name of the variable whose value will be encoded using the Base64 encoding scheme. `charset` Optional; Name of the charset; default UTF-8.
Example	Where Variable rawstring contains a value of "Test String": `${_varEncodeBase64('rawstring')} --> VGVzdCBTdHJpbmc=`

Return Copy of Value with Whitespace Omitted

Description	Returns a copy of `value`, with leading and trailing whitespace omitted.
Syntax	`${_trim('value')`}
Parameters	`value` Required; String to trim.

Return Copy of Variable with Whitespace Omitted

Description	Returns a copy of `variableName`, with leading and trailing whitespace omitted.
Syntax	`${_varTrim('variableName')`}
Parameters	`variableName` Required; Name of the variable being passed into the function.

Return Index of Substring in String Value

Description	Returns the index within the string value of the first occurrence of the specified substring, `str`.
Syntax	`${_indexOf('value', 'str')`}
Parameters	`value` Any string. `str` Substring to search for. If the `str` argument occurs as a substring within the value, then the index of the first character of the first such substring is returned; if it does not occur as a substring, -1 is returned.

Return Index of Substring in String Variable

Description	Returns the index within the string variable of the first occurrence of the specified substring, `str`.
Syntax	`${_varIndexOf('variableName', 'str')`}
Parameters	`variableName` Required; Name of the variable being passed into the function. `str` Required; Substring to search for. If the `str` argument occurs as a substring within the variable, the index of the first character of the first such substring is returned; if it does not occur as a substring, -1 is returned.

Return Index of Substring Plus Offset in String Value

Description	Returns the index within this string of the first occurrence of the specified substring plus the specified offset. The integer returned is the smallest value.
Syntax	`${_indexOfWithOffset('value', 'str', offset)`}
Parameters	`value` Required; Any string. `str` Required; Substring to search for. If the `str` argument occurs as a substring within the value, then the index of the first character of the first such substring is returned; if it does not occur as a substring, -1 is returned. `offset` Required; Number (positive or negative) to offset the found index.

Return Index of Substring Plus Offset in String Variable

Description	Returns the index within this string of the first occurrence of the specified substring plus the specified offset. The integer returned is the smallest variable.
Syntax	`${_varIndexOfWithOffset('variableName', 'str', offset)`}
Parameters	`variableName` Required; Name of the variable being passed into the function. `str` Required; Substring to search for. If the `str` argument occurs as a substring within the variable, then the index of the first character of the first such substring is returned; if it does not occur as a substring, -1 is returned. `offset` Required; Number (positive or negative) to offset the found index.

Return Index of Rightmost Occurrence of Substring in String Value

Description	Returns the index within the string value of the rightmost occurrence of the specified substring, `str`.
Syntax	`${_lastIndexOf('value', 'str')`}
Parameters	`value` Required; Any string. `str` Required; Substring to search for. If the `str` argument occurs one or more times as a substring within the value, then the index of the first character of the last such substring is returned. If it does not occur as a substring, -1 is returned.

Return Index of Rightmost Occurrence of Substring in String Variable

Description	Returns the index within the string variable of the rightmost occurrence of the specified substring, `str`.
Syntax	`${_varLastIndexOf('variableName', 'str')`}
Parameters	`variableName` Required; Name of the variable being passed into the function. `str` Required; Substring to search for. If the `str` argument occurs one or more times as a substring within the variable, then the index of the first character of the last such substring is returned. If it does not occur as a substring, -1 is returned.

Return Index of Rightmost Occurrence of Substring Plus Offset in String Value

Description	Returns the index within this string of the rightmost occurrence of the specified substring, plus the specified offset. The returned index is the largest value.
Syntax	`${_lastIndexOfWithOffset('value', 'str', offset)`}
Parameters	`value` Required; Any string. `str` Required; Substring to search for. If the `str` argument occurs as a substring within the value, then the index of the first character of the first such substring is returned; if it does not occur as a substring, -1 is returned. `offset` Required; Number (positive or negative) to offset the found index.

Return Index of Rightmost Occurrence of Substring Plus Offset in String Variable

Description	Returns the index within this string of the rightmost occurrence of the specified substring, plus the specified offset. The returned index is the largest variable.
Syntax	`${_varLastIndexOfWithOffset('variableName', 'str', offset)`}
Parameters	`variableName` Required; Name of the variable being passed into the function. `str` Required; Substring to search for. If the `str` argument occurs as a substring within the variable, then the index of the first character of the first such substring is returned; if it does not occur as a substring, -1 is returned. `offset` Required; Number (positive or negative) to offset the found index.

Return Length of Value

Description	Returns the length of `value`.
Syntax	`${_length('value')`}
Parameters	`value` Required; Any string.

Return Length of Variable

Description	Returns the length of `variableName`.
Syntax	`${_varLength('variableName'[, useEmptyForUndefined])`}
Parameters	`variableName` Required; Name of the variable being passed into the function. `useEmptyForUndefined` Optional; Specification (true or false) for the handling of a missing variable name. Default is false. If `useEmptyForUndefined` = true, the function will return 0. If `useEmptyForUndefined` = false, the function will remain unresolved if the variable name does not exist.

Return New String that is Substring of Value

Description	Returns a new string that is a substring of `value`. The substring begins at `beginIndex` and extends to the character at `endIndex` -1.
Syntax	`${_substring('value', beginIndex[, endIndex])`}
Parameters	`value` Required; String to make a substring from. `beginIndex` Required; Beginning index, inclusive. `endIndex` Optional; Ending index, exclusive.
Example	${_substring('hamburger', 4, 8)} --> urge ${_substring('smiles', 1, 5)} --> mile

Return New String that is Substring of Variable

Description	Returns a new string that is a substring of `variableName`. The substring begins at `beginIndex` and extends to the character at `endIndex` -1.
Syntax	`${_varSubstring('variableName', beginIndex[, endIndex])`}
Parameters	`variableName` Required; Name of the variable being passed into the function. `beginIndex` Required; Beginning index, inclusive. `endIndex` Optional; Ending index, exclusive.
Examples	If the value of the `food` variable is hamburger, and the value of the `face` variable is smiles: ${_varSubstring('food', 4, 8)} --> urge ${_varSubstring('face', 1, 5)} --> mile

Return URL-Encoded String

Description	Returns a URL-encoded string according to the ASCII Encoding Reference for UTF-8; all non-alphanumeric characters are replaced with their equivalent hexadecimal escape sequences.
Syntax	`${_varEncodeUrl('variableName')}`
Parameters	`variableName` Required; Name of the variable whose value will be converted to a URL encoded string.
Example	Where Variable rawstring contains a value of “`ABC$%^----DEF`": `${_varEncodeUrl(‘rawstring’)} --> ABC%24%25%5E----DEF`

Variable By XPath

Description	Resolves to the evaluated XPath 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.
Syntax	${_varXPath('variableName', 'xPathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}
Parameters	`variableName` Required; The name of the variable to apply the XPath expression to. `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 will be pretty printed (indented). Default is false.
Example	`my_variable= <message> <code>10</code> </message> ${_varXPath('my_variable', '//code/text()')} > 10`

Variable By JsonPath

Description	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. When using a JsonPath function, the output must be ONLY a JSON formatted string. If the output contains leading or trailing text, the function will fail to work properly.
Syntax	${_varJsonPath('variableName', 'pathExpression'[, 'defaultValue', 'delimiter', prettyPrint])}
Parameters	`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.
Example	`my_variable= { "code": 10 } ${_varJsonPath('my_variable', '$.code')} > 10`

Variable By JsonPath As Array

Description	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. When using a JsonPath function, the output must be ONLY a JSON formatted string. If the output contains leading or trailing text, the function will fail to work properly.
Syntax	${_varJsonPathAsArray('variableName', 'pathExpression'[, 'defaultValue', prettyPrint])}
Parameters	`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.
Example	`my_variable= [ { "message" : "Hello", "code" : 10 }, { "message" : "World!", "code" : 20 } ] ${_varJsonPathAsArray('my_variable', '$[*].message', '', true)} > [ "Hello", "World!" ]`

Variable Number of Lines

Description	Resolves to the number of lines the value of the specified variable has. If the variable is unresolved, the function will remain unresolved. If the variable is undefined, or blank, the function will resolve to 0.
Syntax	${_varNumberOfLines('variableName')}
Parameters	`variableName` Required; The name of the variable to return the number of lines for.
Example	`my_variable= Line 1 Line 2 Line 3 ${_varNumberOfLines('my_variable')} > 3`

Variable By Specific Line(s)

Description	Resolves to the specified line(s) of variable data for the specified variable. If the variable is unresolved, the function will remain unresolved. If the variable is undefined, blank, or no lines qualify, the function will resolve to the default value.
Syntax	${_varLines('variableName', startLine, numberOfLines[, 'defaultValue', 'resultDelimiter'])}
Parameters	`variableName` Required; The name of the variable to apply the function to. `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.
Example	`my_variable= Line 1 Line 2 Line 3 Line 4 ${_varLines('my_variable', 2, 2)} > Line 2 Line 3`

Variable By Line(s) Matching Regular Expression

Description	Resolves to the line(s) of variable data that match the specified regular expression, of the specified variable. If the variable is unresolved, the function will remain unresolved. If the variable is undefined, blank, or no lines qualify, the function will resolve to the default value.
Syntax	${_varLinesByRegex('variableName', 'regexPattern'[, maxCount, numberOfLinesBefore, numberOfLinesAfter, 'defaultValue', 'resultDelimiter'])}
Parameters	`variableName` Required; The name of the variable to apply the function to. `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 the result is not found. 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.
Example	`my_variable= Some_Text ABC=Some_String More_Text ${_varLinesByRegex('my_variable', '^ABC=')} /* Returns empty (the whole Line was not matched) / > ${_varLinesByRegex('my_variable', '^ABC=.')} > ABC=Some_String`

Variable Path

Description	Returns a token representing the path to a temporary file containing the value of the specified variable. $(ops_variable_path_<variableName><fileExtension>) The resolved token is supported within the Command, Parameters, and Script of a Windows and Linux/Unix Task.
Syntax	${_varPath('variableName'[, 'fileExtension'])}
Parameters	`variableName` Required; The variable to create a temporary file for. `fileExtension` Optional; The extension to use for the temporary file. Can be a maximum of 10 characters. Default is txt.
Example	`application.exe -file ${_varPath('my_variable')} > application.exe -file $(ops_variable_path_my_variable_txt) application.exe -file ${_varPath('my_variable', 'csv')} > application.exe -file $(ops_variable_path_my_variable_csv)`

Variable CSV Record Count

Description	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.
Syntax	${_varCsvRecordCount('<variableName>')}
Parameters	`variableName` Required; Name of the variable.
Example	`my_variable="A","B","C","D"\n "E","F","G","H" ${_varCsvRecordCount('my_variable')} > 2`

Variable CSV Record Value Count

Description	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.
Syntax	${_varCsvRecordValueCount('variableName', recordIndex)}
Parameters	`variableName` Required; Name of the variable. `recordIndex` Required; record index number.
Example	`my_variable="A","B","C","D"\n "E","F","G","H" ${_varCsvRecordValueCount('my_variable','1')} > 4`

Variable CSV Record Value

Description	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.
Syntax	${_varCsvRecordValue('variableName', recordIndex, valueIndex)}
Parameters	`variableName` Required; Name of the variable. `recordIndex` Required; record index number. `valueIndex` Required; record index number.
Example	`my_variable="A","B","C","D"\n "E","F","G","H" ${_varCsvRecordValue('my_variable','1', '2')} > G`

Variable TSV Record Count

Description	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.
Syntax	${_varTsvRecordCount('<variableName>')}
Parameters	`variableName` Required; Name of the variable.
Example	`my_variable="A" "B" "C" "D"\n "E" "F" "G" "H" ${_varTsvRecordCount('my_variable')} > 2`

Variable TSV Record Value Count

Description	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.
Syntax	${_varTsvRecordValueCount('variableName', recordIndex)}
Parameters	`variableName` Required; Name of the variable. `recordIndex` Required; record index number.
Example	`my_variable="A","B","C","D"\n "E","F","G","H" ${_varTsvRecordValueCount('my_variable','1')} > 4`

Variable TSV Record Value

Description	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.
Syntax	${_varTsvRecordValue('variableName', recordIndex, valueIndex)}
Parameters	`variableName` Required; Name of the variable. `recordIndex` Required; record index number. `valueIndex` Required; record index number.
Example	`my_variable="A","B","C","D"\n "E","F","G","H" ${_varTsvRecordValue('my_variable','1', '2')} > G`

Var Delimited Value Count

Description	Resolves to the count of delimited values 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.
Syntax	${_varDelimitedValueCount('variableName', [delimiter])}
Parameters	`variableName` Required; The name of the variable to return the count of delimited strings. `delimiter` Optional;delimiter to split the output. default delimiter is comma(,).
Example	`data=A:B:C:D ${_varDelimitedValueCount('my_variable',':')} > 4`

Var Delimited Value

Description	Resolves to the indexed value of delimited values 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 remain unresolved. If an index is invalid, the function will remain unresolved.
Syntax	${_varDelimitedValue('variableName', valueIndex,[delimiter])}
Parameters	`variableName` Required; The name of the variable to return the indexed value of delimited strings. `valueIndex` Required; record index number. `delimiter` Optional;delimiter to split the output. default delimiter is comma(,).
Example	`data=A:B:C:D ${_varDelimitedValue('my_variable','2',':')} > C`

System Functions

Display Variables

Description	Displays all the defined and built-in variables associated with the task instance.
Syntax	`${_scope}`
Parameters	(none)
Example	${_scope} --> {ops_workflow_id=, ops_task_type=Unix, ops_status=DEFINED, ops_retry_interval=60, ops_exit_code=0, ops_retry_maximum=0, ops_cmd_parms=, ops_cmd=ls -la; exit ${_random('9')};, ops_retry_count=0, ops_agent_id=67e4994143d2617201cdf4ba9df9ab0a, ops_task_id=84880af243d26172019aa1d25988a8f9, ops_task_name=uc - Linux Ls}

Generate Random Number

Description	Generates a random number between `max` (inclusive) and `min` (inclusive)
Syntax	`${_random([max, min])`}
Parameters	`max` Optional; Upper bound (inclusive) on the random number. Default is 9. `min` Optional; Lower bound (inclusive) on the random number. Default is 0.

Resolve to GUID (Globally Unique ID)

Description	Resolves to a 32-byte GUID (Globally Unique ID).
Syntax	`${_guid}`
Parameters	(none)

Resolve to Host Name

Description	Resolves to the hostname of the machine running the Controller, if available.
Syntax	`${_hostname}`
Parameters	(none)

Resolve to IP Address

Description	Resolves to the IP address of the machine running the Controller.
Syntax	`${_ipaddress}`
Parameters	(none)

Resolve to the Sibling SYS_ID

Description	Resolves to the Glossary#sys_id of the first task instance found within the same workflow specified by the sibling name.
Syntax	`${_siblingid('sibling_name')`}
Parameters	`sibling_name` Required; Sibling name.
Example	${_siblingid('Timer 60')} --> 5dbaaab943d26172015e10ab3e894e10

Resolve to Variable Value

Description	Locates the specified variable in the specified sibling task instance within the same workflow and resolves to the variable value.
Syntax	`${_varLookup('sibling_name', 'variable_name'[,'def'])`}
Parameters	`sibling_name` Required; Name of the sibling task instance from which the function is collecting the variable value. `variable_name` Required; Name of the variable being collected by the function. `def` Optional; Default value to return if the variable is not defined in the sibling task instance.

Resolve Variable

Description	Resolves the variable specified by the `variable_name` parameter and substitutes the `default_value` if the variable cannot be resolved.
Syntax	`${_resolve('variable_name', 'default_value')`}
Parameters	`variable_name` Required; Variable name. `default_value` Required; Default value to use if the variable cannot be resolved.

Resolve Variable (Advanced)

Description	Resolves the variable specified by the `variable_name` parameter and substitutes the default value if the variable cannot be resolved.
Syntax	`${_resolveadv('variable_name', 'default_value', [use_default_if_blank])`}
Parameters	`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 _resolve.)

Universal Task Functions

Convert Array Field Variable

Description	Given the variable name representing the Array field, generate a String of delimited Array field entry data. The function will remain unresolved if the Array field contains unresolved variables or functions.
Syntax	`${_convertArrayFieldVariable('arrayFieldVariableName'[,'delimiter', 'separator', 'keyQuote', 'valueQuote'])`}
Parameters	`arrayFieldVariableName` Required; Name of the variable for the Array Field; for example, *ops_af_p2*. delimeter Optional; Value to be used to delimit the Name from the Value. Default is =. separator Optional; Value to be used to separate one entry/row from the next. Default is comma (,). keyQuote Optional; Quoting to be used around the Name. Default is "no quoting." valueQuote Optional; Quoting to be used around the Value. Default is "no quoting."
Example	ops_af_p1 ---------- P1A=5 P1B=42 ---------- ops_af_p2 ---------- P2A=Red P2B=White P2C=Blue ---------- convertArrayFieldVariable(String arrayFieldVariableName, String delimiter, String separator, String keyQuote, String valueQuote) ================================================================================================================================ ${_convertArrayFieldVariable('ops_af_p1')} P1A=5,P1B=42 --------------- ${_convertArrayFieldVariable('ops_af_p1', '=')} P1A=5,P1B=42 --------------- ${_convertArrayFieldVariable('ops_af_p1', ':')} P1A:5,P1B:42 --------------- ${_convertArrayFieldVariable('ops_af_p1', ':', ';')} P1A:5;P1B:42 --------------- ${_convertArrayFieldVariable('ops_af_p1', '::', ',', '\'')} 'P1A'::5,'P1B'::42 --------------- ${_convertArrayFieldVariable('ops_af_p1', '=', ',', '\'', '"')} 'P1A'="5",'P1B'="42" --------------- ${_convertArrayFieldVariable('ops_af_p1', "", "", '\'', '\'')} 'P1A'='5','P1B'='42' --------------- ${_convertArrayFieldVariable('ops_af_p1', ':', '\\n', '\'', '\'')} 'P1A':'5' 'P1B':'42' --------------- ${_convertArrayFieldVariable('ops_af_p2')} P2A=Red,P2B=White,P2C=Blue --------------- ${_convertArrayFieldVariable('ops_af_p2', '=')} P2A=Red,P2B=White,P2C=Blue --------------- ${_convertArrayFieldVariable('ops_af_p2', ':')} P2A:Red,P2B:White,P2C:Blue --------------- ${_convertArrayFieldVariable('ops_af_p2', ':', ';')} P2A:Red;P2B:White;P2C:Blue --------------- ${_convertArrayFieldVariable('ops_af_p2', '::', ',', '\'')} 'P2A'::Red,'P2B'::White,'P2C'::Blue --------------- ${_convertArrayFieldVariable('ops_af_p2', '=', ',', '\'', '"')} 'P2A'="Red",'P2B'="White",'P2C'="Blue" --------------- ${_convertArrayFieldVariable('ops_af_p2', '', '', '\'', '\'')} 'P2A'='Red','P2B'='White','P2C'='Blue' --------------- ${_convertArrayFieldVariable('ops_af_p2', ':', '\\n', '\'', '\'')} 'P2A':'Red' 'P2B':'White' 'P2C':'Blue' ---------------

Get Array Field Variable Value

Description	Given the variable name representing the Array field and the name of an entry in the Array field, return the value for the entry.
Syntax	`${_getArrayFieldVariableValue('arrayFieldVariableName', 'name')`}
Parameters	`arrayFieldVariableName` Required; Name of the variable for the Array Field; for example, *ops_af_p1*. `name` Required; Name of the entry for which the value is to be returned.
Example	ops_af_p1 ---------- P1A=5 P1B=42 ---------- ops_af_p2 ---------- P2A=Red P2B=White P2C=Blue ---------- getArrayFieldVariableValue(String arrayFieldVariableName, String name) ======================================================== P1A = ${_getArrayFieldVariableValue('ops_af_p1', 'P1A')} ---------- P1A=5 ---------- P1B = ${_getArrayFieldVariableValue('ops_af_p1', 'P1B')} ---------- P1B=42 ---------- P2A = ${_getArrayFieldVariableValue('ops_af_p2', 'P2A')} ---------- P2A=Red ---------- P2B = ${_getArrayFieldVariableValue('ops_af_p2', 'P2B')} ---------- P2B=White ---------- P2C = ${_getArrayFieldVariableValue('ops_af_p2', 'P2C')} ---------- P2C=Blue ----------

Web Service Functions

All functions will remain unresolved if no Web Service output record can be found for the task instance, for the current attempt.

All functions will remain unresolved if a required parameter either is not specified or specified incorrectly.

Raw Output from Web Service Task

Description

Resolves to the raw output data of the Web Service task instance that is resolving the function.

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.

Syntax

${_responseRaw(['default_value'])}

Parameters

default_value
Optional; Default value to return if the result is not found. Default is empty ('').

Raw Output from Sibling Web Service Task

Description

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

Syntax

${_responseRawFromTask('siblingName'[,'defaultValue'])}

Parameters

siblingName
Required; Name of a sibling task instance.
default_value
Optional; Default value to return if the result is not found. Default is empty ('').

XML Output Data from Web Service Task

Description	Resolves to the XML output data of the Web Service 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.
Syntax	`${_responseXPath('xPathExpression'[,'defaultValue','delimiter',prettyPrint])`}
Parameters	`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.
Examples	If you want to obtain the `info` element text from the following Web Service Task XML output, you could use either of two examples for this Function. <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <command-response> <type>set_variable</type> <success>true</success> <info>No changes detected for variable variableName, ignoring Set Variable command.</info> <errors></errors> </command-response> Example 1 ${_responseXPath('//info')} Select the info node in the document no matter where it is. Example 2 ${_responseXPath('/command-response/info')} Select the info node from a specific path in the document, starting from the root node. Using either of these examples will resolve to the following: No changes detected for variable `variableName`, ignoring Set Variable command.

XML Output Data From Sibling Web Service Task

Description

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

Syntax

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

Parameters

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

JSON Output Data From Web Service Task

Description

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.

Syntax

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

Parameters

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 Output Data From Sibling Web Service Task

Description

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.

Syntax

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

Parameters

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.

JSON Output Data As Array From Web Service Task

Description

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.

Syntax

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

Parameters

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 Output Data As Array From Sibling Web Service Task

Description

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.

Syntax

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

Parameters

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.

Browser not supported