AnySQL Modeler JSON to XML BOD

Legacy Contributor

Hello All,

I am reading data from an Oracle table using AnySQL modeler. Output from AnySQL modeler is coming as JSON files. How can i convert this JSON file to XML BOD which can be accepted by LN ERP. I looked into mappings in data flow and found that in graphical modeler, Source and target document should be of type BOD. But in this case our source is JSON file.  Is there any other way to achieve this?  We are on MT cloud.

Any help is appreciated!!!

Thanks

Anmol

Legacy Contributor

Hi Anmol

as you are MT then you can run the JSON through a script (also found in the ION Desk menu) - this will run a python script of your creation and so can produce the BOD you are after