AnsweredAssumed Answered

How to write simple math script for getting dynamic values in LISA

Question asked by MukulJain on Jul 30, 2015
Latest reply on Aug 26, 2015 by salman.jarved

Like • Show 0 Likes0
Comment • 10

Hi,

I am trying to give dynamical values in webservices component using LISA.

Example request/response SOAP message :-

< soap:Envelope>

< soap:Body>

< ns1:Request>

< ns1:field1>1000</ns1:field1>

< /ns1:Request>

< /soap:Body>

< /soap:Envelope>

Response-->

< soap:Envelope>

< soap:Body>

< ns1:Response>

< ns1:field1>state1</ns1:field1>

< ns1:field2>country1</ns1:field2>

< /ns1:Response>

< /soap:Body>

< /soap:Envelope>

What we want is based on Request field1 value response should be generated as field1, field2

Say for example,

if Request field1 is 2000

then Response field1 should be

state2

country2

We use excel sheet to maintain this request response data because it is a small data no need of database. Is there any way to do it using scripting?

No one else has this question

Outcomes

10 Replies

sdetweil2 Jul 30, 2015 11:09 AM
Mark Correct
Correct Answer
I'm not sure I understand completely, but this should be pretty easy overall..

1. change the response message description to use a property value {{=someproperty}} instead of a hard coded value 'state1'
2. create a script step, or use a script data protocol handler ( attached to some step). the script steps can do just about anything. it will set the property, based on your algorithm
you might be able to read the data into memory and work from there. the {{= will allow you to put some java code in place of the property name, so u might no need a script at all)

I use script step and apache poi classes to read excel (xlsx) sheets which contain request and response data (JSON), but its just fields.

I am using DevTest V8.1, but I don't see that much different back on 7.5.2
Like • Show 0 Likes0
Actions
- MukulJain @ sdetweil2 on Jul 31, 2015 10:28 AM
  Mark Correct
  Correct Answer
  Thank you for the information, i will try to use this solution and come back if i got any queries
  Like • Show 0 Likes0
  Actions
IamAbhi Jul 30, 2015 2:34 PM
Mark Correct
Correct Answer
Hi Mukul,

Is the above related to the Virtual service? Please elaborate the question in brief.

Thanks,
Abhishek.
Like • Show 0 Likes0
Actions
JayantChatterjee62134974 Jul 30, 2015 3:01 PM
Mark Correct
Correct Answer
Best solution depends on how many values of field1 do you have, and how frequently those values in your excel sheet change. Here are two non-coding solutions.

Case 1 - You have max 15-20 field1 values and the corresponding state, country does not change
In VSI - For each field, add another image inside the transaction, and keep the corresponding response. In the request data tab, for first image set field1 = 1000, for second image field2 = 2000. so it would be like this

field 1 = 1000 response xml for state1, country1
field 2 = 2000 response xml for state2, country2 and so on

Case 2 - Assuming you have a lot of field1 values and you keep changing the state and country frequently
1. In Listen step, add a request data copier to copy the field1 value to a parameter, lets say Request_StateCode.
2. Before Image Response Selection step, add a "Do Nothing" Step. In this add a "Create Your Own Datasheet" with 3 columns (StateCode, state1, country1). Add all your values in this datasheet. (If you have a lot of values you can "Read from excel" sheet instead of your own datasheet, but since it would be File read the service would be slower). At end of dataset - start over (but this may result in infinite lop if state code does not match).
3. Now in this step, add an assertion if StateCode1 matches Request_StateCode. if assertion true - go to Image Response Selection, else go back to DoNothing Step. This way, it would loop till it finds the State1, country1 values for the state code.
4. In VSI, in the response message parameterize the field1, field2 values to {{state1}} and {{country1}}

I am currently not delving into the scenario where you send state code which is not in the list. Try this solution for now. Can be improved if required.
Like • Show 0 Likes0
Actions
- sdetweil2 @ JayantChatterjee62134974 on Jul 30, 2015 5:51 PM
  Mark Correct
  Correct Answer
  I read your answer, but don't understand the words, and the online help doesn't..
  
  what is the behavior of a 'data sheet' (which is not found in the online help, while 'Data sheet' does get some results).
  
  there is no description on data sets either that describes what the behavior is..
  
  is this 'return 1 row' for each invocation? (by default) I 'assume' this is the behavior cause your step 3 says 'loop'
  I 'assume' changing number of rows supposedly would make this different'
  what is the layout of a 'row'? csv style?
  
  I find this part of the product help mind numbing.
  Like • Show 0 Likes0
  Actions
  - JayantChatterjee62134974 @ sdetweil2 on Jul 30, 2015 6:10 PM
    Mark Correct
    Correct Answer
    DataSet - can be an excel sheet, rows from DB query, your own data sheet (a table)
    
    It would read rows like in CSV. The top header in an excel row would become a property, each row after that is a value. For each invocation one row would be read. When called next time, it would read the next row.
    
    The reason I have mentioned "Create Your Own Datasheet" is because if the number of rows is less, you can keep the values in memory instead of reading an external file (Excel Sheet).
    Like • Show 1 Like1
    Actions
    - sdetweil2 @ JayantChatterjee62134974 on Jul 30, 2015 6:15 PM
      Mark Correct
      Correct Answer
      thanks.. would be nice if the doc said that
      Like • Show 0 Likes0
      Actions
      - LizR @ sdetweil2 on Jul 30, 2015 7:29 PM
        Mark Correct
        Correct Answer
        Hi sdetweil2 - I will share your feedback with our documentation team.
        
        For reference, data sets are covered in the following web-based trainings:
        OnDemand DevTest Solutions 8: Foundations 200
        OnDemand CA Application Test 8: Foundations 200
        Like • Show 0 Likes0
        Actions
        sdetweil2 @ LizR on Jul 31, 2015 12:39 AM
        Mark Correct
        Correct Answer
        Great!.. thanks for the feedback and info on Education!
        Like • Show 1 Like1
        Actions
salman.jarved Aug 26, 2015 12:31 PM
Mark Correct
Correct Answer
MukulJain,
See sample project for your reference to build the required logic.

Change the filter's xPath according to your request payload, defined in VSM "Virtual HTTPS Listener 8001" Step called {{req_field1}}
See the match script of Exact transaction under VSI that has the custom logic required to build a dynamic response. You can change the code and make it more dynamic while replacing hard-coded values with properties.

Let me know if it works well for you.
Attachments
- SampleProject.zip4.5 KB
Like • Show 0 Likes0
Actions

How to write simple math script for getting dynamic values in LISA

Outcomes

Attachments

Related Content

Recommended Content