Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

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

Multiexcerpt
hiddentrue
MultiExcerptNamefunctions-index-notes
Info
titleNOTES
  • 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.

Anchor
jitterbit-script-functions
jitterbit-script-functions
Jitterbit Script Functions

Multiexcerpt include
SpaceWithExcerptCS
MultiExcerptNamefunctions-index-notes
PageWithExcerptFunctions Index

Tableenhancer
sortColumn1
rowNumbersindependentFromSorting
decimalMark. (point)
FunctionJitterbit Script Function CategorySingle Agent OnlyDeprecated

ReadCache

Cache



WriteCache

Cache



NetSuiteGetSelectValue

Connector

NetSuiteGetServerTime

Connector

NetSuiteLogin

Connector

PLM360GetItemVersionId

Connector

PLM360Login

Connector

PLM360Logout

Connector

BinaryToHex

Conversion

BinaryToUUID

Conversion

Bool

Conversion

Date

Conversion

Double

Conversion

Float

Conversion

HexToBinary

Conversion

HexToString

Conversion

Int

Conversion

Long Conversion

String

Conversion

StringToHex

Conversion

UUIDToBinary

Conversion

AESDecryption

Cryptography

AESEncryption

Cryptography

Base64Decode

Cryptography

Base64Encode

Cryptography

Base64EncodeFile

Cryptography

MD5

Cryptography

MD5AsTwoNumbers

Cryptography

SHA256

Cryptography

CacheLookup

Database

CallStoredProcedure

Database

DBCloseConnection

Database

DBExecute

Database

DBLoad

Database

DBLookup

Database

DBLookupAll

Database

DBRollbackTransaction

Database

DBWrite

Database

SetDBInsert

Database

SetDBUpdate

Database

SQLEscape

Database

Unmap

Database

<SEQUENCE>

Database

<SQLIDENTITY>

Database

<UDF> Database

ConvertTimeZone

Date and Time

CVTDate Date and Time

DateAdd

Date and Time

DayOfMonth

Date and Time

DayOfWeek

Date and Time

FormatDate

Date and Time

GeneralDate

Date and Time

GetUTCFormattedDate

Date and Time

GetUTCFormattedDateTime

Date and Time

LastDayOfMonth

Date and Time

LongDate

Date and Time

LongTime

Date and Time

MediumDate

Date and Time

MediumTime

Date and Time

MonthOfYear

Date and Time

Now

Date and Time

Now_

Date and Time

ShortDate

Date and Time

ShortTime Date and Time

DebugBreak

Debugging

AddToDict

Dictionary and Array

Array

Dictionary and Array

Collection

Dictionary and Array

CollectValues

Dictionary and Array

Dict

Dictionary and Array

GetKeys

Dictionary and Array

GetSourceAttrNames

Dictionary and Array

GetSourceElementNames

Dictionary and Array

GetSourceInstanceArray

Dictionary and Array

GetSourceInstanceElementArray

Dictionary and Array

GetSourceInstanceElementMap

Dictionary and Array

GetSourceInstanceMap

Dictionary and Array

HasKey

Dictionary and Array

Map

Dictionary and Array

MapCache

Dictionary and Array

ReduceDimension

Dictionary and Array

RemoveKey

Dictionary and Array

SortArray

Dictionary and Array

DiffAdd

Diff

DiffComplete

Diff

DiffDelete

Diff

DiffKeyList

Diff

DiffNode

Diff

DiffUpdate

Diff

InitializeDiff

Diff

OrderedDiffKeyList

Diff

ResetDiff

Diff

SetDiffChunkSize Diff

SendEmail

Email

SendEmailMessage Email

SendSystemEmail Email

GetAgentGroupID

Environment Information

GetAgentGroupName

Environment Information

GetAgentID

Environment Information

GetAgentName

Environment Information

GetAgentVersionID

Environment Information

GetAgentVersionName

Environment Information

GetEnvironmentID

Environment Information

GetEnvironmentName

Environment Information

GetOrganizationID

Environment Information

GetOrganizationName Environment Information

