AppConnect Data Types and Formulas

In Ruby, strings refer to sequences of text and characters.

AppConnect supports a variety of string formulas. Formulas in AppConnect are whitelisted Ruby methods, and therefore not all Ruby methods are supported. Formulas can be requested for addition to the whitelist. Syntax and functionality for these formulas are generally unchanged. Most formulas return an error and stop the job if they operate on a null (nil in Ruby); the exceptions are present? , presence and blank? .

The examples below show methods for manipulating a string of text. The input string in each case is ‘Jean Marie’.

Conditionals

blank?

This formula checks the input string and returns true if it is an empty string or if it is null.

Input.blank?

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

If the input is null or an empty string, the formula will return false. For any other data, it returns true.

is_not_true?

Converts a value to boolean and returns true if the value is not truthy.

Input.is_not_true?

• Input - An input number or a string.

Converts the input into a boolean and returns true if the value is not truthy. truthy vs falsey

is_true?

Converts a value to boolean and returns true if the value is truthy.

Input.is_true?

• Input - An input number or a string.

Converts the input into a boolean and returns true if the value is truthy. truthy vs falsey

present?

This formula will check the input and if there is a value present, it will return true. If the input is nil, an empty string or an empty list, the function will return false.

Input.present?

• Input - An input datapill. It can be a string, number, date, or list datatype.

If the input is null, an empty string or an empty list, the formula will return false. For any other data, it returns true. Evaluating a list with nil values

presence

Returns the data if it exists, returns nil if it does not.

Input.presence

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

If the input is null or an empty string, the formula will return nil. For any other data, it returns the original input data.

include?

Checks if the string contains a specific substring. Returns true if it does.

Input.include?(substring)

• Input - A string input. substring - The substring to check for.

This formula checks if the string contains a specific substring. Returns true if it does, otherwise, returns false. This substring is case sensitive. This function acts in an opposite manner from exclude? . It will return true only if the input string contains the stated keyword.

exclude?

Checks if the string contains a specific substring. Returns false if it does.

Input.exclude?(substring)

• Input - A string input. substring - The substring to check for.

This formula check is the string contains a specific substring. Returns false if it does, otherwise, returns true. This substring is case sensitive. This function acts in an opposite manner from include? . It will return true only if the input string does NOT contain the stated keyword.

match?

Checks if the string contains a specific pattern. Returns true if it does.

Input.match?(pattern)

• Input - A string input. pattern - The pattern to check for.

This formula check is the string contains a specific pattern. Returns true if it does, otherwise, returns false.

ends_with?

Checks if the string ends with a specific substring. Returns true if it does.

Input.ends_with?(substring)

• Input - A string input. substring - The substring to check for.

This formula check is the string ends with a specific substring. Returns true if it does, otherwise, returns false.

starts_with?

Checks if the string starts with a specific substring. Returns true if it does.

Input.starts_with?(substring)

• Input - A string input. substring - The substring to check for.

This formula check is the string starts with a specific substring. Returns true if it does, otherwise, returns false.

Text manipulation

parameterize

Replaces special characters in a string. Used when app does not accept non-standard characters.

Input.parameterize

• Input - An input string.

This formula searches for special characters in the string and replaces them with standard characters. Used when app does not accept non-standard characters.

lstrip

This formula removes the white space at the beginning of the input string.

String.lstrip

• String - An input string.

This formula removes white spaces from the beginning of a string. If the string doesn’t have any white spaces before, the input string will be returned as is. Quicktip: Selectively remove white spaces

rstrip

This formula removes the white space at the end of the input string.

String.rstrip

• String - An input string.

This formula removes white spaces from the end of a string. If the string doesn’t have any white spaces at the end, the input string will be returned as is. Quicktip: Selectively remove white spaces

strip

This formula removes the white space at the beginning and the end of the input string.

String.strip

• String - An input string.

This formula removes white spaces from both sides of a string. If the string doesn’t have any white spaces before or after, the input string will be returned as is. Quicktip: Selectively remove white spaces

