2022.2

JSON File Input Data settings
ForaJSONfileyoucaneitherusetheobjectorarrayattherootandgetoneoutputrecord,orselectan
objectorarrayasparent element.Itsdirectchildelements-objectsandarrays,notkey-valuepairs-
canbeoutputasindividualrecords.
l
Use root element:Selectsthetop-levelarrayorobject.Therewillonlybeonerecord.
l
Use specific element:Selectanarray[ ]orobject{ }intheJSONdataasParent elementto
defineitschildelements-objectsand/orarrays-assourcerecords.Anyelementsoutsidethe
parentelementandkey-valuepairsinsidetheparentwillberepeatedineachsourcerecord.
Note: Onlyarraysandobjectscanbeseenasarecord.ItisnotpossibletosplittheJSON
betweenkey-valuepairs.
Boundaries
Boundariesarethedivisionbetweenrecords:theydefinewhereonerecordendsandthenextrecord
begins;foranexplanationsee"Recordboundaries"onpage226.
CSV, Excel or Database file boundaries
SincedatabasedatasourcesarestructuredthesamewayasCSVandExcelfiles,theoptionsforthese
filetypesareidentical.
l
Record limit:DefineshowmanyrecordsaredisplayedintheDataViewer.Thisdoesnotaffect
outputproduction;whengeneratingoutput,thisoptionisignored.Todisablethelimit,usethe
value0(zero).
l
Line limit:Definesthelimitofdetaillinesinanydetailtable.Thisisusefulforfileswithahigh
numberofdetaillines,whichintheDataMapperinterfacecanslowdownthings.Thisdoesnot
affectoutputproduction;whengeneratingoutput,thisoptionisignored.Todisablethelimit,use
thevalue0(zero).
l
Trigger:Definesthetypeofrulethatcontrolswhenaboundaryisset,creatinganewrecord.
l
Record(s) per page:Definesafixednumberoflinesinthefilethatgoineachrecord.
l
Records:Thenumberofrecords(lines,rows)toputineachrecord.
l
On change:Definesanewrecordwhenaspecificfield(Field name)hasanewvalue.
l
Field name:Displaysthefieldsinthetopline.Theboundariesaresetontheselec-
tedfieldname.
Page 313