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)}
- 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 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
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 | |
---|
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 | |
---|
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.htmlyear_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. |
---|
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.htmlday_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. |
---|
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.htmlyear_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. |
---|
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.htmlreverse 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. |
---|
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.htmlreverse 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. |
---|
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 | 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
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 | |
---|
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. |
---|
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. |
---|
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. |
---|
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. |
---|
Syntax | ${_outputTsvRecordCountFromTask('siblingName','outputType')} |
---|
Parameters | |
---|
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. |
---|
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. |
---|
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. |
---|
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. |
---|
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. |
---|
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. |
---|
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 ('').
|
---|
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 ('').
|
---|
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.
|
---|
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.
|
---|
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.aspdefaultValue 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.aspdefaultValue 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.
|
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/JsonpathdefaultValue 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.
|
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
|
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/JsonpathdefaultValue 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.
|
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.
|
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/JsonpathdefaultValue 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.
|
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/JsonpathdefaultValue 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 | |
---|
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 | |
---|
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 | |
---|
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)
|
---|
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 . |
---|
|
---|