CSV download file getting 400 response code

Question

When I recorded the script for downloading a CSV file, only that HTTP request is getting a 400 response code. The audit history of the website displaying file is downloaded. When I hit the audit history download link, I get an internal server error.

Note: if I download the file with manual steps, the audit history download link is downloading the CSV file.

My payload has dynamic time stamps for file name suffix and activity Id

fileName: 
AAJCAA_5199_1312023_73446PM.pdf
activityId: 
87061

Please let me know how can I declare these parameters in the download file sampler.

Answer 1

Most probably it's a matter of correlation, i.e. these file name and activityId are somewhere in the previous responses and you need to extract them using a suitable JMeter Post-Processor and replace hard-coded values with the JMeter Variables from the Post-Processor.

In case if timestamp is the current timestamp - you can use JMeter's __time() function to generate it on the fly like:

${__time(ddMMyy-hmmssa,)}

Answer 2

To handle the dynamic time stamp and activity ID in the download file sampler in JMeter, you can use the following steps:

1. Add a Regular Expression Extractor to the request which generates the URL with dynamic values (e.g. activityId, timestamps).
2. Extract the dynamic values using Regular Expression Extractor and store them as variables.
3. Use the variables in the download file request, e.g. AAJCAA_5199_${activityId}_${timestamp}.pdf
4. Make sure to check "Use caching" option to cache the binary content.
5. Add the necessary headers and parameters in the download file request if needed.

Note: Make sure the Regular Expression Extractor is applied to the correct request and it successfully extracts the values.

---

Edit:

Ass you mentioned in the comment the file name is generated dynamically.

In this scenario, you can use a Correlation Extractor in JMeter to dynamically extract the file name from the response of the download request. Here are the steps to do this:

1. Add a Correlation Extractor to the request where the file download is initiated.
2. In the Correlation Extractor, specify the regular expression that matches the autogenerated file name in the response.
3. Store the extracted file name as a variable, e.g. fileName.
4. Use the extracted variable fileName in the file download request, e.g. ${fileName}_${activityId}_${timestamp}.pdf

Note: Make sure the Correlation Extractor is applied to the correct response and it successfully extracts the file name. You may also need to adjust the regular expression as needed to correctly match the file name.