strip_tags

This formula removes html tags embedded in a string.

String.strip_tags

• String - An input string.

This formula checks for html tags within the input string. It removes any html tags found and returns the string.

ljust

Aligns the string to left and pads with whitespace or pattern until string is specified length.

String.ljust(length,character)

• String - An input string. length - The length of the output string. character - (optional) The character to pad the string. If unspecified, the default pad character will be a blank space.

rjust

Aligns the string to left and pads with whitespace or pattern until string is specified length.

String.rjust(length,character)

• String - An input string. length - The length of the output string. character - (optional) The character to pad the string. If unspecified, the default pad character will be a blank space.

reverse

Inverts a string, reordering the characters in a backward manner. Case is preserved.

String.reverse

• String - An input string.

gsub

Replace parts of a text string. Returns a new string with the replaced characters.

String.gsub(find,replace)

• String - An input string. You can use a datapill or a static string value. find - The string to look for. You can use a /pattern/ syntax. replace - The replacement string. You can define the replacement using a string or hash .

This formula works like find and replace. It takes two input parameters: The first input is the string that you want to replace. This is case-sensitive - so make sure to type correctly in either uppercase or lowercase to find all occurrences that are an exact match. The second input is the new string that will be used for replacing all occurrences of first input.

sub

Replaces the first occurrence of the first input value, with the second input value, within the string. This formula is case-sensitive - make sure to type in uppercase or lowercase before comparison if you are concerned about case sensitivity.

String.sub(find,replace)

• String - An input string. You can use a datapill or a static string value. find - The string to look for. You can use a /pattern/ syntax. replace - The replacement string. You can define the replacement using a string or hash .

length

Returns the number of characters within an input string, including the white-spaces.\

String.length

• String - An input string.

slice

Returns a partial segment of a string.

String.slice(start,end)

• String - An input string. start - The index of the string to start returning. end - (optional) The number of characters to return. If unspecified, the formula will return only one character.

The formula returns a partial segment of a string. It takes in 2 parameters - the first parameter is the index that decides which part of the string to start returning from (first letter being 0 and subsequently progressing incrementally, negative numbers will be taken from the last character), the second parameter decides how many characters to return. If only the first parameter is passed in, only 1 character will be returned.

scan

Scan the string for the pattern to retrieve and return an array

String.scan(pattern)

• String - An input string. pattern - The pattern to search for.

encode

Returns the string in a given encoding.

String.encode(encoding)

• String - An input string. encoding - Name of the encoding (e.g. Windows-1252).

transliterate

Replaces non-ASCII characters with an ASCII approximation, or if none exists, a replacement character which defaults to ‘?’.

String.transliterate

• String - An input string.

Text case manipulation

capitalize

Converts the input string into sentence case, i.e. the first character of each sentence is capitalized.

String.capitalize

• String - An input string.

titleize

Converts the input string into title case, i.e. the first character of each word is capitalized.

String.titleize

• String - An input string.

upcase

Convert text to uppercase.

String.upcase

• String - An input string.

This formula searches for any lowercase character and replace it with the uppercase characters. Quicktip: Search strings better with upcase

downcase

Convert text to lowercase.

String.downcase

• String - An input string.

This formula searches for any uppercase character and replace it with the lowercase characters. Quicktip: Search strings better with downcase

quote

Quotes a string, escaping any ’ (single quote) characters

String.quote

• String - An input string.

Converting to arrays and back

split

This formula divides a string around a specified character and returns an array of strings.

String.split(char)

• String - An input string value. You can use a datapill or a static value. char - (optional) The character at which to split the text. This is case sensitive. If no character is defined, then by default, strings are split by white spaces.

This formula looks for the specified character in the input string. Every time it is found, the input will be split into a new string. Split character(s)

bytes

Returns an array of bytes for a given string.

String.bytes

• String - An input string.

Conversion formulas

Conversion of other data types to strings

to_s

Converts data to a string (text) datatype.

