Hi - I’m new to CloverETL so I apologize for the newbie question. I wasn’t able to find any references to JSON on the forums or the Clover ETL website.
Is there any specific support for converting XML data to JSON data? In particular I need to consume SOAP/XML based messages and return data in a JSON format. Can Clover ETL help me with graphically defining the mapping and doing the conversion?
Thanks,
Gary
Anyone? Still looking for suggestions…
Hello Gary,
CloverETL doesn’t have any built-in mechanism for processing JSON data. I see two solutions in Clover:
use XSLTransformer component. XSL Transformation for converting xml to JSON is described on xml2json-xslt or Convert XML to JSON using XSLT
use Reformat component, that transforms xml to JSON with help of JSON XML.java. The transformation can be written directly in java or you can write a ctl function (see attached file)
Hello,
since CloverETL 3.1 xml2json and json2xml functions will be part of CloverETL.