JSON mapping support

gmui

• January 27, 2011 00:00

• Answered

Follow

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

• 

  gmui

  • February 04, 2011 16:15

  0

  Comment actions Permalink

  Anyone? Still looking for suggestions...
• 

  avackova

  • February 07, 2011 10:00

  0

  Comment actions Permalink

  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)

  • org.json.ctlfunction.zip
• 

  avackova

  • February 18, 2011 08:15

  0

  Comment actions Permalink

  Hello,
  since CloverETL 3.1 xml2json and json2xml functions will be part of CloverETL.

Please sign in to leave a comment.