Hello, I am trying
to do data validation in in XML in NiFi . Scenario is as below: Xml example:
<?xml version="1.0"
encoding="UTF-8" standalone="yes"?> <appLog id="7.8.0"
application="abc">
<nodeId>1234</ nodeId >
< branch id="22"> <logItem> <logId>111</logId> <subnodeId>1</areaId> <detail>sdadadadf</ detail
> <userId>005</userId> <trantime>19/07/2018
11:56:43</eventTime> <comments>abcdefgh</ comments
> </logItem>
</ branch > </applicationLog> Considering xml sample above I
need to check if attributes detail or comments are null and if so replace them
with ‘NA’ and put files in a separate folder for manual correction if user Id
is null. For the
validation part I tried EvaluateXPath with two xml files sample, one with error
and one without error but either both get matches or fail. I tried following
xquery and many more which run fine independently but do not give desired result in NiFi - EvaluateXquery: 1 )for $x in
/applicationLog/till/logItem where
($x/userId != '') return 'matched' 2 )if (exists(index-of(//userId, ''))) then
('unmatched') else ('matched') I plan to
use UpdateAttribute for replacing null value for detail and comments whoever did
not find any examples online to replace contents of xml file. Please help.
Thanks a lot in advance!
... View more
