Skip to Content

Functions

Overview

Functions are available to use in scripts to enhance and refine data processes. Functions can be used with any script type using either Jitterbit Script or JavaScript.

Within the script editor, to show a list of available functions for the selected language, open the Functions tab of the script component palette:

tab functions

To search for a particular function by name, use the search box to enter a keyword or multiple keywords separated by commas. Functions that have any part of any of the keywords in the function name are returned:

functions search

To browse functions by category, click the disclosure triangles right arrow 3 right arrow 3 to expand or collapse the functions under each category. Different categories are available depending on the language.

To reference a quick overview for the function, click the function name in the list to expand details including syntax, what the function is used for, and examples of how to use the function. To collapse the reference information, again click the function name.

functions docs

Function Categories

Functions are documented by category on these pages:

Functions Index

These indexes link to the specific documentation for each of the Jitterbit Script and Jitterbit JavaScript functions available in Harmony.

Jitterbit Script Functions

Note

  • Single Agent Only: Functions marked as Single Agent only are to be used only with a single Private Agent, as they do not work when using Cloud Agents or multiple Private Agents.
  • Deprecated: Functions marked as Deprecated should no longer be used, as they may be removed in a future version of Harmony.
Function Jitterbit Script Function Category Single Agent Only Deprecated
<SEQUENCE> Database
<SQLIDENTITY> Database
<UDF> Database
AddToDict Dictionary and Array
AESDecryption Cryptography
AESEncryption Cryptography
ArchiveFile File
ArgumentList General
Array Dictionary and Array
ArrayToMultipleValues LDAP
Attribute XML
AutoNumber General Deprecated
Base64Decode Cryptography
Base64Encode Cryptography
Base64EncodeFile Cryptography
BinaryToHex Conversion
BinaryToUUID Conversion
Bool Conversion
CacheLookup Database
CallStoredProcedure Database
CancelOperation General
CancelOperationChain General
Case Logical
Ceiling Math
Collection Dictionary and Array
CollectValues Dictionary and Array
ConvertTimeZone Date and Time
Count Instance
CountSourceRecords Instance
CountSubString String
CreateNode XML
CVTDate Date and Time
Date Conversion
DateAdd Date and Time
DayOfMonth Date and Time
DayOfWeek Date and Time
DBCloseConnection Database
DBExecute Database
DBLoad Database
DBLookup Database
DBLookupAll Database
DBRollbackTransaction Database
DBWrite Database
DebugBreak Debugging
DeleteFile File
DeleteFiles File
Dict Dictionary and Array
DiffAdd Diff
DiffComplete Diff
DiffDelete Diff
DiffKeyList Diff
DiffNode Diff
DiffUpdate Diff
DirList File
Double Conversion
DQuote String
Equal Logical
Eval General
Exist Instance
Exp Math
FileList File
FindByPos Instance
FindValue Instance
Float Conversion
Floor Math
FlushAllFiles File
FlushFile File
Format String
FormatDate Date and Time
GeneralDate Date and Time
Get General
GetAgentGroupID Environment Information
GetAgentGroupName Environment Information
GetAgentID Environment Information
GetAgentName Environment Information
GetAgentVersionID Environment Information
GetAgentVersionName Environment Information
GetChunkDataElement General
GetEnvironmentID Environment Information
GetEnvironmentName Environment Information
GetHostByIP General
GetInputString General
GetInstance Instance
GetKeys Dictionary and Array
GetLastError Logging and Error
GetLastOperationRunStartTime General Single Agent only
GetName General
GetNodeName XML
GetNodeValue XML
GetOperationQueue General Single Agent only
GetOrganizationID Environment Information
GetOrganizationName Environment Information
GetSalesforceTimestamp Salesforce
GetServerName General
GetSourceAttrNames Dictionary and Array
GetSourceElementNames Dictionary and Array
GetSourceInstanceArray Dictionary and Array
GetSourceInstanceElementArray Dictionary and Array
GetSourceInstanceElementMap Dictionary and Array
GetSourceInstanceMap Dictionary and Array
GetUTCFormattedDate Date and Time
GetUTCFormattedDateTime Date and Time
GetXMLString XML
GUID General
HasKey Dictionary and Array
HexToBinary Conversion
HexToString Conversion
If Logical
IfEmpty General
IfNull General
Index String
InitCounter General Single Agent only
InitializeDiff Diff
InList General
Int Conversion
IsInteger General
IsNil XML
IsNull General
IsValid General
IsValidString String
LastDayOfMonth Date and Time
LDAPAdd LDAP
LDAPConnect LDAP
LDAPDeleteEntry LDAP
LDAPExecute LDAP
LDAPRemove LDAP
LDAPRename LDAP
LDAPReplace LDAP
LDAPSearch LDAP
Left String
Length General
Log Math
Log10 Math
LoginToSalesforceAndGetTimeStamp
Salesforce
Long Conversion
LongDate Date and Time
LongTime Date and Time
LPad String
LPadChar String
LTrim String
LTrimChars String
Map Dictionary and Array
MapCache Dictionary and Array
Max Instance
MD5 Cryptography
MD5AsTwoNumbers Cryptography
MediumDate Date and Time
MediumTime Date and Time
Mid String
Min Instance
Mod Math
MonthOfYear Date and Time
NetSuiteGetSelectValue Connector
NetSuiteGetServerTime Connector
NetSuiteLogin Connector
Now_ Date and Time
Now Date and Time
Null General
OrderedDiffKeyList Diff
ParseURL String
Pow Math
Quote String
RaiseError Logging and Error
Random General
RandomString General
ReadArrayString General
ReadCache Cache
ReadFile File
RecordCount General Deprecated
ReduceDimension Dictionary and Array
RegExMatch String
RegExReplace String
RemoveKey Dictionary and Array
Replace String
ReRunOperation General
ResetDiff Diff
ResetLastError Logging and Error
ResolveOneOf Instance
Right String
Round Math
RoundToInt Math
RPad String
RPadChar String
RTrim String
RTrimChars String
RunOperation General
RunPlugin General
RunScript General
RunXSLT XML
SalesforceLogin Salesforce
SelectNodeFromXMLAny XML
SelectNodes XML
SelectNodesFromXMLAny XML
SelectSingleNode XML
SendEmail Email
SendEmailMessage Email
SendSystemEmail Email
Set General
SetChunkDataElement
General
SetDBInsert Database
SetDBUpdate Database
SetDiffChunkSize Diff
SetInstances Instance
SetLastError Logging and Error
SetSalesforceSession Salesforce
SfCacheLookup Salesforce
SfLookup Salesforce
SfLookupAll Salesforce
SfLookupAllToFile Salesforce
SHA256 Cryptography
ShortDate Date and Time
ShortTime Date and Time
Sleep General
SortArray Dictionary and Array
SortInstances Instance
SourceInstanceCount General
Split String
SplitCSV String
SQLEscape Database
Sqrt Math
String Conversion
StringLength String
StringToHex Conversion
Sum Instance
SumCSV Instance
SumString Instance
TargetInstanceCount General
ToLower String
ToProper String
ToUpper String
Trim String
TrimChars String
Truncate String
Unmap Database
URLDecode String
URLEncode String
UUIDToBinary Conversion
Validate Text Validation
WaitForOperation General
While Logical
WriteCache Cache
WriteFile File
WriteToOperationLog Logging and Error

JavaScript Functions

Note

  • Single Agent Only: Functions marked as Single Agent only are to be used only with a single Private Agent, as they do not work when using Cloud Agents or multiple Private Agents.
  • Deprecated: Functions marked as Deprecated should no longer be used, as they may be removed in a future version of Harmony.