2022.2

JSON file options
AfterselectingaJSONfile,specifyifandhowtheJSONfilemustbesplitintomultiplerecords.
Thisisdonebyselectinganobjectorarrayasparent element.Itsdirectchildelements-objectsand
arrays,notkey-valuepairs-canbeseenasindividualsourcerecords.Iftherootisselected,therewill
beonlyonesourcerecord.
Whethersourcerecordsareoutputasindividualrecordsdependsonthetrigger.Either:
l
SelectOn elementtocreateanewrecordintheoutputforeachobjectorarrayintheparentele-
ment.
l
SelectOn changetocreateanewrecordeachtimethevalueinacertainkey-valuepair
changes.Onlykey-valuepairsthatexistattherootofachildelementcanbeevaluated.
Alldatafoundinchildelementsoftheselectedparentelementareextractedtofieldsattherootofthe
DataModel.Ifavalueconsistsofanobjectorarray,theentireobjectorarrayisextractedtoonedata
field.
Fieldnamesarederivedfromkeys,objectsandarraysinthefirstrecord,butthosearen'tnecessarily
thesameinasubsequentrecord.Iffollowingrecordshaveadifferentstructure,forexampleifarecord
hasmorechildelementscomparedtothefirstrecord,somedatamaynotgetextracted.
Tip: JSONdatacanalsobeimporteddirectlyintotheDataModel;see"AddingJSONsample
data"onpage306.
XML file options
SelectwhatlevelofXMLelementsdefinesarecord.
TheTriggeriswhattriggersthecreationofanewrecord.Itcanbesetto:
l
On element:ThisdefinesanewrecordwhenanewelementoccursontheselectedXMLlevel.
l
On change:ThisdefinesanewrecordwhenaspecificfieldunderthechosenXMLlevelhasa
newvalue.Afterselectingthisoption,youhavetoselectthefieldthattriggersthecreationofa
newrecord.
Addingdatafromadatabase
1. ClickFile,selectAdd DataandthenclickFrom database data source.Browsetothelocation
ofthefileandselectit.
TheDesignercanopendatabasesfromthefollowingtypesofdatasources:
Page 301