Input.to_s

• Input - Any input data. You can use number, array, object, or datetime datatypes.

This formula returns a string representation of the input data. Quicktip: Output is a string datatype.

ordinalize

Turns a number into an ordinal string used to denote the position in an ordered sequence such as 1st, 2nd, 3rd, 4th.

Input.ordinalize

• Input - Any input number.

Conversion of strings to other data types

to_f

Converts data to a float (number) datatype.

Input.to_f

• Input - An number input data. You can use a string datatype or a integer datatype.

This formula checks whether the input contains any numbers, if no numbers are found, it returns 0. If the number does not have a decimal point, .0 will be added the number.

to_i

Converts data to an integer (whole number) datatype.

Input.to_i

• Input - An number input data. You can use a string datatype or a float datatype.

This formula checks whether the input contains any numbers, if no numbers are found, it returns 0. If the number has a decimal point, everything after the decimal will be omitted. Check for integers

to_country_alpha2

Convert alpha-3 country code or country name to alpha2 country code (first 2 initials).

Input.to_country_alpha2

• Input - Any input string.

to_country_alpha3

Convert alpha-2 country code or country name to alpha3 country code (first 3 initials).

Input.to_country_alpha3

• Input - Any input string.

to_currency

Formats integers/numbers to a currency-style.

Input.to_currency

• Input - Any input string.

to_currency_code

Convert alpha-2/3 country code or country name to ISO4217 currency code

Input.to_currency_code

• Input - Any input string.

to_currency_name

Convert alpha-3 currency code or alpha-2/3 country code or country name to ISO4217 currency name.

Input.to_currency_name

• Input - Any input string.

to_currency_symbol

Convert alpha-3 currency code or alpha-2/3 country code or country name to ISO4217 currency symbol.

Input.to_currency_symbol

• Input - Any input string.

to_phone

Converts string or number to a formatted phone number (user-defined).

Input.to_phone

• Input - Any input string or number.

to_state_code

Convert state name to code.

Input.to_state_code

• Input - Any input string.

to_state_name

Convert state code to name.

Input.to_state_name

• Input - Any input string.

bytesize

Returns the length of a given string in bytes.

Input.bytesize

• Input - Any input string.

In Ruby, Fixnum refers to integers, e.g. 9, 10, 11, while Float refers to decimals, e.g. 1.75.

AppConnect supports a variety of number formulas. Formulas in AppConnect are whitelisted Ruby methods, and therefore not all Ruby methods are supported. Formulas can be requested for addition to the whitelist. Syntax and functionality for these formulas are generally unchanged. Most formulas return an error and stop the job if they operate on a null (nil in Ruby); the exceptions are present? , presence and blank? .

In the cases of arithmetic operations, whether the values are of integer types or decimal (float) types are important. Formulas will alway stick to the types given as input, and the returned result will be of the most precise type.

Arithmetic operations

The add (+) operator

This operator allows the addition of operands on either side. This section covers number arithmetic. Date arithmetic is also possible.

The subtract (-) operator

This operator subtracts the right hand operand from the left hand operand. This section covers number arithmetic. Date arithmetic is also possible.

The multiply (*) operator

This operator multiplies the operands on either side.

The divide (/) operator

Divides left hand operand by right hand operand.

The exponential (**) operator

Left hand operand to the power of the right hand operand.

The modulo (%) operator

Divides left hand operand by right hand operand and returns the remainder.

Other number formulas

abs

Returns the absolute (positive) value of a number.

number.abs

• number - An input integer or float.

round

Rounds off a numerical value. This formula returns a value with a specified number of decimal places.

number.round(offset)

• number - An input integer or float. offset - (optional) The number of decimal places to return, you can provide negative values. If not specified, this formula will return the number with no decimal places.

Conditionals

blank?

This formula checks the input and returns true if it is non a value number or if it is null.

Input.blank?

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

If the input is null or an empty string, the formula will return false. For any other data, it returns true.

even?

Checks the integer input and returns true if it is an even number.

