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]> 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
> 
> 
> 
> 
> On Fri, Sep 2, 2016 at 6:45 AM +1000, "Nathamuni, Ramanujam" 
> <[email protected]> wrote:
> 
> Please give me some pointer to  start working J 
>  
>  
> 
> *************************************************************************
> 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
> *************************************************************************

Reply via email to