FunctionDescriptionExampleComments
base64_decodeDecodes a base64(RFC 4648) encoded stringInput: {"encoded": "SGVsbG8gV29ybGQh"}
Expression: base64_decode(encoded)
Output: Hello World!
capitalizeCapitalizes all the words in the stringInput: {"name": "john doe"}
Expression: capitalize(name)
Output: John Doe
concatConcatenates an array of variables or literalsInput: {"fname": "john", "lname": "doe"}
Expression: concat([fname, ' ' ,lname])
Output: john doe		This is equivalent to the more verbose built-in expression: ' '.join([fname,lname])
filter_entriesFilters entries in a dictionary (object) using the given JMESPath predicateInput: { "name": "John", "age": 30, "country": "US", "score": 15}
Expression: filter_entries(@, `key == 'name' || key == 'age'`)
Output:{"name": "John", "age": 30 }
from_entriesConverts an array of objects with key and value properties into a single objectInput: [{"key": "name", "value": "John"}, {"key": "age", "value": 30}, {"key": "city", "value": null}]
Expression: from_entries(@)
Output: {"name": "John", "age": 30, "city": null}
hashCalculates a hash using the hash_name hash function and returns its hexadecimal representationInput: {"some_str": "some_value"}
Expression: hash(some_str, `sha1`)
Output: 8c818171573b03feeae08b0b4ffeb6999e3afc05		Supported algorithms: sha1 (default), sha256, md5, sha384, sha3_384, blake2b, sha512, sha3_224, sha224, sha3_256, sha3_512, blake2s
inChecks if an element matches any value in a list of valuesInput: {"el": "b"}
Expression: in(el, [“a”, “b”, “c”])
Output: True
leftReturns a specified number of characters from the start of a given text stringInput: {"greeting": "hello world!"}
Expression: left(greeting, 5)
Output: hello
lowerConverts all uppercase characters in a string into lowercase charactersInput: {"fname": "John"}
Expression: lower(fname)
Output: john
midReturns a specified number of characters from the middle of a given text stringInput: {"greeting": "hello world!"}
Expression: mid(greeting, 4, 3)
Output: o w
json_parseReturns parsed object from the given json stringInput: {"data": '{"greeting": "hello world!"}'}
Expression: parse_json(data)
Output: {"greeting": "hello world!"}
regex_replaceReplaces a string that matches a regular expressionInput: {"text": "Banana Bannnana"}
Expression: regex_replace(text, 'Ban\w+', 'Apple Apple')
Output: Apple Apple
replaceReplaces all the occurrences of a substring with a new oneInput: {"sentence": "one four three four!"}
Expression: replace(sentence, 'four', 'two')
Output: one two three two!
rightReturns a specified number of characters from the end of a given text stringInput: {"greeting": "hello world!"}
Expression: right(greeting, 6)
Output: world!
splitSplits a string into a list of strings after breaking the given string by the specified delimiter (comma by default)Input: {"departments": "finance,hr,r&d"}
Expression: split(departments)
Output: ['finance', 'hr', 'r&d']		Default delimiter is comma - a different delimiter can be passed to the function as the second argument, for example: split(departments, ';')
time_delta_daysReturns the number of days between a given dt and now (positive) or the number of days that have passed from now (negative)Input: {"dt": '2021-10-06T18:56:16.701670+00:00'}
Expression: time_delta_days(dt)
Output: 365		If dt is a string, ISO datetime (2011-11-04T00:05:23+04:00, for example) is assumed. If dt is a number, Unix timestamp (1320365123, for example) is assumed.
time_delta_secondsReturns the number of seconds between a given dt and now (positive) or the number of seconds that have passed from now (negative)Input: {"dt": '2021-10-06T18:56:16.701670+00:00'}
Expression: time_delta_days(dt)
Output: 31557600		If dt is a string, ISO datetime (2011-11-04T00:05:23+04:00, for example) is assumed. If dt is a number, Unix timestamp (1320365123, for example) is assumed.
to_entriesConverts a given object into an array of objects with key and value propertiesInput: {"name": "John", "age": 30, "city": null}
Expression: to_entries(@)
Output: [{"key": "name", "value": "John"}, {"key": "age", "value": 30}, {"key": "city", "value": null}]
upperConverts all lowercase characters in a string into uppercase charactersInput: {"fname": "john"}
Expression: upper(fname)
Output: JOHN
uuidGenerates a random UUID4 and returns it as a string in standard formatInput: None
Expression: uuid()
Output: 3264b35c-ff5d-44a8-8bc7-9be409dac2b7