Ask a Question

Excel datasink to consume repeating xml elements without having to map multiple properties

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.

 

Example: https://community.smartbear.com/t5/SoapUI-Pro/How-to-map-repeating-elements-from-xml-response-to-dat...

 

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: 

image.png

 

All the way through dozens of these objects.

1 Comment
Announcements
Welcome to the ReadyAPI Feature Requests board!

Here you can review submitted feature requests and vote up the ones you like! If you can't find the feature you want - go ahead and suggest your own idea. Ideas with the highest rating can be implemented in the product.

Check out the Create a Feature Request guide for more information.
New Here?
Welcome to the Community
Sign Up Here