Contributions
Alternative to using Excel DataSink with VLOOKUP?
Hi, I currently havethe followingtest case where the aim is to create new records in a database table (Product)that includes a foreign key to another table (ProductType). I currently have the test setup as follows: JDBC DataSource that retrieves the IDs and Descriptions of records in ProductType table DataSink that saves these IDs and Descriptions to an Excel workbook in sheet 1. In sheet 2 I have a list of Product Names and Product Types that I want to use in a POST. I then use VLOOKUP to populate the ProductTypeId in sheet 2 based on the values in sheet 1 DataSource Loop Excel DataSourcethat pulls from sheet 2of the workbook POST RESTRequest that uses the Name and ProductTypeId values from data source DataSource Loop This works perfectly well for the momenthowever I have 2 concerns going forward: The SoapUI project is version controlledusing Visual Studio, the Excel workbook should really be checked in along with the project however would mean that I need to check out the Excel workbook every time I wanted to run the DataSink step. When the project moves to another environment, the server may not have an instance of Excel I would therefore like to keep all data sources contained within SoapUI (e.g. use the Grid type) I have played around with using Grid data sources and using Property Transfer steps but I'm stuck. Unfortunately I don't have any previous experience of writing groovy scripts and only know a little bit about XPath. I am using SoapUI NG Pro 2.0. Any ideas would be greatly appreciated!7 years agoPlace ReadyAPI QuestionsReadyAPI Questions882Views0likes1Comment