Skip to end of metadata
Go to start of metadata

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

Jitterbit Script Functions

NOTES

  • 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
1

ReadCache

Cache



2

WriteCache

Cache



3

NetSuiteGetSelectValue

Connector

4

NetSuiteGetServerTime

Connector

5

NetSuiteLogin

Connector

6

PLM360GetItemVersionId

Connector

7

PLM360Login

Connector

8

PLM360Logout

Connector

9

BinaryToHex

Conversion

10

BinaryToUUID

Conversion

11

Bool

Conversion

12

Date

Conversion

13

Double

Conversion

14

Float

Conversion

15

HexToBinary

Conversion

16

HexToString

Conversion

17

Int

Conversion

18 Long Conversion

19

String

Conversion

20

StringToHex

Conversion

21

UUIDToBinary

Conversion

22

AESDecryption

Cryptography

23

AESEncryption

Cryptography

24

Base64Decode

Cryptography

25

Base64Encode

Cryptography

26

Base64EncodeFile

Cryptography

27

MD5

Cryptography

28

MD5AsTwoNumbers

Cryptography

29

SHA256

Cryptography

30

CacheLookup

Database

31

CallStoredProcedure

Database

32

DBCloseConnection

Database

33

DBExecute

Database

34

DBLoad

Database

35

DBLookup

Database

36

DBLookupAll

Database

37

DBRollbackTransaction

Database

38

DBWrite

Database

39

SetDBInsert

Database

40

SetDBUpdate

Database

41

SQLEscape

Database

42

Unmap

Database

43

<SEQUENCE>

Database

44

<SQLIDENTITY>

Database

45 <UDF> Database

46

ConvertTimeZone

Date and Time

47 CVTDate Date and Time

48

DateAdd

Date and Time

49

DayOfMonth

Date and Time

50

DayOfWeek

Date and Time

51

FormatDate

Date and Time

52

GeneralDate

Date and Time

53

GetUTCFormattedDate

Date and Time

54

GetUTCFormattedDateTime

Date and Time

55

LastDayOfMonth

Date and Time

56

LongDate

Date and Time

57

LongTime

Date and Time

58

MediumDate

Date and Time

59

MediumTime

Date and Time

60

MonthOfYear

Date and Time

61

Now

Date and Time

62

Now_

Date and Time

63

ShortDate

Date and Time

64 ShortTime Date and Time

65

DebugBreak

Debugging

66

AddToDict

Dictionary and Array

67

Array

Dictionary and Array

68

Collection

Dictionary and Array

69

CollectValues

Dictionary and Array

70

Dict

Dictionary and Array

71

GetKeys

Dictionary and Array

72

GetSourceAttrNames

Dictionary and Array

73

GetSourceElementNames

Dictionary and Array

74

GetSourceInstanceArray

Dictionary and Array

75

GetSourceInstanceElementArray

Dictionary and Array

76

GetSourceInstanceElementMap

Dictionary and Array

77

GetSourceInstanceMap

Dictionary and Array

78

HasKey

Dictionary and Array

79

Map

Dictionary and Array

80

MapCache

Dictionary and Array

81

ReduceDimension

Dictionary and Array

82

RemoveKey

Dictionary and Array

83

SortArray

Dictionary and Array

84

DiffAdd

Diff

85

DiffComplete

Diff

86

DiffDelete

Diff

87

DiffKeyList

Diff

88

DiffNode

Diff

89

DiffUpdate

Diff

90

InitializeDiff

Diff

91

OrderedDiffKeyList

Diff

92

ResetDiff

Diff

93 SetDiffChunkSize Diff

94

SendEmail

Email

95 SendEmailMessage Email

96 SendSystemEmail Email

97

GetAgentGroupID

Environment Information

98

GetAgentGroupName

Environment Information

99

GetAgentID

Environment Information

100

GetAgentName

Environment Information

101

GetAgentVersionID

Environment Information

102

GetAgentVersionName

Environment Information

103

GetEnvironmentID

Environment Information

104

GetEnvironmentName

Environment Information

105

GetOrganizationID

Environment Information

106 GetOrganizationName Environment Information

107

ArchiveFile

File

108

DeleteFile

File

109

