2022.2

l
TheboxbelowthefilenameallowstopasteorenterJSONdata.AfteropeningaJSONfilethe
JSONdatawillappearinthisbox.YoucanreviewandedittheJSON.
ForthetypesofJSONthatareaccepted,seebelow.
l
Replace Data Model:SelectingtheReplaceDataModeloptionremovestheexistingData
ModelfromthetemplateandcreatesanewDataModelbasedonthekeysfoundintheJSON.
Whenthisoptionisnotchecked,theJSONdataismappedtoanycorrespondingfieldsinthe
existingDataModel,anddatathatdoesnotcorrespondtoanyfieldisdiscarded.
Note: Ifadatamappingconfigurationisopenatthesametime,theloadedJSONwill
alwaysreplacetheDataModelandnovalueswillbeimported.
l
Finish:IftheJSONisvalid,youmayclickFinishtoimportthedataintotheDataModelpane.
Arraysofobjectsareconvertedtorecords(ordetailtables);key-valuepairsareconvertedtodata
fields.
Note: TheJSONSampleDataisnotstoredwiththetemplate.Inordertoreusethedatayou
shouldcreateaJSONfileondiskandloaditviatheFileoptioninthisdialog.
Types of JSON data
YoucanaddthefollowingtypesofJSONdata:
l
A JSON object or an array of JSON objectsrepresentingrecords.Thedatatypeisderived
fromthedata:
l
AnyvaluesurroundedwithquotesisconvertedtoafieldoftypeString.
l
AnynumericvaluecontainingaperiodisconvertedtoafieldoftypeFloat.
l
AnynumericvaluethatdoesnotcontainaperiodisconvertedtoafieldoftypeInteger.
l
Avalue"true"or"false"isconvertedtoafieldoftypeBoolean.
l
Typed JSON.ThisJSONfollowsthestructureofaJSONRecordDataList(seetheRESTAPI
Cookbook).FieldtypesaredeterminedbytheschemaobjectintheJSON.
AnynestedJSONobjectsaredisplayedonsuccessivelevelsintheDataModel.
Examples
Example: Asinglerecordwithtwofields
{ "first": "Peter", "last": "Parker" }
Page 892