Forum Discussion

raghu1012's avatar
raghu1012
Occasional Contributor
5 years ago

Excel to XML generation using groovy script in SOAP UI

I am facing issue while reading excel file and generating XML strtcutre using groovy scripting. Please advise how can we handle where parentnode(Startmap) and child node(Startmap) has same name. /...
nmrao's avatar
nmrao
Champion Level 3
What is the input and desired output?
raghu1012's avatar
raghu1012
Occasional Contributor
5 years ago

Hi Rao,

 

Input is Excel file and Output is XML response.

 

PFA both excel and output.

 

Let me know if you need any more details.

  • nmrao's avatar
    nmrao
    Champion Level 3
    5 years ago
    It is difficult to understand the issue from the given files.
    Please simplify the issue.
    By the way, here is the groovy documentation on how one can build xml.
    http://groovy-lang.org/processing-xml.html
    • raghu1012's avatar
      raghu1012
      Occasional Contributor
      5 years ago

      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!

      • raghu1012's avatar
        raghu1012
        Occasional Contributor
        5 years ago

        Hi,

         

        Any suggestion on my issue.

         

        Groovy documentation did not help me much to figure it out.

         

        Thank You!