Service Virtualization

  • 1.  XML Input

    Posted Sep 12, 2018 09:36 AM

    How to pass the input value from the input sheet(excel) to xml (the corresponding passing value from excel should write into xml).



  • 2.  Re: XML Input

    Broadcom Employee
    Posted Sep 12, 2018 09:40 AM

    How are you reading the EXCEL sheet ?   Do you have a sample data that you can share? 



  • 3.  Re: XML Input

    Posted Sep 12, 2018 11:31 AM

    Reading the excel ref attachment

    Wriiten code from reading excel



  • 4.  Re: XML Input

    Broadcom Employee
    Posted Sep 13, 2018 11:08 AM

    Jaishankar,  could you please open a ticket with CA Support ? It is easier to troubleshoot in a webex session. 

     

    Thanks

     

    Shiney



  • 5.  Re: XML Input

    Posted Sep 14, 2018 03:27 PM

    Jaishankar,

     

    When you read a column from an Excel spreadsheet you simply use the following syntax: {{columnName}}. For example, if you have a column name called "FirstName" in your spreadsheet, then the property/variable syntax is: {{FirstName}}

     

    Note that capitalization matters. Now if you have an XML somewhere, let's say you have the following XML:

     

    <Employee>

      <Name>Fred</Name>

    </Employee>

     

    And you want to parameterize the <Name> element then you can simply replace "Fred" with {{FirstName}} like this:

     

    <Employee>

      <Name>{{FirstName}}</Name>

    </Employee>