Can Data Driven .xlsx file values be used without a field value to match on?

book

Article ID: 74916

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction

How the Data-driven matching will happen when Excel or CSV file has more columns than what the request data has in a transaction.

Can Data Driven .xlsx file values be used in VSI response without a field value to match on in the request?

Environment

DevTest 10.x versions

Resolution

Yes. For example, you have 4 Request data arguments and you have 6 columns in Excel file. The request matching is going to happen on all the Request data arguments and the corresponding 2 columns which were not mapped with Request data but these can be used in your VSI response. 

Note:
Excel file can have as many columns as it can but all the Request Data Arguments in a transaction need to be mapped to the Excel data. For example, if a transaction has 5 Request Data Arguments then all the arguments need to be mapped to the Excel Data. Mapping 1/2/3/4 will return No Match.

Additional Information

. https://docops.ca.com/devtest-solutions/10-1/en/using/using-ca-service-virtualization/using-devtest-portal-with-ca-service-virtualization/create-data-driven-virtual-services#CreateData-DrivenVirtualServices-MapResponsetoDataSetColumns.
. https://docops.ca.com/devtest-solutions/10-1/en/reference/data-set-descriptions/read-rows-from-a-delimited-data-file-data-set 
. https://docops.ca.com/devtest-solutions/10-1/en/reference/data-set-descriptions/read-rows-from-excel-file-data-set. 
. https://docops.ca.com/devtest-solutions/10-1/en/reference/data-set-descriptions/create-your-own-set-of-large-data-data-set.