Michael Thomas admin


Michael Thomas
Last Active
Admin, Staff
  • Re: Testing REST (GET) service that needs Excel and Database data sources

    Hi Diego,

    There are a couple of consequential reasons as to why you may be experiencing no data. Currently, I only have an assumption of your use-case. Please verify.

    1. It seems as if you have a setup test which reads from the Excel Datasource and input data to your database.
    2. You run a SQL query to get a particular id from that database.
    3. You run a GET REST request using that id.
    4. You run a tear down test which removes all of the information from the database based on the Excel Datasource.

    From the statement, "I know this can be easily done by using a database data source..." I am assuming that you were successful at using the Database Datasource. If not, please verify that this works using the database Datasource.
    Rather than using the Database Datasource, why not try using the DB Tool instead of the Database Datasource as shown by the image below. After your setup test, the DB Tool can query for the data, and store it into an XML Data Bank. Your messaging client can grab the results from your XML Data Bank. The image below represents the setup I would use for the use-case above. Please let me know if this helps.