Page 1 of 1

Pulling Content from a Node (XML files)

Posted: Mon Aug 28, 2017 10:33 pm
by leefate
Pulling Content from a Node (XML files)

I want to be able to pull one metadata item from hundreds of XML files. Is there a function that will allow CloverETL to 'look' in a folder where the xml files reside and extract the one piece of data I need from all of the files?

Re: Pulling Content from a Node (XML files)

Posted: Wed Aug 30, 2017 3:10 pm
by vazquezrosariop
Hi leefate

If I understand your question correctly, you want to extract a particular Element from multiple XML Files. If that's the case, you can accomplish this using the XMLExtract component and use a wild card in the URL. Assuming that all the XML files are the same structure, you will need to create the metadata upfront using the mapping field in the XMLExtract which will automatically create the XSD.

I have taken the liberty of building a project with an example of your use case.

XMLExample.zip
(417.51 KiB) Downloaded 13 times