Forum Discussion

xx1234g's avatar
xx1234g
Occasional Contributor
13 years ago

Does SoapUI support asserting from excel file?

Hi all,

I'm currently working on a data migration project. I would like to check the values in user profile by using user id.
The DataSource is a excel file export from mySQL. I know how to load the data to each SoapUI request, but are any ways to compare the respond data with the DataSource excel file?

For example:
The excel sheet I have few columns:
Column:______A__|______B____|____C___|______D___|_______E
DataName: user_id | user_name | birthday | first_name | last_name

I can use the DataSource step to get each user_id from excel and then run the "Get User" API.
After I got the respond, how can I create assertion comparing column B, C, D, E in excel?

Thanks so much~

Andy Fung

3 Replies

  • nmrao's avatar
    nmrao
    Community Hero
    13 years ago
    Text comparison would work for you? If so, you may use a master copy to verify the actual respone.
  • xx1234g's avatar
    xx1234g
    Occasional Contributor
    13 years ago
    Hi Mrao,

    Thanks for replying.
    Text comparison is what I need, but how can I compare the response data with the cell B1 in Excel file?
    Please give me an idea

    Thanks a lot~

    Andy Fung