Author : Ashish Tiwari
Performance test data ensures, how well our performance test simulates the real-world users. As a performance tester, one of the major challenges we face is getting the huge amount data.
Suppose the data you need is present in azure tables and you want to extract specific data that you are interested in. This blog will tell you how you can make connection and query azure tables using JMeter.
Tools Used:
We can easily query JMeter using Rest API (Please refer to this link for query Syntax). The below URL will filter the table results based on partition key.
In JMeter, Put the following header in JMeter HTTP Header Manager.
Header:
Accept: application/json
And URL in the HTTP Request.
URL:
https://<StorageName>.table.core.windows.net/<TableName> - This part of URL we can get easily from Microsoft Azure Storage Explorer (Environment > Storage Account > Table Name). Please refer to the Screenshot below
Now, after getting the response we can extract the response according to our need. In my case, I have extracted the desired fields from the response and made the CSV file out of it. And, I have used that CSV to do the Load Testing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.