integer.even?

• integer - An input integer.

odd?

Checks the integer input and returns true if it is an odd number.

integer.odd?

• integer - An input integer.

is_not_true?

Converts a value to boolean and returns true if the value is not truthy.

Input.is_not_true?

• Input - An input number or a string.

Converts the input into a boolean and returns true if the value is not truthy. truthy vs falsey

is_true?

Converts a value to boolean and returns true if the value is truthy.

Input.is_true?

• Input - An input number or a string.

Converts the input into a boolean and returns true if the value is truthy. truthy vs falsey

present?

This formula will check the input and if there is a value present, it will return true. If the input is nil, an empty string or an empty list, the function will return false.

Input.present?

• Input - An input datapill. It can be a string, number, date, or list datatype.

If the input is null, an empty string or an empty list, the formula will return false. For any other data, it returns true. Evaluating a list with nil values

presence

Returns the data if it exists, returns nil if it does not.

Input.presence

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

If the input is null or an empty string, the formula will return nil. For any other data, it returns the orignal input data.

Conversions

ceil

Rounds the input number to the next greater integer or float. You can specify the precision of the decimal digits.

number.ceil(precision)

• number - An input integer or float. precision - (optional) The number of decimal places to return, you can provide negative values. If not specified, this formula will return the number with no decimal places.

floor

Rounds the input number to the next smaller integer or float. You can specify the precision of the decimal digits.

number.floor(precision)

• number - An input integer or float. precision - (optional) The number of decimal places to return, you can provide negative values. If not specified, this formula will return the number with no decimal places.

to_f

Converts data to a float (number) datatype.

Input.to_f

• Input - An number input data. You can use a string datatype or a integer datatype.

This formula checks whether the input contains any numbers, if no numbers are found, it returns 0. If the number does not have a decimal point, .0 will be added the number.

to_i

Converts data to an integer (whole number) datatype.

Input.to_i

• Input - An number input data. You can use a string datatype or a float datatype.

This formula checks whether the input contains any numbers, if no numbers are found, it returns 0. If the number has a decimal point, everything after the decimal will be omitted. Check for integers

to_s

Converts data to a string (text) datatype.

Input.to_s

• Input - Any input data. You can use number, array, object, or datetime datatypes.

This formula returns a string representation of the input data. Quicktip: Output is a string datatype.

to_currency

Formats integers/numbers to a currency-style.

Input.to_currency

• Input - Any input string.

to_phone

Converts string or number to a formatted phone number (user-defined).

Input.to_phone

• Input - Any input string or number.

AppConnect supports a variety of date and datetime formulas. Formulas in AppConnect are whitelisted Ruby methods, and therefore not all Ruby methods are supported. Formulas can be requested for addition to the whitelist.

Syntax and functionality for these formulas are generally unchanged. Most formulas return an error and stop the job if they operate on a null (nil in Ruby); the exceptions are present? , presence and blank? .

User settings within AppConnect cannot be edited to alter the time zone, although you can use formulas to convert the output to another time zone

Basics

now

Returns the time and date at runtime in US Pacific Time Zone.

The formula calculates the timestamp when the a job is being processed. Each step using this formula will return the timestamp at which the step runs. Output datapill

today

Returns the date at runtime in US Pacific Time Zone.

The formula calculates the timestamp when the a job is being processed. Each step using this formula will return the timestamp at which the step runs. Output datapill

from_now

Returns a future timestamp by a specified time duration. The timestamp is calculated at runtime.

Unit.from_now

• Unit - A time value to offset.

The formula calculates the current timestamp and offsets by a specified time duration. This timestamp is calculated when the a job is being processed. Each step using this formula will return a timestamp for each step that runs. Units

ago

Returns an earlier timestamp by a specified time duration. The timestamp is calculated at runtime.

Unit.ago

• Unit - A time value to offset.

The formula calculates the current timestamp and offsets by a specified time duration. This timestamp is calculated when the a job is being processed. Each step using this formula will return a timestamp for each step that runs. Units

