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 4 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

RunPlugin

General

146

RunScript

General

147

Set

General

148

SetChunkDataElement

General

149

Sleep

General

150

SourceInstanceCount

General

151

TargetInstanceCount

General

152

WaitForOperation

General

153

Count

Instance

154

CountSourceRecords

Instance

155

Exist

Instance

156

FindByPos

Instance

157

FindValue

Instance

158

GetInstance

Instance

159

Max

Instance

160

Min

Instance

161

ResolveOneOf

Instance

162

SetInstances

Instance

163

SortInstances

Instance

164

Sum

Instance

165

SumCSV

Instance

166 SumString Instance

167

GetLastError

Logging and Error

168

RaiseError

Logging and Error

169

ResetLastError

Logging and Error

170

SetLastError

Logging and Error

171

WriteToOperationLog

Logging and Error

172

Case

Logical

173

Equal

Logical

174

If

Logical

175 While Logical

176

Ceiling

Math

177

Exp

Math

178

Floor

Math

179

Log

Math

180

Log10

Math

181

Mod

Math

182

Pow

Math

183

Round

Math

184

RoundToInt

Math

185

Sqrt

Math

186 FromDataLoaderDate Salesforce
Deprecated
187 FromDataLoaderDateTime Salesforce
Deprecated
188

GetSalesforceTimestamp

Salesforce

189

LoginToSalesforceAndGetTimeStamp

Salesforce

190

SalesforceLogin

Salesforce

191

SetSalesforceSession

Salesforce

192

SfCacheLookup

Salesforce

193

SfLookup

Salesforce

194

SfLookupAll

Salesforce

195

SfLookupAllToFile

Salesforce

196

CountSubString

String

197

DQuote

String

198

Format

String

199 Index String

200 IsValidString String

201 Left String

202 LPad String

203 LPadChar String

204 LTrim String

205 LTrimChars String

206 Mid String

207 ParseURL String

208 Quote String

209 RegExMatch String

210 RegExReplace String

211 Replace String

212 Right String

213 RPad String

214 RPadChar String

215 RTrim String

216 RTrimChars String

217 Split String

218 SplitCSV String

219 StringLength String

220 ToLower String

221 ToProper String

222 ToUpper String

223 Trim String

224 TrimChars String

225 Truncate String

226 URLDecode String

227 URLEncode String

228 Validate Text Validation

229

Attribute

XML

230

CreateNode

XML

231

GetNodeName

XML

232

GetNodeValue

XML

233

GetXMLString

XML

234

IsNil

XML

235

SelectNodeFromXMLAny

XML

236

SelectNodes

XML

237

SelectNodesFromXMLAny

XML

238 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:  Jul 23, 2019

  • No labels