Hi, I am downloading data in xml format using GetHttp processor and trying to convert this data into a tab separated value file. When I try to use EvaluateXPath processor to grab the header data (<COLUMNS> and actual data <DATA> nodes from the xml file, have the following issues
1) With EvaluateXPath you can’t have 2 XPath’s defined. Is there a way to overcome this limitation? 2) even if I try to get just <DATA> nodes (there are multiple DATA nodes in a given xml), I am getting the following exception. 18:26:39 UTC ERROR 16fb46ea-015f-1000-0000-00007c5fd65b 172.31.192.18:8080 EvaluateXPath[id=16fb46ea-015f-1000-0000-00007c5fd65b] Routing StandardFlowFileRecord[uuid=b941988f-f925-4ec2-a3e5-2830e47cbe8b,claim=StandardContentClaim [resourceClaim=StandardResourceClaim[id=1507917338870-99, container=default, section=99], offset=204551, length=204551],offset=0,name=listings.xml,size=204551] to 'failure' because the XPath evaluated to 257 XML nodes Sample xml file contents: <?xml version="1.0" encoding="UTF-8" ?> <COMPS ReplyCode="0" ReplyText="Operation Successful"> <COUNT Records="258"/> <DELIMITER value="09"/> <COLUMNS>Column1Column2Column3Column4Column5 </COLUMNS> <DATA>value11 value12 value13 value14 value15</DATA> <DATA>value21 value22 value23 value24 value25</DATA> </COMPS> Thank you, Putta Challa ________________________________ This email may be confidential. If you are not the intended recipient, please notify us immediately and delete this copy from your system.
