This is a migrated thread and some comments may be shown as answers.

Load Testing - How to bind excel sheet with Get method

1 Answer 147 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Sadeep
Top achievements
Rank 1
Sadeep asked on 12 Nov 2012, 11:20 AM
Hi..

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.
(http://www.telerik.com/automated-testing-tools/support/documentation/user-guide/data-driven-testing/add-a-data-source.aspx)

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.

Thanks..

1 Answer, 1 is accepted

Sort by
0
Stoich
Telerik team
answered on 14 Nov 2012, 03:12 PM
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:
http://www.telerik.com/automated-testing-tools/support/documentation/user-guide/code-samples/general/external-log-file.aspx

You can use code to define your own data-source by overriding the OnInitializeDataSource function:
http://www.telerik.com/automated-testing-tools/support/documentation/user-guide/code-samples/general/execution-extensions.aspx

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:
http://www.telerik.com/automated-testing-tools/blog/stoil-stoichev/12-11-14/extending-load-testing-with-a-custom-plugin.aspx

I hope this helps.

Regards,
Stoich
the Telerik team
Are you enjoying Test Studio? We’d appreciate your vote in the ATI automation awards.
Vote now
Tags
General Discussions
Asked by
Sadeep
Top achievements
Rank 1
Answers by
Stoich
Telerik team
Share this question
or