All Functions

Converts an array that contains other arrays into an array of single items.

a!flatten([array])

Inserts new values or replaces existing values at the specified index or field name and returns the resulting updated data.

a!update([data], [index], [value])

Appends a value or values to the given array, and returns the resulting array.

append([array], [value])

Returns the data[index] if it is valid or else returns the default value.

index([data], [index], [default])

Inserts a value into the given array and returns the resulting array.

insert([array], [value], [index])

Concatenates the elements of an array together into one string and inserts a string separator between each element.

joinarray([array], [separator])

Drops a given number of values from the left side of an array and returns the resulting array.

ldrop([array], [number])

This function returns the number of elements in an array.

length([array])

Drops a given number of values from the right side of an array, and returns the resulting array.

rdrop([array], [number])

Removes the value at a given index from an array, and returns the resulting array.

remove([array], [index])

Returns an array in reverse order.

reverse([array])

Inserts new values or modifies existing values at the specified index of a given array, and returns the resulting array.

updatearray([array], [index], [value])

Returns the indexes where the values in the input array are true.

where([booleanArray], [default])

Receives one or more values and returns an array of indexes that indicate the position of the values within the array.

wherecontains([values], [array])

Converts a Binary number as text to a Decimal number.

bin2dec([value])

Converts a Binary number as text to a Hex number as text.

bin2hex([value], [place])

Converts a Binary number as text to an Octal number as text.

bin2oct([value], [place])

Converts a Decimal number to a Binary number as text.

dec2bin([value], [place])

Converts a Decimal number to a Hex number as text.

dec2hex([value], [place])

Converts a Decimal number to an Octal number as text.

dec2oct([value], [place])

Converts a Hex number as text to a Binary number as text.

hex2bin([value], [place])

Converts a Hex number as text to a Decimal number.

hex2dec([value])

Converts a Hex number as text to an Octal number as text.

hex2oct([value], [place])

Converts an Octal number as text to a Binary number as text.

oct2bin([value], [place])

Converts an Octal number as text to a Decimal number.

oct2dec([value])

Converts an Octal number as text to a Hex number as text.

oct2hex([value], [place])

Creates an object that contains the information required to perform HTTP Basic authentication.

a!httpAuthenticationBasic([username], [password], [preemptive])

Creates an HTTP form part which can be passed in an integration’s multipart request body.

a!httpFormPart([name], [contentType], [value])

Creates an HTTP header object which can be passed to an HTTP function.

a!httpHeader([name], [value])

Creates an HTTP query parameter object which can be passed to an HTTP function.

a!httpQueryParameter([name], [value])

Creates an object which contains the information required to access data in the Secure Credentials Store.

a!scsField([externalSystemKey], [fieldKey], [usePerUser])

Allows you to verify the reCAPTCHA connection was successful and access reCAPTCHA scores to help protect your Portal against potentially malicious activity.

a!verifyRecaptcha([onSuccess], [onError])

Constructs the config parameter to the webservicequery() and webservicewrite() functions.

a!wsConfig([wsdlUrl], [service], [port], [operation], [wsdlCredentials], [endpointcredentials], [extensions])

Constructs a WsHttpCredentials object for use with a!wsConfig.

a!wsHttpCredentials([username], [password], [domain])

Constructs a WsHttpHeaderField object for use with a!wsConfig.

a!wsHttpHeaderField([name], [name])

Constructs a WsUsernameToken object for use with a!wsConfig.

a!wsUsernameToken([username], [password])

Constructs a WsUsernameTokenScs object for use with a!wsConfig.

a!wsUsernameTokenScs([systemKey], [usePerUser])

Tries to match a value in a given array with a value at the same index in a replacement array and returns either the value at the same index or a default value if the value is not found.

displayvalue([value], [inArray], [replacement], [default])

Converts the given value to a string representation so that it can be saved externally.

externalize([value])

Converts the given externalized string representation of a value to the original value.

internalize([externalizedText], [default])

Converts a value to Boolean.

toboolean([value])

Converts a value to Community.

tocommunity([value])

Converts a value to Date with Timezone.

todate([value])

Converts a value to Date and Time with Timezone.

todatetime([value])

Converts a value to Decimal (double-precision floating-point number).

todecimal([value])

Converts a value to Document.

todocument([value])

Converts a value to email address.

toemailaddress([value])

Converts a value to email recipient.

toemailrecipient([value])

Converts a value to Folder.

tofolder([value])

Converts a value to Integer.

tointeger([value])

Converts a value to Interval (Day to Second).

tointervalds([value])

Converts a value to Knowledge Center.

toknowledgecenter([value])

Converts a value to Text.

tostring([value])

Converts a value to Time.

totime([value])

Converts a value or list to text, preserving the original scalar or array structure.

touniformstring([value])

Used to create a real-time custom record field, this function concatenates the specified values into a single value.

a!customFieldConcat([value])

Used in the whenTrue parameter of a!customFieldMatch(), this function allows you to create a condition.

a!customFieldCondition([field], [operator], [value])

Used to create a real-time custom record field, this function returns the difference between two dates as a Number (Integer). The difference can be returned in days, hours, minutes, or seconds. Returns null when the startDate or endDate is null or empty.

a!customFieldDateDiff([startDate], [endDate], [interval])

