How to download CSV file in Jmeter Scripting

0
votes

[Jmeter has recorded only these(Please check the request in attached screenshot) parameters for downloading the csv from application to the local machine. But when i execute the script the file does not get download on my local.

There are no parameters in FileUpload tab as well.

Please help me out to record this request. Also let me know if any more info is needed to analyse the scenario] 1

CSV gets downloaded on local on clicking the highlighted link

This is the request and response headers recieved. .....................................................................

Save response to file listener Screenshotpng

BeanShell Code to delete file screenshot png

I am stuck with the attached error in the jmeter log png

2
jmeterexport-to-csvmimebeanshell

2 Answers

0
votes

In your request there are at least 2 parameter's i.e. rid and pageQs which needs to be co-related. Record and replay mostly never work and you need to co-relate the dynamic parameters. First, identify where there are getting generated then capture it and pass it to the subsequent request.

Try to record the request 2 times using a sniffing tool like Fiddler or Wireshark. Compare and check what values are changing in the request.

I hope it helps.

0
votes

JMeter will not "download" anything unless you explicitly "tell" it to store the response using i.e. Save Responses to a file listener. Add it as a child of the HTTP Request sampler which is supposed to download the file and configure like:

  • Filename prefix: anything meaningful, i.e. foo.csv
  • Tick Don't add number to prefix

  • Tick Don't add suffix

    JMeter Save Responses to a file configuration

Once you do this and run your test JMeter will save the response as foo.csv file in "bin" folder of your JMeter installation. See Performance Testing: Upload and Download Scenarios with Apache JMeter article for comprehensive information on properly simulating file uploads and downloads using JMeter.