Thanks, I'll check it out. Get Outlook for iOS<https://aka.ms/o0ukef>
On Fri, Sep 2, 2016 at 9:07 AM +1000, "Joey Frazee" <[email protected]<mailto:[email protected]>> wrote: Guillaume, I've had a fair bit of success using TransformXml to transform XML into JSON and then PutHBaseJSON to persist the data in HBase. There are lots of XML to JSON stylesheets out there but this is what I've been using: https://github.com/bojanbjelic/xml2json If you take this approach, do make sure you update the mime.type attribute after the transformation with an UpdateAttribute; otherwise the provenance data viewer will treat the newly created JSON as XML. -joey On Sep 1, 2016, at 4:47 PM, Guillaume Pool <[email protected]<mailto:[email protected]>> wrote: Hi, I don't think there is a specific converter but you can use evaluatexpath to store the attributes from the xml document. Depending on the input you can use xmlsplit and split it at the level in the xml that will give you a flowfile per record, then extract attributes using evaluate xpath, then use attributes to json to put those attributes into json document, then puthbase that into hbase. Rough idea above of how i would go about it. All depends on what you are trying to achieve. Regards Guillaume Get Outlook for iOS<https://aka.ms/o0ukef> On Fri, Sep 2, 2016 at 6:45 AM +1000, "Nathamuni, Ramanujam" <[email protected]<mailto:[email protected]>> wrote: Please give me some pointer to start working :) ************************************************************************* This e-mail may contain confidential or privileged information. If you are not the intended recipient, please notify the sender immediately and then delete it. TIAA *************************************************************************
