ETL: Expressions & Functions

Write expressions and use 180+ built-in functions in Integrate.io ETL for string manipulation, date handling, math, JSON/XML processing, and encryption.

Expressions let you transform individual fields within your ETL components. Integrate.io provides 180+ built-in functions covering string operations (CONCAT, REPLACE, REGEX), date arithmetic (DaysBetween, ParseDate), math (ABS, ROUND, POW), JSON and XML processing, geolocation from IP, HTTP calls (Curl, CCurl), encryption (SHA256, AES), and more. The guides below cover expression syntax, variables, and the full function reference.

Functions Reference

Using Expressions

Using and Setting Variables

Global Variables

System and Pre-Defined Variables

ISO 8601 String Functions

Encrypting and Decrypting Data

Processing JSON Data

Processing XML Data

Processing Different Encodings

Working with Datetime Data

ABS

ACOS

AddDuration

ASIN

ATAN

BagToString

BagToTuple

Base64Decode

Base64DecodeToString

Base64Encode

Base64EncodeToString

BinaryCCurl

BinaryCurl

BrowserFamily

BrowserFullName

BrowserMajor

BrowserMinor

BrowserPatch

BrowserVersion

ByteArrayToString

CBRT

CCurl

CCurlPoll

CCurlWithPagination

CEIL

CityNameFromIP

ClockTime

COALESCE

CONCAT

ContinentCodeFromIP

ContinentNameFromIP

COS

COSH

CountryCodeFromIP

CountryNameFromIP

CSVSPLIT

Curl

CurlPoll

CCurlWithPagination

CurrentTime

DateDiffDays

DateDiffHours

DateDiffMinutes

DateDiffMonths

DateDiffSeconds

DateDiffYears

DaysBetween

Decrypt

DeviceFamily

DistInMilesHaversine

Encrypt

ExecuteBQInsert

ExecuteSqlBoolean

ExecuteSqlDateTime

ExecuteSqlDouble

ExecuteSqlFloat

ExecuteSqlInt

ExecuteSqlLong

ExecuteSqlNonQuery

ExecuteSqlString

EXP

ExtractQueryStringParam

ExtractSearchQuery

ExtractUABrowserID

ExtractUABrowserName

ExtractUrlPart

Flatten

FLOOR

GetBytes

GetDay

GetHour

GetMilliSecond

GetMinute

GetMonth

GetSecond

GetWeek

GetWeekYear

GetYear

HoursBetween

INDEXOF

INITCAP

IntervalIntersection

IsBase64

IsEmpty

IsISODatetime

ISOAddDuration

ISODatetimeToString

ISODatetimeToTimestampFormat

ISOSubtractDuration

ISOToDay

ISOToHour

ISOToMinute

ISOToMonth

ISOToSecond

ISOToWeek

ISOToYear

JsonExtract

JsonExtractScalar

JsonStringToBag

JsonStringToMap

LAST_INDEX_OF

LatitudeFromIP

LCFIRST

Length

LOG

LOG10

LongitudeFromIP

LOWER

MapToBag

MapToQueryString

MD2

MD5

MilliSecondsBetween

MinutesBetween

MonthsBetween

OsFamily

OsFullName

OsMajor

OsMinor

OsPatch

OsPatchMinor

OsVersion

ParseDate

ParseDoubleOrDefault

ParseFloatOrDefault

ParseIntOrDefault

ParseLongOrDefault

PlatformFamily

POW

QueryStringToMap

RANDOM

REGEX_EXTRACT

REGEX_EXTRACT_ALL

REGEX_FIND_ALL

RegionCodeFromIP

RegionNameFromIP

REPLACE

Reverse

ROUND

ROUND_TO

SecondsBetween

SHA1

SHA256

SHA256WithRSA

SHA384

SHA512

SIN

SINH

SIZE

Sleep

SPRINTF

SQRT

StringToISODatetime

STRSPLIT

STRSPLITTOBAG

SUBSTRING

SubtractDuration

SwitchTimeZone

TAN

TANH

TimestampFormatToISODatetime

TOBAG

ToDate

ToDateCustomFormats

ToHexString

ToJson

TOKENIZE

TOMAP

ToMilliSeconds

ToString

TOTUPLE

ToUnixTime

TRIM

UCFIRST

UPPER

URLDecode

URLEncode

UUID

WeeksBetween

XPath

XPathToBag

YearsBetween