Hello,
I'm running SOAP requests using customer information from a test customer database.
Each customer's DOB changes on a daily basis so that they remain the exact same age down to the day - I have an Excel file with the test customer names and DOB (as calculated to reflect the age in the test customer database).
Is there a way I can use the Excel file as a data source, and have ReadyAPI look up the test customer forename and surname I use in the request in order to return the correct DOB as calculated that day? Similar to a VLOOKUP in Excel?
If not, do you have any suggestions as to other ways I may be able to tackle this issue?
Thanks in advance!