wday

Returns day of the week. Sunday returns 0, monday returns 1.

Date.wday

• Date - A date or datetime datatype.

The formula calculates the current day when the a job is being processed. The day of the week is converted into an integer output. Sunday = 0, monday = 1. Quickip: Convert to date datatype

yday

Returns day number of the year.

Date.yday

• Date - A date or datetime datatype.

The formula calculates the current day when the a job is being processed. The day of the year is converted into an integer output. Quickip: Convert to date datatype

yweek

Returns week number of the year.

Date.yweek

• Date - A date or datetime datatype.

The formula calculates the current day when the a job is being processed. The week of the year is converted into an integer output. Quickip: Convert to date datatype

Getting first/last timestamp of the current/next periods

beginning_of_hour

Returns datetime for top-of-the-hour for a given datetime.

Datetime.beginning_of_hour

• Datetime - An input datetime.

beginning_of_day

Returns datetime for midnight on date of a given date/datetime.

Date.beginning_of_day

• Date - An input date or datetime.

beginning_of_week

Returns date of the previous monday for a given date/datetime.

Date.beginning_of_week

• Date - An input date or datetime.

beginning_of_month

Returns first day of the month for a given date/datetime.

Date.beginning_of_month

• Date - An input date or datetime.

beginning_of_year

Returns first day of the year for a given date/datetime.

Date.beginning_of_year

• Date - An input date or datetime.

end_of_month

Returns last day of the month for a given date/datetime. This formula will return a date or datetime based on the input data.

Date.beginning_of_month

• Date - An input date or datetime.

Display conversion

strftime

Returns a datetime input as a user-defined string.

Date.strftime(format)

• Date - An input date or datetime. format - The format of the user-defined datetime written as a string.

Lets you define a datetime format. Returns the datetime input in the specified format. Input datatype

in_time_zone

Converts a time value to a different timezone. This formula will return a date or datetime based on the input data.Syntax Date.in_time_zone(format)

This formula uses the list of timezone names from the IANA time zone database. The output will be an equivalent time in a different timezone.

dst?

Returns true if the input datatime is within Daylight Savings Time.

Datetime.dst?

• Datetime - An input date or datetime.

Converting datetime to date

to_date

This formula converts the input data into a date. Returns the date formatted as YYYY-MM-DD.

String.first(format: format)

• String - An input datetime or a string that describes a date or datetime. format - (optional) The date format of the input written as a string. If not specified, AppConnect will parse the input string automatically.

Converts the input data into a date datatype. Input data best practice

to_time

Converts a string to an ISO timestamp. The response will use the UTC timezone (+00:00).

String.to_time

• String - An input string that describes a date or datetime.

Converts the input string into a datetime datatype. The output datetime will be converted to the UTC timezone (+00:00). Autofill time

Conditionals

blank?

This formula checks the input string and returns true if it is an empty string or if it is null.

Input.blank?

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

If the input is null or an empty string, the formula will return false. For any other data, it returns true.

present?

This formula will check the input and if there is a value present, it will return true. If the input is nil, an empty string or an empty list, the formula will return false.

Input.present?

• Input - An input datapill. It can be a string, number, date, or list datatype.

If the input is null, an empty string or an empty list, the formula will return false. For any other data, it returns true. Evaluating a list with nil values

presence

Returns the data if it exists, returns nil if it does not.

Input.presence

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

If the input is null or an empty string, the formula will return nil. For any other data, it returns the orignal input data.

Arrays are ordered, integer-indexed collections of any object. List indexing starts at 0. Lists are the same as Ruby arrays, and this article uses the two terms interchangeably.

Take a list with 4 items: 100, 101, 102, 103. This list is expressed as:

Because lists are ordered, the following formula gets the values. AppConnect only supports retrieving up to the fifth item in the list:

Lists and hashes

When you work with formulas and repeating structures, there are 2 data structures you need to understand: arrays (lists) and hashes. Most formulas return an error and stop the job if they operate on a null (nil in Ruby); the exceptions are present? , presence and blank? .

