2022.2

InthistreeviewyoucanselectelementsjustlikefilesintheWindowsExplorer.KeeptheCtrlkey
presseddownwhileclickingonkey-valuepairsorbracketstoselectmultipleelements,orkeepthe
Shiftkeypresseddowntoselectconsecutiveelements.
Youcanselectmultiplekey-valuepairs,arraysandobjectsevenifthoseareindifferentelements.
TogetabetteroverviewyoucancollapseanyJSONlevel.
JsonPath
TheDataMappermovesthroughJSONfilesusingJsonPath,apath-likesyntaxtoidentifyandnavigate
elementsinaJSONdocument.ForanoverviewoftheJsonPathsyntax,seehttps://github.com/json-
path/jsonpath.
IntheDataMappertheJsonPathcanbeabsolute(startwith$whichistheroot)orrelativetothecurrent
position(startwith.whichisthecurrentelement).
JsonPathcanbeusedinaRepeatstep,ExtractstepandConditionstep,ofteneliminatingtheneedfor
aGotostep.
AJsonPathcanberelativeorabsolute.Note,however,thatwitharelativeJsonPathgoinguptoapar-
entelementisnotpossible.
Tip: ThefullJsonPathtoanelementisdisplayedatthebottomleftofthewindowwhenyou
selectit.Tocopythepath,right-clickitandselectCopy.
Note: IfakeyinaJSONfilehasanamethatlookslikeafunction(e.g."TLIST(A1)"),thenthe
ExtractstephastouseaJsonPathwithbracketnotationinsteadofthedefaultdotnotation.For
informationaboutthebracketnotationseehttps://goessner.net/articles/JsonPath/.
Extractingtransactionaldata
Promotional dataaredataaboutcustomers,suchasaddresses,namesandphonenumbers.InCon-
nect,eachrecordintheextractedrecordsetrepresentsonerecipient.Thenumberoffieldsthatcontain
promotionaldataisthesameineachrecord.Thesedataarestoredontherootleveloftheextracted
record.
Transactional data,ontheotherhand,areusedincommunicationsabouttransactionsbetweena
companyandtheircustomersorsuppliers:invoices,statements,andpurchaseorders,forexample.
Naturallythesedatadifferpercustomer.Theyarestoredindetail tablesintheextractedrecord.The
numberofdetaillinesinadetailtablecanvaryfromrecordtorecord.
Page 235