I am building an integration with another system. I've done tons via SQL and .csv, but I've never tried to parse and load an xml file. I've included a sample xml file that resides on a shared drive and I can easily read. I have the java to find the location/file. The problem is parsing.
Here is the sample:
<?xml version="1.0" encoding="UTF-8"?>
<Project:Application>
<header:SubmissionHeader>
<header:Name>CA Technologies</header:Name>
<header:Number>PRJ12345</header:Number>
<header:Title>XML File Parse</header:Title>
</header:SubmissionHeader>
<Project:Forms>
<Budget:Budget>
<Budget1:ID>12345</Budget1:ID>
<Budget1:Type>Project</Budget1:Type>
</Project:Forms>
</Project:Application>
Here is what I traditionally use for csv:
<core:catch var="filerr">
<file:readFile commentIndicator="#" delimiter="," embedded="false" fileName="${wrkDir}/${wrkFile}" var="input"/>
</core:catch>
<core:choose>
<core:when test="${filerr != null}">
<gel:log level="ERROR">Error: ${fileerr}. Check input File. "${wrkDir}/${wrkFile}"</gel:log>
</core:when>
<core:otherwise>
<core:forEach begin="1" indexVar="i" items="${input.rows}" step="1" var="row">
<!-- Start of CSV Variables-->
<core:set value="${row[0]}" var="record_type"/>
<core:set value="${row[1]}" var="id"/>
<core:set value="${row[2]}" var="segment_date"/>
<core:set value="${row[3]}" var="segment_amount"/>
<core:set value="${row[4]}" var="time_stamp"/>
From here, I have them in variables and can xog into the staging object, yada, yada, away we go. But how do I do the same with an XML file instead of a csv?
Thanks for the help.