Excel datasink to consume repeating xml elements without having to map multiple properties
Currently there's no functionality that provides the abiltiy to map an XML rest response with repeating elements to a datasink without mapping each indivitual repeating element.
Is there a way to map a repeating element from a response into a datasink automatically, rather than having to click getData and manually clicking each one.
So, if I have 25 repeating elements. Widgets again. They all have the same attributes. A1, A2, A3. I want my sink to collect each of the attributes from each of the widgets, but I don't want to have to map it explicitly in the data sink property and the every one of the 25 widgets (x3 attributes) in my response.
example:
<widgets> <widget> <att1>abc</att1> <att2>xyz</att2> <att3>asd</att3> </widget> <widget> <att1>abc</att1> <att2>xyz</att2> <att3>asd</att3> </widget> ... </widgets>
In my datasink, I'd like to map these out 1 element to 1 row in excel:
excel row 1 (first widget): att1: abc, att2: xyz, att1: asd
excel row 2 (second widget): att2: abc, att2: xyz, att1: asd
What I'm trying to avoid is this:
All the way through dozens of these objects.