Excel to XML generation using groovy script in SOAP UI

Hi Rao,

Thank you for your response and sharing the groovy documentation.

Below is the issue details and still looking for hint to fix this.

I am trying to build the xml by reading the data from excel file. Below is the tag hierarchy followed in excel and same has to be created in xml format.

Sample 1:

Level 1: Business Data

Level 2: CONTACT

Level 3: KontoAntrag

Level 4: Starteinzug

tns1:BusinessData/tns1: CONTACT/tns1:KontoAntrag/tns1:Starteinzug

Sample 2:

Level 1: Business Data

Level 2: CONTACT

Level 3: Starteinzug

Level 4: BetragStarteinzug

tns1:BusinessData/tns1: CONTACT/tns1:Starteinzug/tns1:BetragStarteinzug

In the above two samples you can notice tag name 'Starteinzug' appears at level 4 in first one and at level 3 in another sample.

As field ‘Starteinzug’ exists both at parent node of ‘CONTACT’ and one at child node for the field ‘KontoAntrag’,  method CheckAndUpdateNode internally calls checkAndCreateNode method to create a field ‘Starteinzug’ and we are facing below overlapping prototypes exception error.

groovy.lang.GroovyRuntimeException: Ambiguous method overloading for method com.eviware.soapui.support.XmlHolder#. Cannot resolve which method to invoke for [null] due to overlapping prototypes between: [interface org.apache.xmlbeans.XmlObject] [interface org.w3c.dom.Node] error at line: 2428

Thank you!