Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Introduction

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

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

  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

GetLastError

Logging and Error

169

RaiseError

Logging and Error

170

ResetLastError

Logging and Error

171

SetLastError

Logging and Error

172

WriteToOperationLog

Logging and Error

173

Case

Logical

174

Equal

Logical

175

If

Logical

176 While Logical

177

Ceiling

Math

178

Exp

Math

179

Floor

Math

180

Log

Math

181

Log10

Math

182

Mod

Math

183

Pow

Math

184

Round

Math

185

RoundToInt

Math

186

Sqrt

Math

187 FromDataLoaderDate Salesforce
Deprecated
188 FromDataLoaderDateTime Salesforce
Deprecated
189

GetSalesforceTimestamp

Salesforce

190

LoginToSalesforceAndGetTimeStamp

Salesforce

191

SalesforceLogin

Salesforce

192

SetSalesforceSession

Salesforce

193

SfCacheLookup

Salesforce

194

SfLookup

Salesforce

195

SfLookupAll

Salesforce

196

SfLookupAllToFile

Salesforce

197

CountSubString

String

198

DQuote

String

199

Format

String

200 Index String

201 IsValidString String

202 Left String

203 LPad String

204 LPadChar String

205 LTrim String

206 LTrimChars String

207 Mid String

208 ParseURL String

209 Quote String

210 RegExMatch String

211 RegExReplace String

212 Replace String

213 Right String

214 RPad String

215 RPadChar String

216 RTrim String

217 RTrimChars String

218 Split String

219 SplitCSV String

220 StringLength String

221 ToLower String

222 ToProper String

223 ToUpper String

224 Trim String

225 TrimChars String

226 Truncate String

227 URLDecode String

228 URLEncode String

229 Validate Text Validation

230

Attribute

XML

231

CreateNode

XML

232

GetNodeName

XML

233

GetNodeValue

XML

234

GetXMLString

XML

235

IsNil

XML

236

RunXSLT

XML

237

SelectNodeFromXMLAny

XML

238

SelectNodes

XML

239

SelectNodesFromXMLAny

XML

240 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 Harmony.

On This Page

Search in This Topic

Last updated:  Apr 19, 2019

  • No labels