Skip to Content

Functions Index

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

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 Jitterbit.
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
FromDataLoaderDate Salesforce Deprecated
FromDataLoaderDateTime Salesforce Deprecated
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
PLM360GetItemVersionId Connector
PLM360Login Connector
PLM360Logout Connector
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
RunOperationFromProject 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

[Back to Top]

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 Jitterbit.
Function JavaScript Function Category Single Agent Only Deprecated
Array JavaScript Array properties and functions
Date JavaScript Date properties and functions
decodeURI Common
decodeURIComponent Common
encodeURI Common
encodeURIComponent Common
eval Common
isFinite Common
isNaN Common
Jitterbit.DbExecute Jitterbit
Jitterbit.DbLookup Jitterbit
Jitterbit.GetVar Jitterbit
Jitterbit.ReadFile Jitterbit
Jitterbit.SetVar Jitterbit
Jitterbit.WriteFile Jitterbit
JSON.parse Common
JSON.stringify Common
Math JavaScript Math properties and functions
Number Common
parseFloat Common
parseInt Common
SetScriptOutput Jitterbit
SetScriptResult Jitterbit
String JavaScript String properties and functions
WriteToOperationLog Jitterbit

[Back to Top]