Good afternoon, I have used this component previously to convert XML to a record list. In the past I have mapped every XML element to the corresponding structure and everything worked as expected. This time I have a fairly large XML but I only need a few tags mapped to an output structure. Here is an example XML below, in my case I want to create a structure to only map the three fields in red.
When I try to do this I get an error that the current node does not match the record definition. (understandable because I didn't map all of the fields in my structure) Is there any way to accomplish what I'm trying to do?
<IntLayer> <NumLookup> <FirstName>test</FirstName> <LastName>test</LastName> <Mbi>abc123</Mbi> <Ssn>1234567890</Ssn> <MdppInfo> <MdppList/> <MdppFinancList/> <MdppHcpcsList/> </MdppInfo> </NumLookup></IntLayer>
I checked back on this question and I can't upload my OML for some reason. Here's prints of the structure I used:
This processed the XML just fine with XmlToRecordList.
Hi Josh,
I've had to use this in projects where large XML files had to be processed - you're not mandated to map out every field, just the ones you need.
Here's an OML as an example - I've used your XML example but only created a part of the NumLookup structure within IntLayer. You can debug the Preparation for the screen and see that the IntLayer Record List is filled out with data.
Thank you, I will give this a try. I had my structure set the same way but the IntLayer structure just contained an attribute of type NumLookup structure (not record).
Did you manage to process the XML with a reduced structure Josh?
Afonso Carvalho wrote:
I did, I just forgot to come back and update this question. Thank you for the help!