Any help guidance much appreciated. Thanks, Keith ________________________________ From: Keith Lim<mailto:[email protected]> Sent: 5/31/2016 4:07 PM To: [email protected]<mailto:[email protected]> Subject: Which processor to use to cleanly convert xml to json?
Which processor should I use to cleanly convert from xml to json? This article illustrates using TransformXML with a stylesheet to convert xml to json. https://community.hortonworks.com/articles/29474/nifi-converting-xml-to-json.html However, I am seeing that it does not convert values with special tag such the embedded <br> tag as below: XML fragment: <record> <property1>Lake<BR/>River<BR/>National_State Park</property1> <property2>A:Value1<BR/>B:Value2<BR/>C:Value3<BR/>D:Value4<BR/>E:Value5</property2> </record> Converted Json: { "record" : { "property1" : { "BR" :["",""] }, "property2" : { "BR" :["","","",""] } }} I may need to readup on stylesheet however, this is just the problem I am seeing, and don't know what other issue may crop up using this script. Thanks, Keith
