Referencing Functions
You can reference functions to quickly configure connectors when editing and designing a composite application.
Figure 1 describes how to use functions in composite applications.
Category
Math, string, encryption and decryption, date and time, encoding and decoding, and number system conversion.
Category |
Function |
Description |
---|---|---|
Math (2) |
sum(array arr) |
Returns the sum of all numbers in an array. For example, ${sum(3,5,6)} returns 14. |
avg(array arr) |
Returns the average of all numbers in an array. For example, ${avg (2,4)} returns 3. |
|
String (29) |
uuid() |
Generates a random UUID consisting of letters and digits. |
upper(string str) |
Converts a string into uppercase letters. For example, ${upper('abc')} returns ABC. |
|
lower(string str) |
Converts a string into lowercase letters. For example, ${lower('ABC')} returns abc. |
|
camelize(string str) |
Converts words in a string into the camel case format, deletes all spaces, and converts the first letter of each word except the first word into the uppercase format. For example, ${camelize('aaa_bbb_ccc')} returns aaaBbbCcc. |
|
dasherize(string str) |
Converts words in a string into the kebab case format, letters into lowercase letters, and all spaces into hyphens (-). For example, ${dasherize('Aaa Bbb Ccc')} returns aaa-bbb-ccc. |
|
capitalize(string str) |
Converts the first letter of each word into the uppercase format and the other letters into the lowercase format. For example, ${capitalize('aaaBbbCcc')} returns Aaa Bbb Ccc. |
|
charCode(string char) |
Converts characters to character encoding. For example, ${charCode('hello')} returns 104. |
|
fromCharCode(number charCode) |
Converts a character encoding into a string. For example, ${fromCharCode(104)} returns h. |
|
charCodeAt(string str, number index) |
Returns the character encoding at the index in a string. For example, ${charCodeAt('hello', 2)} returns 108. |
|
isAlpha(string str) |
Returns a Boolean value that indicates whether a string contains only English letters. For example, ${isAlpha ('abc') returns true, and ${isAlpha ('a-b-c')} returns false. |
|
isAlphanumeric(string str) |
Returns a Boolean value that indicates whether a string contains only English letters or digits. For example, ${isAlphanumeric ('aBc123')} returns true, and ${isAlphanumeric ('aBc-123')} returns false. |
|
isNumeric(string str) |
Returns a Boolean value that indicates whether a string contains only digits. For example, ${isNumeric ('123')} returns true, and ${isNumeric ('1-2-3')} returns false. |
|
isLowerCase(string str) |
Returns a Boolean value that indicates whether a string contains only lowercase letters. For example, ${isLowerCase('abc')} returns true, and ${isLowerCase('aBc')} returns false. |
|
isUpperCase(string str) |
Returns a Boolean value that indicates whether a string contains only uppercase letters. For example, ${isUpperCase('ABC')} returns true, and ${isUpperCase('AbC')} returns false. |
|
isWhitespace(string str) |
Returns a Boolean value that indicates whether a string contains only spaces. For example, ${isWhitespace(' ')} returns true, and ${isWhitespace('a b c')} returns false. |
|
leftPad(string str, number offset) |
If the string is shorter than the offset, pads the left side of the string with spaces. For example, ${leftPad('abc', 4)} returns " abc". |
|
rightPad(string str, number offset) |
If the string is shorter than the offset, pads the right side of the string with spaces. For example, ${rightPad('abc', 4)} returns "abc ". |
|
substringAfter(string str, string separator) |
Gets the substring after the first separator. For example, ${substringAfter('a,b,c,d', ',')} returns b,c,d. |
|
substringAfterLast(string str, string separator) |
Gets the substring after the last separator. For example, ${substringAfterLast('a,b,c,d', ',')} returns d. |
|
substringBefore(string str, string separator) |
Gets the substring before the first separator. For example, ${substringBefore('a,b,c,d', ',')} returns a. |
|
substringBeforeLast(string str, string separator) |
Gets the substring before the last separator. For example, ${substringBeforeLast('a,b,c,d', ',')} returns a,b,c. |
|
unwrap(string str, string wrapper) |
Returns a string without the wrapper text. The wrapper text is the value before and/or after a string. For example, ${unwrap("/test/", "/")} returns test. |
|
withMaxSize(string str, number size) |
Limits the size of a string. For example, ${withMaxSize('abcd', 3)} returns abc. |
|
wrapIfMissing(string str, string wrapper) |
If a string is not wrapped, adds the wrapper at the beginning or end. If the wrapper already exists at the beginning or end, updates only the missing end. For example, ${wrapIfMissing("/test", "/")} returns /test/. |
|
wrapWith(string str, string wrapper) |
Adds the wrapper at the beginning or end of a string. For example, ${wrapWith("test", "/")} returns /test/. |
|
ordinalize(number num) |
Converts num to an ordered character string, for example, 1st, 2nd, or 3rd. For example, ${ordinalize(3)} returns 3rd. |
|
appendIfMissing(string str, string value) |
If a string does not end with the value, adds it there. For example, ${appendIfMissing('ab', 'cd')} returns abcd. |
|
prependIfMissing(string str, string value) |
If a string does not start with the value, adds it there. For example, ${prependIfMissing('cd', 'ab')} returns abcd. |
|
repeat(string str, number times) |
Repeats the given number of times. For example, ${repeat('abc', 3)} returns abcabcabc. |
|
Encryption and decryption (4) |
hash(string value, string algorithm) |
Calculates the hash value using a supported algorithm. The algorithm must be MD2, MD5, SHA-1, SHA-256, SHA-384 or SHA-512. For example, ${hash('abcd', 'MD5')} returns e2fc714c4727ee9395f324cd2e7f331f. |
hmac(string value, string secret, string algorithm) |
Generates a hash-based authentication code using the provided value, key, and hash function algorithm. The algorithm must be HMACSHA1, HMACSHA256, or HMACSHA512. For example, ${hmac('abcd', 'test', 'HmacSHA1')} returns bcde772eafae465fe002b2bbb5c68d66da0d241a. |
|
encrypt(string value, string secret, string transformation) |
Encrypts the value using the specified JDK and key, and converts the encryption into a readable format using Base64. For example, ${encrypt('Hello', '8byteKey', 'DES/CBC/PKCS5Padding')} returns Ic3THvsowTV3itOf40K56w==. |
|
decrypt(string value, string secret, string algorithm, string mode, string padding) |
Decrypts the Base64 value using the specified JDK and key. For example, ${decrypt("Ic3THvsowTV3itOf40K56w==", "8byteKey", "DES/CBC/PKCS5Padding")} returns Hello. |
|
Date and time (20) |
now() |
Returns the current date and time. For example, ${now()} returns 2025-03-26T03:17:37. |
compare(string datetime1, string datetime2) |
If datetime1 > datetime2, returns 1; if datetime1 < datetime2, returns -1; if datetime1 == datetime2, returns 0. For example, ${compare('2025-03-26T05:20:30Z', '2025-03-27T05:20:30Z')} returns -1. |
|
atBeginningOfDay(string datetime) |
Returns the midnight time value of a given time. For example, ${atBeginningOfDay('2025-03-26T05:20:30Z')} returns 2025-03-26T00:00:00Z. |
|
atBeginningOfHour(string datetime) |
Returns the given date and time, with minute and second as 0. For example, ${atBeginningOfHour('2025-03-26T05:20:30Z')} returns 2025-03-26T05:00:00Z. |
|
atBeginningOfMonth(string datetime) |
Returns the first day of the month, with time as midnight. For example, ${atBeginningOfMonth('2025-03-26T05:20:30Z')} returns 2025-03-01T00:00:00Z. |
|
atBeginningOfWeek(string datetime) |
Returns the first day of the current week, with time as midnight. For example, ${atBeginningOfWeek('2025-03-26T05:20:30Z')} returns 2025-03-23T00:00:00Z. |
|
atBeginningOfYear(string datetime) |
Returns the first day of the year, with time as midnight. For example, ${atBeginningOfYear('2025-03-26T05:20:30Z')} returns 2025-01-01T00:00:00Z. |
|
changeTimeZone(string datetime, string timezone) |
Changes the time zone, which usually results in a change in the local date and time. For example, ${changeTimeZone('2024-05-22T08:25:16Z', 'UTC')} returns 2024-05-22T08:25:16Z. |
|
daysBetween(string datetime1, string datetime2) |
Returns the number of days between datetime1 and datetime2. For example, ${daysBetween('2024-05-22T08:25:16Z', '2024-05-28T18:25:16Z')} returns 6. |
|
format(string datetime, string outputFormat) |
Converts a given datetime into the specified format. For example, ${format('2024-05-22T08:25:16Z', 'yyyy/MM/dd HH:mm')} returns 2024/05/22 08:25. |
|
isLeapYear(string datetime) |
Returns a Boolean value indicating whether datetime is a leap year. For example, ${isLeapYear('2024-05-22T08:25:16Z')} returns true. |
|
plus(string datetime, string period) |
Adds a date to a datetime. For example, ${plus('2024-05-22T08:25:16Z', 'P1D')} returns 2024-05-23T08:25:16Z. |
|
minus(string datetime, string period) |
Subtracts a date to a datetime. For example, ${minus('2024-05-22T08:25:16Z', 'P1D')} returns 2024-05-21T08:25:16Z. |
|
parse(string|number datetime, string inputFormat) |
Parses the datetime using the input format and returns a value in the default format. If the epoch or timestamp value is used as the datetime, epoch or timestamp can be used as inputFormat. For example, ${parse('12/31/1990 10:10:10', 'MM/dd/yyyy HH:mm:ss')} returns 1990-12-31T10:10:10Z. |
|
toLocalDate(string datetime) |
Localizes a date. For example, ${toLocalDate('2024-05-22T08:25:16Z')} returns 2024-05-22. |
|
toLocalDateTime(string datetime) |
Localizes a date and time. For example, ${toLocalDateTime('2024-05-22T08:25:16Z')} returns 2024-05-22T08:25:16. |
|
toLocalTime(string datetime, string format) |
Localizes a time. For example, ${toLocalTime('2024-05-22T08:25:16Z')} returns 08:25:16. |
|
today() |
Returns the midnight time of the current day. |
|
tomorrow() |
Returns the midnight time of the next day. |
|
yesterday() |
Returns the midnight time of the previous day. |
|
Encoding and decoding (2) |
encode(string data, string encoding="UTF-8") |
Converts a string to the application/x-www-form-urlencoded format using the provided encoding scheme to obtain insecure bytes. The default encoding is UTF-8. For example, ${encode('Hello, world', encoding="UTF-8")} returns Hello%EF%BC%8C%E4%B8%96%E7%95%8C. |
decode(string data, string encoding="UTF-8") |
Decodes the application/x-www-form-urlencoded string using a specific encoding scheme to determine which characters are represented by a continuous sequence in the form of %xy. For example, ${decode('Hello%EF%BC%8C%E4%B8%96%E7%95%8C', encoding="UTF-8")} returns Hello, world. |
|
Number system conversion (9) |
fromBase64(string value) |
Converts a Base64 code to a value. For example, ${fromBase64('SGVsbG8=')} returns Hello. |
toBase64(any value) |
Base64-encodes a value. Currently, arrays and payload keywords in the ${083xxx|param} format are not supported. Arrays should be enclosed in single quotation marks ('), as shown in the following figure. For example, ${toBase64('Hello')} returns SGVsbG8=. |
|
fromHex(string value) |
Converts a hexadecimal number to a value. For example, ${fromHex(13)} returns 19. |
|
toHex(any value) |
Converts a value to a hexadecimal number. For example, ${toHex(19)} returns 13. |
|
fromBinary(number value) |
Converts a value from binary to decimal. For example, ${fromBinary(101)} returns 5. |
|
fromHex(number value) |
Converts a value from hexadecimal to decimal. For example, ${fromHex(13)} returns 19. |
|
fromRadixNumber(number value, number baseAsBinary) |
Converts a value to a decimal number. For example, ${fromRadixNumber(101, 2)} returns 5. |
|
toBinary(number value) |
Converts a value from decimal to binary. For example, ${toBinary(8)} returns 1000. |
|
toRadixNumber(number value, number baseAsDecimal) |
Converts a value to a specified number system. For example, ${toRadixNumber(5, 2)} returns 101. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot