Forum Discussion

Arunachalam_RM's avatar
Arunachalam_RM
Occasional Contributor
4 years ago
Solved

Compare multiple values from database against API response

Consider I am having one API which asks id as input.that id I can fetch from database and I can iterating the same request with multiple Id from database. It will produce response as per the id menti...
  • nathan_wright's avatar
    4 years ago

    If I understand the use case correctly, the DB call could be set as a JDBC Datasource that would have properties (columns) for each value you want to use either in a request or as part of the validation. The Datasource would split each record into a new row, so the input value and expected values are aligned in the assertion or other test steps that follow. In your requests, the Get Data menu can build a reference to the input value, while Get Data can also be used in assertions (either added via the outline view, or for something like a 'contains' assertion)

     

    This only really works when a single table/SQL returns all the values required - if it happens across multiple calls, the data would have to be organized as part of the test flow before being mapped to a datasource.