2022.2

l
Sort on:Selectafieldonwhichtosortthedata,inascending(A-Z)ordescending(Z-A)
order.Notethatsortingisalwaystextual.Eveniftheselectedcolumnhasnumbers,itwill
besortedasatext.
Note: ToinstructtheSQLServerdrivertonotuseencryption,the";encrypt=false"parameter
needstobepresentintheconnectionstring.Formoreinformationsee"KnownIssues"on
page102.
Using the wizard for JSON files
TheDataMapperwizardforJSONfileshelpsyoucreateadatamappingconfigurationforasimple
JSONfile.Thewizardprovideslimitedoptionsforspecifyingsourcerecordsandboundaries,andadds
oneextractionstep.
Note:
Thewizardcannotcreatedetailtables.Ifthefilecontainstransactionaldata,thedatamapping
configurationisbestcreatedwithoutawizard(see"Creatinganewdatamappingconfiguration"
onpage200).
ThetopicSettingupdetailtableswithJSONdescribeshowtoturnrepeatingitemsinanarrayor
objectinJSONintodetailtables.
TherearetwowaystoopenaJSONfilewithawizard:fromtheWelcomescreenorfromtheFilemenu.
l
FromtheWelcomescreen
1.
OpenthePlanetPressConnectWelcomepagebyclickingthe iconatthetoprightor
selecttheHelpmenuandthenWelcome.
2. ClickNew DataMapper Configuration.
3. FromtheUsing a wizardpane,selectJSON.
4. ClicktheBrowsebuttonandselectthefileyouwanttoworkwith.ClickNext.
l
FromtheFilemenu
1. Inthemenu,clickFile > New.
2. ClicktheData mapping Wizardsdrop-downandselectFrom JSON File.
3. ClickNext.
4. ClicktheBrowsebuttonandselectthefileyouwanttoworkwith.ClickNext.
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
Page 210