Forum Discussion

IrynaSagaidachn's avatar
IrynaSagaidachn
New Contributor
11 years ago

Sotring the values in the EXCEL data source

Hello everyone!

There is a data source - .xls file, which consists of two columns, representing the set of certain error codes and their descriptions.
It is necessary to check the compliance of the error code, received from the server, with its description, reffering to this data source.

How can this be done using the SOAP UI Pro functions or the appropriate groovy script, to sort out the combinations of error codes and their description from the .xls file?

Thank you in advance.
  • Cizo89's avatar
    Cizo89
    Frequent Contributor
    11 years ago
    Hi,

    yes, it can be done in SoapUI using Pro features (DataSource step) as well as via Groovy script.
    Please, see attached zipped file - it contains a simple draft and excel spreadsheet, which may give you the idea.
    It just a simple loop over the spreadsheet, storing those details in Properties TestStep and then checking your requested code against that data.

    In case of any further questions, feel free to ask

    Regards,
    Marek