Reading XML file into ESP project

Rain — Tue, 17 Jul 2018 13:36:26 GMT

Hi.

I have been wrestling in understanding how ESP file system adapter reads data from XML file. I have a xml file for example:

<document>
<queryid>1</queryid>
<events>
<event>

My current understanding is that tags <event><events> cannot be nested inside another tag. They must be first tags. Am I correct? Because when I remove <document> tag then ESP can read XML succesfully.

Second observation: if I have a nested tag inside event tag then ESP will read values inside those tags not tags and values. For example
<dog>

will be read as

Boss

</value>

But when I include <![CDATA[ ]]> between <dog> and </dog> then tags and values are read correctly.

This second approach allows me to use functional window and parse nested XML. My aim is to understand if it's possible to read XML generated by third party application or do I need to have some requirements in place for that application so it produces XML that ESP can read.

Re: Reading XML file into ESP project

FredCombaneyre — Tue, 24 Jul 2018 14:10:06 GMT

If your input XML format does not match ESP standard input event XML format, then the best practice is to use your 2nd approach, parsing it in a functional window.

Hope this helps

Fred

topic Reading XML file into ESP project in Streaming Analytics

Reading XML file into ESP project

Re: Reading XML file into ESP project