Load Testing - How to bind excel sheet with Get method

2 posts, 0 answers
  1. Sadeep
    Sadeep avatar
    1 posts
    Member since:
    Oct 2012

    Posted 12 Nov 2012 Link to this post


    My requirement is like this. I nee to send some values through url and check the web service. I could bind excel sheet and send multiples urls as mentioned in the automation project.ex;- http://localhost:8096/Search.svc/63  and http://localhost:8096/Search.svc/64. So I need to create automation and load testing projects separately for this. I have successfully done the automation project for my requirement. Basically what I have done, was I recorded navigation url point in the automation project and bind the excel sheet with multiple values as screen shot 01. But this is not practical in load testing project. Get method is the only recorded field in the load testing project so we can't bind excel sheet for the load testing project as screen shot 02.So I have some queries on load testing project. Those are as follows.

    01. How to bind excel sheet for the Get method in Load testing project. Refer screen shot 02. Please do not send the following link.Cause  I know how to bind excel sheet for the load testing project with post method.

    02. How to Read excel sheet through C# code..?? Simply how to take particular raw value of the excel sheet for the automation project and load testing project..?? Please send the code for us in Telerik and guide lines.

    03. how to pass parameters through url in automation and load testing projects.


  2. Stoich
    Stoich avatar
    1 posts

    Posted 14 Nov 2012 Link to this post

    Hello Sadeep,
    thank you for choosing to evaluate Test Studio. I will try to answer your question as best as I can.

    1) there's no limitation that you can only data-driven post request. Load testing allow you to data-drive all HTTP requests that have query strings associated with them. It's irrelevant whether they are Get or Post requests. So perhaps you're simply looking at the wrong HTTP request. Sometimes it takes quite a bit to find what you're looking for. I've had cases we're I've had to go through 80 requests to find the one that's sending the user/pass to my Login screen

    2) We have several articles have code samples related to accessing Excel in code. For instance check out this article:

    You can use code to define your own data-source by overriding the OnInitializeDataSource function:

    Some of our customers have done this successfully in the past. Let me know if you require additional assistance.

    3) Could you give me some additional details on what you're trying to do. Generally, you're allow to customize the way Load testing works by writing your own custom plugin:

    I hope this helps.

    the Telerik team
    Are you enjoying Test Studio? We’d appreciate your vote in the ATI automation awards.
    Vote now
Back to Top