2022.2

Table Of Contents

Syntaxrules

IntheDataMapper,allscriptsmustbewritteninJavaScript,followingJavaScriptsyntaxrules.For

example,eachstatementshouldendwith;andthekeywordsthatcanbeused,suchasvartodeclare

avariable,areJavaScriptkeywords.TherearecountlesstutorialsavailableontheInternettofamil-

iarizeyourselfwiththeJavaScriptsyntax.Forasimplescriptallthatyouneedtoknowcanbefoundon

thefollowingwebpages:W3Schoolswebsite-JavaScriptSyntaxandhttps://www.w3schools.-

com/js/js_if_else.asp.AcompleteJavaScriptguideforbeginnerscanbefoundhere:https://developer-

.mozilla.org/en-US/docs/Web/JavaScript.

DataMapperAPI

CertainfeaturesthatcanbeusedinaDataMapperscriptdonotexistinthenativeJavaScriptlibrary.

TheseareadditionalJavaScriptfeatures,designedforuseinConnectonly.Allfeaturesdesignedfor

useintheDataMapperarelistedintheDataMapperAPI(see"DataMapperScriptsAPI"onpage360).

ExternalJavaScriptlibraries

TheExternalJSLibrariesboxontheSettingspaneletsyouaddJavaScriptlibrariestoyourcon-

figurationanddisplaysallthelibrariesthathavebeenimported(see"Settingspane"onpage307).

YoucanuseJavaScriptlibrariestoaddmoreJavaScriptfunctionalitytoyourdatamappingcon-

figuration.AnyfunctionsincludedinaJavaScriptlibrarythatisimportedinadatamappingcon-

figurationwillbeavailableinPreprocessorscriptsaswellasActiontasks,Postfunctionsand

JavaScript-basedextractionsteps.

TakethefollowingJavaScriptfunction,forexample:

function myAddFunction(p1, p2) {

return p1 + p2;

};

IfthisissavedasmyFunction.jsandimported,thenthefollowingwouldworkanywhereinthecon-

figuration:

var result = myAddFunction(25, 12); // returns 37!

Setting boundaries using JavaScript

AssoonasyouselecttheOn Scriptoptionasthetriggerforestablishingrecordboundaries(see

"Recordboundaries"onpage226),youareinstructingtheDataMappertoreadthesourcefilesequen-

tiallyandtotriggeraneventeachandeverytimeithitsadelimiter.(Whatadelimiteris,dependsonthe

sourcedataandthesettingsforthatdata;see"Inputdatasettings(Delimiters)"onpage224).

Inotherwords,thescriptwillbeexecuted-bydefault-asmanytimesastherearedelimitersinthe

inputdata.

Page 364