nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Putta Challa <>
Subject EvaluateXPath to process xml data does not support nodeset
Date Fri, 13 Oct 2017 20:34:03 GMT

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
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>

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.
View raw message