Formulas

Example list of hashes

The following is an example of a list of hashes called Contacts . This is the Contacts list in a table form:

first

This formula returns the first item in a list. It can also be used to return the first n items in a list. In this case, the output will be formatted as a list.

List.first(number)

• List - An input list. number - (optional) The number of items to retrieve from the list. If not specified, the formula will return only one item.

This formula returns the first n items from a list. If n is greater than one, the output is formatted as a list. If you are returning a single item (i.e. no arguments provided). The output will be formatted according to the item’s datatype.

last

This formula returns the last item in a list. It can also be used to return the last n items in a list. In this case, the output will be formatted as a list.

List.last(number)

• List - An input list. number - (optional) The number of items to retrieve from the list. If not specified, the formula will return only one item.

This formula returns the last n items from a list. If n is greater than one, the output is formatted as a list. If you are returning a single item (i.e. no arguments provided). The output will be formatted according to the item’s datatype.

index

Returns the index of the first item matching the given value.

Input.index(value)

• Input - An input list. value - The value to search for in the list.

where

Retrieves only the rows (hashes) which satisfy the specified WHERE condition. This formula accepts a single argument in the form of a hash with one or more key-value pairs. The default operand for the condition is equal to ( == ). This formula also supports the following operands. Operands should be added to the end of key separated by a space.

pluck

Retrieves only the columns which have been specified.

format_map

Create an array of strings by formatting each row of given array of hashes. Static text can be added to the created strings. Fields to be represented in the format %{ <field_name> }.

join

Combines all items in a list into a text string. A separator is placed between each item.

List.join(separator)

• List - An input of list datatype. separator - The character to add between items when they are joined. If no separator is specified, the list items will be joined together.

The list items are combined into a single text string. The seperator character(s) is added between each item. Seperator character

smart_join

Joins list elements into a string. Removes empty and nil values and trims any white space before joining.

List.smart_join(separator)

• List - An input of list datatype. separator - The character to add between items when they are joined. If no separator is specified, a blank space will be used as the joining character.

reverse

Reverses the order of a list.

List.reverse

• List - An input of list datatype.

sum

For integers and decimals, the numbers will be added together and the total sum obtained. For strings, the strings will be concatenated together to form a longer string.

List.sum

• List - An input of list datatype.

uniq

Returns a list containing unique items i.e. remove duplicate items.

List.uniq

• List - An input of list datatype.

flatten

Flattens a multi-dimensional array (i.e. array of arrays) to a single dimension array.

List.flatten

• List - An input of list datatype.

length

Returns the number of elements in self. Returns 0 if the list is empty.

List.length

• List - An input of list datatype.

max

Returns largest value in an array. When comparing numbers, the largest number is returned. When comparing strings, the string with the largest ASCII value is returned.

List.max

• List - An input of list datatype.

min

Returns smallest value in an array. When comparing numbers, the smallest number is returned. When comparing strings, the string with the smallest ASCII value is returned.

List.min

• List - An input of list datatype.

compact

Removes nil values from array and hash.

Conditionals

blank?

This formula checks the input string and returns true if it is an empty string or if it is null.

Input.blank?

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

If the input is null or an empty string, the formula will return false. For any other data, it returns true.

include?

Checks if the string contains a specific substring. Returns true if it does.

Input.include?(substring)

• Input - A string input. substring - The substring to check for.

This formula check is the string contains a specific substring. Returns true if it does, otherwise, returns false. This substring is case sensitive. This function acts in an opposite manner from exclude? . It will return true only if the input string contains the stated keyword.

present?

This formula will check the input and if there is a value present, it will return true. If the input is nil, an empty string or an empty list, the function will return false.

Input.present?

• Input - An input datapill. It can be a string, number, date, or list datatype.

If the input is null, an empty string or an empty list, the formula will return false. For any other data, it returns true. Evaluating a list with nil values

presence

