endor_force Thanks for the reply. I see what you're getting at with being able to visually build out the result.
What this doesn't help solve is getting nested pieces of data aligned. Where there are multiple dependents in the data, they would need to be repeating "Dependent Records" under the "Employee Record". The actual schema has a number of these, including multiple levels deep (for example, if each dependent could also have multiple 'addresses').
It relies on that the data input to the xml generator contains the relationships as you intend to have them related in the xml structure.
Then in the xml generator you would be able to generate output based on that structure using a for each loop for child relations in a list.
Attached is a new sample which groups data twice, first by employee to create dependencies and then one common large group in order to be able to have all records in one common xml file out.
I have two foreach loop, one for each employee and then one for each dependent record.
Here is some reference and sample of the Velocity syntax: Apache Velocity Engine - User Guide
thanks for responding. not sure why, but my images wouldn’t upload. i inquired about this and am currently waiting for a moderator to help me with getting my illustrations and examples uploaded.
Hi CJ, I was able to get the images uploaded. You can see what my input looks like, and what I’m trying to achieve, I’ve illustrated in the mocked up JSON that’s at the beginning of my post. Basically, for each product-id, I want there to be an array of variantid’s.
