Getting error while creating Structures for Json in Hierachical Mapper.

[manodwhb]

Hi ,

I am getting below error while creating Structures for Json in Hierachical Mapper. 

Overall:Error
1: Error - An exception occurred parsing the document being imported. (15)
Exception: java.lang.ClassCastException: java.lang.String cannot be cast to com.oaklandsw.transform.rep.json.tokener.JSONObject
at com.oaklandsw.transform.rep.json.tokener.JSONTokenTool.aggregate(JSONTokenTool.java:41)
at com.oaklandsw.transform.rep.json.tokener.JSONArray.getTypicalElement(JSONArray.java:1213)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.readJsonArray(JsonTokenImporter.java:95)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.readJsonObject(JsonTokenImporter.java:80)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.readJsonArray(JsonTokenImporter.java:110)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.readJsonObject(JsonTokenImporter.java:80)
at com.oaklandsw.transform.rep.json.JsonTokenImporter.parseSubclass(JsonTokenImporter.java:54)
at com.oaklandsw.transform.rep.AbstractFileReader.parse(AbstractFileReader.java:122)
at com.oaklandsw.util.AbstractXmlReader.parse(AbstractXmlReader.java:69)
at com.oaklandsw.transform.importing.Importer.doImportParse(Importer.java:991)
at com.oaklandsw.transform.rep.json.JsonSampleImporter.doImportSubclass(JsonSampleImporter.java:55)
at com.oaklandsw.transform.importing.Importer.doImport(Importer.java:884)
at com.oaklandsw.transform.importing.Importer.run(Importer.java:787)
at com.oaklandsw.transform.importing.ImportWizard$ImporterRunner.run(ImportWizard.java:407)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

[Haitao]

Please share your steps and if possible your project.

[manodwhb]

@hnie , I need to convert complex xml into Json and trying to use tHMap.

my job looks like below.

tfilinputxml-->tHMap--->tFileoutputRaw. where i need to know the configuration details for tHMap.

[rriahi]

Hi,

can you please send us a part from your xml and how the json file should be?

[manodwhb · Accepted solution]

I have fixed this error by creating structures.