Knowledge Refresh: Functions

Knowledge Refresh 5 of 5

A list of some of the powerful functions available for data manipulation:

• ACCESS_LIST_ITEM()
• ADD()
• AGG_BY_KEY()
• APPEND()
• ARRAY_DIFF()
• BASE64_DECODE()
• BASE64_ENCODE()
• CAPITALIZE()
• COMPRESS()
• DATE()
• DATETIME_NOW()
• DATETIME_TO_EPOCH()
• DATETIME_TO_MS()
• DECOMPRESS()
• DEDUP_ARRAY()
• DEDUP_BY_KEY()
• DEDUP_OBJECTS()
• DEFAULT()
• DELTA_NOW()
• DELTA_SECONDS_NOW()
• DELTA()
• DIV()
• EPOCH_TO_DATETIME()
• EXTRACT_ANY_HASH()
• EXTRACT_DOMAINS()
• EXTRACT_EMAIL()
• EXTRACT_EMAILS()
• EXTRACT_EXTERNAL_IPS()
• EXTRACT_IPS()
• EXTRACT_LINKS()
• EXTRACT_MD5()
• EXTRACT_SHA1()
• EXTRACT_SHA256()
• EXTRACT_URLS()
• EXTRACT_VALUE_BY_KEY()
• FILTER_ARRAY()
• FILTER_OBJECTS()
• FLATTEN_ARRAY()
• FLOAT_TO_INT()
• FLOAT()
• FORMATTED_DATE()
• GENERATE_UUID4()
• GET_EXECUTION_ID()
• GET_GLOBAL_VAR()
• GET_LOCAL_VAR()
• GET_WORKFLOW_DESC...
• GET_WORKFLOW_ID()
• GET_WORKFLOW_NAME()
• GET_WORKFLOW_VER...
• HMAC_SHA1_VALIDATE()
• HMAC_SHA1()
• HMAC_SHA256_VALIDATE()
• HMAC_SHA256()
• HTML_DECODE()
• HTML_ENCODE()
• INCLUDE()
• INDEX_OF()
• INT_TO_FLOAT()
• INT()
• INTERSECTION()
• IS_BLANK()
• IS_EMPTY()
• ISIN()
• JQ()
• JWT_DECODE()
• JWT_ENCODE()
• JWT_VERIFY()
• LAST_INDEX_OF()
• LENGTH()
• LOWER()
• LSTRIP()
• MAP_TABLE()
• MATCH_REGEX()
• MD5()
• MS_TO_DATETIME()
• MUL()
• NEWLINE_TO_BR()
• PARSE_JSON()
• PARSE_LIST()
• PREPEND()
• PRETTY_PRINT()
• RANDOM_STRING()
• REGEX_EXTRACT()
• REMOVE_FIRST_TEXT()
• REMOVE_TEXT()
• REPLACE_FIRST()
• REPLACE()
• RSTRIP()
• SHA1()
• SHA256()
• SHA512()
• SPLIT()
• STRING()
• STRIP_HTML_TAGS()
• STRIP_NEWLINES()
• SUBTRACT()
• TITLE()
• TO_SNAKE_CASE()
• TRUNCATE_WORDS()
• UNION()
• UNIQUE_BY_KEY()
• UPPER()
• URL_DECODE()
• URL_ENCODE()
• WORKFLOW_LINK()