DeleteFiles

File

110

DirList

File

111

FileList

File

112

FlushAllFiles

File

113

FlushFile

File

114

ReadFile

File

115 WriteFile File

116

ArgumentList

General

117

AutoNumber

General
Deprecated
118

CancelOperation

General

119 CancelOperationChain General

120 Eval General

121 Get General

122

GetChunkDataElement

General

123

GetHostByIP

General

124

GetInputString

General

125

GetLastOperationRunStartTime

General Single Agent only
126

GetName

General

127

GetOperationQueue

General Single Agent only
128

GetServerName

General

129

GUID

General

130

IfEmpty

General

131

IfNull

General

132

InitCounter

General Single Agent only
133

InList

General

134

IsInteger

General

135

IsNull

General

136

IsValid

General

137

Length

General

138

Null

General

139

Random

General

140

RandomString

General

141

ReadArrayString

General

142

RecordCount

General
Deprecated
143

ReRunOperation

General

144

RunOperation

General

145

RunOperationFromProject

General

146

RunPlugin

General

147

RunScript

General

148

Set

General

149

SetChunkDataElement

General

150

Sleep

General

151

SourceInstanceCount

General

152

TargetInstanceCount

General

153

WaitForOperation

General

154

Count

Instance

155

CountSourceRecords

Instance

156

Exist

Instance

157

FindByPos

Instance

158

FindValue

Instance

159

GetInstance

Instance

160

Max

Instance

161

Min

Instance

162

ResolveOneOf

Instance

163

SetInstances

Instance

164

SortInstances

Instance

165

Sum

Instance

166

SumCSV

Instance

167 SumString Instance

168

ArrayToMultipleValues

LDAP

169

LDAPAdd

LDAP

170 LDAPConnect LDAP

171

LDAPDeleteEntry

LDAP

172

LDAPExecute

LDAP

173

LDAPRemove

LDAP

174

LDAPRename

LDAP

175

LDAPReplace

LDAP

176

LDAPSearch

LDAP

177

GetLastError

Logging and Error

178

RaiseError

Logging and Error

179

ResetLastError

Logging and Error

180

SetLastError

Logging and Error

181

WriteToOperationLog

Logging and Error

182

Case

Logical

183

Equal

Logical

184

If

Logical

185 While Logical

186

Ceiling

Math

187

Exp

Math

188

Floor

Math

189

Log

Math

190

Log10

Math

191

Mod

Math

192

Pow

Math

193

Round

Math

194

RoundToInt

Math

195

Sqrt

Math

196 FromDataLoaderDate Salesforce
Deprecated
197 FromDataLoaderDateTime Salesforce
Deprecated
198

GetSalesforceTimestamp

Salesforce

199

LoginToSalesforceAndGetTimeStamp

Salesforce

200

SalesforceLogin

Salesforce

201

SetSalesforceSession

Salesforce

202

SfCacheLookup

Salesforce

203

SfLookup

Salesforce

204

SfLookupAll

Salesforce

205

SfLookupAllToFile

Salesforce

206

CountSubString

String

207

DQuote

String

208

Format

String

209 Index String

210 IsValidString String

211 Left String

212 LPad String

213 LPadChar String

214 LTrim String

215 LTrimChars String

216 Mid String

217 ParseURL String

218 Quote String

219 RegExMatch String

220 RegExReplace String

221 Replace String

222 Right String

223 RPad String

224 RPadChar String

225 RTrim String

226 RTrimChars String

227 Split String

228 SplitCSV String

229 StringLength String

230 ToLower String

231 ToProper String

232 ToUpper String

233 Trim String

234 TrimChars String

235 Truncate String

236 URLDecode String

237 URLEncode String

238 Validate Text Validation

239

Attribute

XML

240

CreateNode

XML

241

GetNodeName

XML

242

GetNodeValue

XML

243

GetXMLString

XML

244

IsNil

XML

245

RunXSLT

XML

246

SelectNodeFromXMLAny

XML

247

SelectNodes

XML

248

SelectNodesFromXMLAny

XML

249 SelectSingleNode XML

JavaScript Functions

NOTES

  • 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.

Search in This Topic
On This Page

Last updated:  Sep 28, 2018