Contributions
Return DOB for specified customer from Excel workbook (similar to Excel VLOOKUP)
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!Solved2.1KViews0likes10CommentsRe: Return DOB for specified customer from Excel workbook (similar to Excel VLOOKUP)
ChrisAdamsrichie Thank you both so much for taking the time to respond to this thread, and thanks Chris for the resolution! A few things have come up at work today meaning I can't implement this right now, but I'll hopefully have time to try it out tomorrow or Monday😊3 years agoPlace ReadyAPI QuestionsReadyAPI Questions247Views0likes0CommentsRe: Return DOB for specified customer from Excel workbook (similar to Excel VLOOKUP)
richieChrisAdams I think it might help if I give a bit more context to the situation. I work for a financial institution that provides mortgages, so the test cases I'm putting through are test mortgage applications. When I run the XML request (or 'submit the application') it compares my customer's name, DOB and address to the 'Credit Reference Agency' (CRA) data, or the customer database. I don't have direct access to this to be able to reference the DOB's directly from there, which is where the spreadsheet comes in - it calculates the DOB to mirror what will be in the CRA data, so I can use the DOB from the spreadsheet to get a match on my customer from the CRA. So I want to be able to choose any customer from our list, and for it to cross reference the customer's name with the spreadsheet (which I thought was my Data source but maybe I'm wrong? Sorry I'm very new to this). So I don't necessarily want to pick a random row, I just want it to return the correct DOB whether I choose the customer on row 1, 100 or 1000 (choosing the customer would be 'at random' by me, but not actually randomised in the technical sense of the word). "What you need is the means to iterate over each row in Excel until you find the matching forename/surname pairing and return the DOB for that." Yeah, this is exactly what I need. At times I may run 150 test steps in a row, but other times it may only be a handful of test steps. The same customer information is likely to be used in each test step, but different customers may be used, and some test cases may be testing scenarios with up to 4 applicants, so there will be 4 different DOBs to match. Sorry again if I still haven't managed to make it fully clear, so far the most advanced thing I've managed to do in ReadyAPI is set custom project properties and reference them in my XML, so I'm very much at a beginner stage!3 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.8KViews0likes5CommentsRe: Return DOB for specified customer from Excel workbook (similar to Excel VLOOKUP)
Hi Rich, Thanks so much for responding to my query, and apologies that my explanation of what I'm trying to do wasn't so clear. Basically the test customer database was created in 2017, and the DOB of the customers in the DB is dynamic which keeps the age static. So the Excel doc we have works out their age in days at the time the test pack was produced, and in another column deducts that value from "TODAY" to produce a new date of birth which maintains the customer's age. So if the customer was 10,000 days old when the test pack was created, the date in this column will mean they are always 10,000 days old (this reflects the DOB in the database). Hope that makes more sense. So the value in the DOB field is dynamic, and I want to use this Excel doc as a data source. My aim is that I will be able to choose a test customer name from the test pack at random, and using the values in <Forename></Forename> and <Surname></Surname>, ReadyAPI will look up the DOB from the corresponding row in the Data Source and pull that value in the DOB column through into the <DOB></DOB> field. Thanks Rachael3 years agoPlace ReadyAPI QuestionsReadyAPI Questions1.8KViews0likes2Comments