Used to create a real-time custom record field, this function returns a default value when the specified value is null or empty. All parameters must be of the same data type. When there are multiple default parameters, each parameter is evaluated in order and the first non-null or non-empty default will be returned.

a!customFieldDefaultValue([value], [default])

Used to create a real-time custom record field, this function returns the results of dividing two numbers. You can use record fields, related record fields, or literal values of type Number (Integer) or Number (Decimal) in your calculation.

a!customFieldDivide([numerator], [denominator])

Used in the whenTrue parameter of a!customFieldMatch(), this function allows you to group multiple logical conditions using the "AND" and "OR" operators.

a!customFieldLogicalExpression([operator], [conditions])

Used to create a real-time custom record field, this function evaluates the value parameter against multiple conditions and returns a value based on a match. If no match is found, the default parameter is returned.

a!customFieldMatch([value], [equals], [whenTrue], [then], [default])

Used to create a real-time custom record field, this function returns the result of multiplying a series of values. You can multiply record fields, related record fields, or literal values of type Number (Integer) or Number (Decimal).

a!customFieldMultiply([value])

Used to create a real-time custom record field, this function returns the difference between two numbers. You can subtract record fields, related record fields, or literal values of type Number (Integer) or Number (Decimal).

a!customFieldSubtract([value1], [value2])

Used to create a real-time custom record field, this function returns a sum of values. You can calculate the sum of record fields, related record fields, or literal values of type Number (Integer) or Number (Decimal).

a!customFieldSum([value])

Adds the specified increments of time to the startDateTime and returns a date and time value. You can select a process calendar to ensure the return value falls within the specified working days and time.

a!addDateTime([startDateTime], [years], [months], [days], [hours], [minutes], [seconds], [useProcessCalendar], [processCalendarName])

This function adds a given number of working days as designated on the process calendar to a Date and Time value, and returns a Date and Time value that falls within the work time defined in the process calendar.

caladddays([start_datetime], [number], [calendar_name])

This function adds a given number of hours to a Date and Time plus any non-working hours (as designated on the process calendar) and returns the resulting Date and Time.

caladdhours([start_datetime], [number], [calendar_name])

This returns whether or not the given Date and Time is a work day, according to the calendar defined for the system.

calisworkday([datetime], [calendar_name])

This returns whether or not the given Date and Time is within working hours, according to the calendars defined for the system.

calisworktime([datetime], [calendar_name])

This returns the actual number of work days between two Date and Times (both inclusive), according to the calendar defined for the system.

calworkdays([start_datetime], [end_datetime], [calendar_name])

This returns the actual number of work hours between two given Date and Times (both inclusive), according to the calendar defined for the system.

calworkhours([start_datetime], [end_datetime], [calendar_name])

Converts text into data accepted by the date data type and functions that require date parameters.

date([year], [month], [day])

Converts the given Date and Time into a serial number that holds the Date and Time data type.

datetime([year], [month], [day], [hour], [minute], [second])

Converts a value to a date.

datevalue([value])

Returns the day of the month from the date specified.

day([date])

Returns the day number within the year.

dayofyear([date])

Returns the number of days between two dates, based on a 360-day calendar.

days360([start_date], [end_date], [method])

Returns the number of days in the given month in the given year.

daysinmonth([month], [year])

Returns the date that is the number of months before or after the given starting date.

edate([starting_date], [months])

Returns the date for the last day of the month that is the number of months before or after the given starting date.

eomonth([starting_date], [months])

Subtracts a time zone offset from a given Date and Time.

gmt([datetime], [timezone])

Returns the hour from the time specified.

hour([time])

Converts the given time components into an equivalent time duration, an interval expressing days to seconds. This value is treated as a duration (Joe ran the marathon in 3 hours and 23 minutes), not a point in time.

intervalds([hour], [minute], [second])

Returns a Boolean value for whether the given year is a leap year.

isleapyear([year])

Returns a Boolean value for whether the given date is within the last given number of days.

lastndays([date], [n])

This is a Date and Time addition function, adding time zone offset to given Date and Time.

local([datetime], [timezone])

This function returns the millisecond portion of a timestamp or the decimal number that represents 1 millisecond in days.

milli([time])

Returns the minute from the time specified.

minute([time], [minute])

Returns the month from the specified date.

month([date])

Returns the number of working days between two specified dates.

networkdays([starting_date], [ending_date], [holidays])

Returns the current Date and Time as a serial number.

now([])

Returns the seconds from the specified time.

second([time])

Subtracts the specified increments of time from the startDateTime and returns a date and time value. You can select a process calendar to ensure the return value falls within the specified working days and time.

a!subtractDateTime([startDateTime], [years], [months], [days], [hours], [minutes], [seconds], [useProcessCalendar], [processCalendarName])

Converts the given time into an equivalent time value.

time([hour], [minute], [second], [millisecond])

Converts the given time into an equivalent interval.

timevalue([time_text])

Returns the default offset in minutes from GMT, which is generally the process initiator's time zone.

timezone([])

Returns the time zone ID for the current context.

timezoneid([])

Returns the current day in GMT.

today([])

Returns the day of the week of the specified date.

weekday([date], [return_type])

Returns the week number within the year for the given date using a given methodology.

weeknum([date], [methodology])

Returns the date the given number of workdays before or after the given date.

workday([starting_date], [days], [holidays])