Forum Discussion

Chandrakanth's avatar
Chandrakanth
Occasional Contributor
6 years ago

How to load a large XML data in Excel for Data driven testing

Hello Team,

 

I would like to know how to convert the bunch of XML data into excel for data driven testing. To explain it breifly, I have a large set of XML Responses and want to use that data in the excel through data source.

For single or multiple request and responses it is easy to solve that with the help of excel in data sources but coming to large set of data its bit difficult. How to resolve this issue??

Let's say the input request for a service is Employee number and for that input we receive so many columns with the data in an xml format.

 

Employee NumberDepartmentSalaryLocation
1Developer10000Texas
1Testing15000California
1BA20000MA
1SA30000TN

 

SO If I give a rquest as 1 it should display all the rows in the above excel instead of only 1st row. This is just example but I have lot more values and columns whicha re defined.

 

  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    5 years ago

    There is the XML type of a Datasource in ReadyAPI so, maybe, you can read an XML content to some property, and, then, parse it without using Excel. Also, please note that there is the Directory DataSource in ReadyAPI (you can use it to get the XML files content).

     

    But, ReadyAPI doesn't have built-in options for converting .xml file to .xslx format, you can do this using scripts in ReadyAPI or in another tool, for example like this: https://www.wikihow.com/Convert-XML-to-Excel.

  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    SmartBear Alumni (Retired)
    5 years ago

    There is the XML type of a Datasource in ReadyAPI so, maybe, you can read an XML content to some property, and, then, parse it without using Excel. Also, please note that there is the Directory DataSource in ReadyAPI (you can use it to get the XML files content).

     

    But, ReadyAPI doesn't have built-in options for converting .xml file to .xslx format, you can do this using scripts in ReadyAPI or in another tool, for example like this: https://www.wikihow.com/Convert-XML-to-Excel.