ArchiveFile

File

DeleteFile

File

DeleteFiles

File

DirList

File

FileList

File

FlushAllFiles

File

FlushFile

File

ReadFile

File

WriteFile File

ArgumentList

General

AutoNumber

General
Deprecated

CancelOperation

General

CancelOperationChain General

Eval General

Get General

GetChunkDataElement

General

GetHostByIP

General

GetInputString

General

GetLastOperationRunStartTime

GeneralSingle Agent only

GetName

General

GetOperationQueue

GeneralSingle Agent only

GetServerName

General

GUID

General

IfEmpty

General

IfNull

General

InitCounter

GeneralSingle Agent only

InList

General

IsInteger

General

IsNull

General

IsValid

General

Length

General

Null

General

Random

General

RandomString

General

ReadArrayString

General

RecordCount

General
Deprecated

ReRunOperation

General

RunOperation

General

RunPlugin

General

RunScript

General

Set

General

SetChunkDataElement

General

Sleep

General

SourceInstanceCount

General

TargetInstanceCount

General

WaitForOperation

General

Count

Instance

CountSourceRecords

Instance

Exist

Instance

FindByPos

Instance

FindValue

Instance

GetInstance

Instance

Max

Instance

Min

Instance

ResolveOneOf

Instance

SetInstances

Instance

SortInstances

Instance

Sum

Instance

SumCSV

Instance

SumString Instance

GetLastError

Logging and Error

RaiseError

Logging and Error

ResetLastError

Logging and Error

SetLastError

Logging and Error

WriteToOperationLog

Logging and Error

Case

Logical

Equal

Logical

If

Logical

While Logical

Ceiling

Math

Exp

Math

Floor

Math

Log

Math

Log10

Math

Mod

Math

Pow

Math

Round

Math

RoundToInt

Math

Sqrt

Math

FromDataLoaderDate Salesforce
Deprecated
FromDataLoaderDateTime Salesforce
Deprecated

GetSalesforceTimestamp

Salesforce

LoginToSalesforceAndGetTimeStamp

Salesforce

SalesforceLogin

Salesforce

SetSalesforceSession

Salesforce

SfCacheLookup

Salesforce

SfLookup

Salesforce

SfLookupAll

Salesforce

SfLookupAllToFile

Salesforce

CountSubString

String

DQuote

String

Format

String

Index String

IsValidString String

Left String

LPad String

LPadChar String

LTrim String

LTrimChars String

Mid String

ParseURL String

Quote String

RegExMatch String

RegExReplace String

Replace String

Right String

RPad String

RPadChar String

RTrim String

RTrimChars String

Split String

SplitCSV String

StringLength String

ToLower String

ToProper String

ToUpper String

Trim String

TrimChars String

Truncate String

URLDecode String

URLEncode String

Validate Text Validation

Attribute

XML

CreateNode

XML

GetNodeName

XML

GetNodeValue

XML

GetXMLString

XML

IsNil

XML

RunXSLT



XML

SelectNodeFromXMLAny

XML

SelectNodes

XML

SelectNodesFromXMLAny

XML

SelectSingleNode XML

Backtotop

Anchor
jitterbit-javascript-functions
jitterbit-javascript-functions
JavaScript Functions

Multiexcerpt include
MultiExcerptNamefunctions-index-notes
PageWithExcerptFunctions Index

Tableenhancer
sortColumn1
rowNumbersindependentFromSorting
decimalMark. (point)

Backtotop

Panel
borderColor#65379B
titleColor#FFFFFF
titleBGColor#65379B
titleOn This Page
Table of Content Zone

Table of Contents
maxLevel3
minLevel2
indent20px
excludeSyntax|Declaration|Description

Panel
borderColor#8C9CB4
titleColor#FFFFFF
titleBGColor#8C9CB4
titleSearch in This Topic
Page Tree Search
rootPageFunctions
Panel
borderColor#00B886
titleColor#FFFFFF
titleBGColor#00B886
titleRelated Topics

HideElements
metastrue

Last updated: 

Lastmodifieddate