Get request data from Excel for VS request and throw corresponding response

[lisa_user1]

Hello All,

 

I have got DevTest 9.1. Could anyone please guide me on how to implement the approach, where i want to take the multiple request parameters from the excel and after matching, throw the response XML, in the corresponding row of the same excel?

 

Earlier I had DevTest 8.4 version with which this could not be achieved.

Please refer the below thread:

https://communities.ca.com/thread/241753107

 

Please suggest.

 

Regards,

Aman Saeed

[Legacy User]

Here are some places to look to get you started:

Data-Driven Virtual Services - DevTest Solutions - 9.1 - CA Technologies Documentation 

Examples of Data-Driven Virtual Services - DevTest Solutions - 9.1 - CA Technologies Documentation

Performance Tuning of Data-Driven Virtual Services - DevTest Solutions - 9.1 - CA Technologies Documentation

 

From DevTest Portal, you can open a sample service that demonstrates DDVS.  The LISA_HOME/Projects/Bank_v5 and Bank_v6 directories contain sample projects.   The Bank_v5 shows a REST example and Bank_v6 shows a SOAP/HTTP example.   There is a test case in the Tests directory that will execute the service so you can see how it operates.

 

EDIT: 

There is a Data directory in the LH/Projects/Bank_v5 or v6 project that contains the Excel spreadsheet that is consumed by the service.  One thing to consider is that your dataset columns are expected to match the request argument list.  So far as I know, there is no concept of excluding an incoming request argument value during the look up query.  In other words, if your incoming request has 10 arguments on the signature, the spreadsheet is expected to have 10 columns (1 corresponding to each argument) to support the query.  Within 9.1, there are no configurations that allow one to specify which arguments to use when creating the select query.  All of them are used; therefore, you may need to use other DPHs like RDM if you need variation.

[lisa_user1]

Hi J_NeSmith,

 

Thanks for sharing the info. However i couldn't find the step where we are providing the path for the excel to be used.

Could you please let know where/at which step in VSM are we mentioning the path for the excel.

 

Regards,

Aman Saeed

[Legacy User]

The pointer to the DDVS dataset is actually buried in the VSI.  So, technically, the step is the VSI Selection Step.  But, the dataset is not actually "inside" the VSM. 

 

You may get an error when opening the DDVS VSM within Workstation. This seems to be because the dataset does not always resolve correctly within Workstation.  It should not affect your ability to open the VSM. 

 

However, you will not see the dataset exposed as a property.

[lisa_user1]

Hi J_NeSmith,

 

I tried implementing this DDM approach. However I am facing several issues listed below.

 

1) Unable to see the list of request tags (mentioned in the excel) & the response, in the drop down in the DevTest console. --> Image 2 & 3

2) Excel (.xlsx) file is getting corrupted if I am trying to edit and upload the same file again. --> Image 1

 

Please advice.

 

Regards,

Aman Saeed.

[Legacy User]

When using the DDVS service generated from within the portal, each argument on the incoming request is considered a matching element (column in your dataset).  The where clause that is constructed is similar to WHERE this = *** AND that = yyy and so on.

In terms of editing the Excel spreadsheet, I have not seen the file become corrupted.  I am not saying it cannot happen.  I simply have not seen that scenario.

[lisa_user1]

Hi Joel, Thanks for your valuable guidance. However, i am still not able to see the options in the drop down for matching, after importing the excel. I would try to give this a spin and let you know in case I face any issues. Thanks!!! Regards, Aman Saeed

[Anon Anon]

Hi ,

 

can anyone please help me to implement the same which (Aman had mentioned" using DevTest Workstation instead of portal.

 

With regards,

 

Akshay A

[Legacy User]

From what I have learnt, You will need to script it in your .vsi file under "match script" for that particular R/R pairing. 

[Legacy User]

You can find Data Driven Virtualization jar file in community or ask CA team to provide.Jar files provide custom step to make connection with external Data Source (Excel/Database). You can use that object in your match script to create property with external source values and use those in your response.

 

Do let me know , if you need any help with Match Script.

 

Regards,

-Ankush Sharma

[Legacy User]

You can also check this thread .

 

https://communities.ca.com/message/241830530?commentID=241830530#comment-241830530