Returns the data if it exists, returns nil if it does not.

Input.presence

• Input - An input datapill. It can be a string, number, date, or datetime datatype.

If the input is null or an empty string, the formula will return nil. For any other data, it returns the orignal input data.

Conversion

to_csv

Generates CSV line from an array. This handles escaping. Nil values and empty strings will also be expressed within the csv line.

Input.to_csv

• Input - An input of list datatype.

to_json

Converts hash or array to JSON string.

Input.to_json

• Input - An input datapill. It can be a list or hash datatype.

to_xml

Converts hash or array into XML string.

Input.to_xml

• Input - An input datapill. It can be a list or hash datatype.

from_xml

Converts XML string to hash.

Input.from_xml

• Input - Input XML data.

encode_www_form

Join hash into url-encoded string of parameters.

Input.encode_www_form

• Input - An input of hash datatype.

to_param

Returns a string representation for use as a URL query string.

Input.to_param

• Input - An input of hash datatype.

keys

Returns an array of keys from the input hash.

Input.keys

• Input - An input of hash datatype.

Other formulas

null

Gives a null/nil value. Note: passing this into an input field will not update the field value as null. Use clear formula to update a field value to null. Remember to toggle the field to formula mode.

clear

Clears the value of the field in the target app to null/nil. Remember to toggle the field to formula mode. Use clear formula instead of null when looking to clear field in target app

uuid

Generates an UUID.

encrypt

Encrypts the input string with a secret key using AES-256-CBC algorithm. Encrypted output string is packed in RNCryptor V3 format and base64 encoded. Note: The encryption key should not be hard coded in the recipe. Use account properties (with key or password in the name) to store the encryption keys.

decrypt

Decrypts the encrypted input string with a secret key using AES-256-CBC algorithm. Encrypted input string should be packed in RNCryptor V3 format and base64 encoded. Note: The encryption key should not be hard coded in the recipe. Use account properties (with key or password in the name) to store the encryption keys.

encode_sha256

Encodes a string or binary array using SHA256 algorithm

encode_hex

Converts binary string to its hex representation

decode_hex

Decode hexadecimal into binary string

encode_base64

Encode using Base64 algorithm

decode_base64

Decode using Base64 algorithm

encode_url

URL encode a string

encode_urlsafe_base64

Encode using urlsafe modification of Base64 algorithm

decode_urlsafe_base64

Decode using urlsafe modification of Base64 algorithm

as_string

Decode byte sequence as string in given encoding

as_utf8

Decode byte sequence as UTF-8 string

to_hex

Converts binary string to its hex representation

SHA1

Encrypts a given string using the SHA1 encryption algorithm. Details here.

HMAC formulae

Creates a HMAC signatures with a variety of signing algorithms

md5_hexdigest

Accepts a string and creates message digest using the MD5 Message-Digest Algorithm

jwt_encode_rs256

Creates JWT with RS256 - RSA using SHA-256 hash algorithm

parse_yaml

Parse a YAML string. Supports true, false, nil, numbers, strings, arrays, hashes

render_yaml

Render an object into a YAML string.

lookup

This formula looks up values in your AppConnect lookup tables by key. It is case sensitive and data type sensitive. If you use a data pill in the lookup formula, it is recommended that the data is converted to the right format. For example, integer-type data pills should be converted to string with a .to_s formula if comparing to a column containing both integers and strings.

lookup_table

This formula creates a static lookup table with the keys and values you define. It is case sensitive and data type sensitive.

Complex data types

Mapping complex data in formula mode

Benefits Deal with primitive arrays You may not have prior knowledge of schema Too many fields in a single object to map

Example

This example applies tags to Zendesk tickets for associated Escalations, tracked in Insightly as a custom object. It uses a custom action. According to Zendesk API documentation, tags should be sent as an array of strings. The payload should look like this: That is a problem, because AppConnect input field mapping exists primarily as key/value pairs. This required format is a primitive array of strings. This requires a complex data type (Array of Strings).