Export variables into CSV file


Agenda: while getting the results of api if you want to save into csv file using jsr223 groovy script


Step 1:

Test data :

[{"id":"7","type":"CatItemComponent_bulkCreate","displayName":"Attribute : Upload New Items","progress":{"id":"7","status":"COMMITTING","message":"Job committing.","expectedTicks":50000,"ticks":38000},"creationTime":"2019-09-10T13:44:46.188+05:30","createdBy":"1","itemsCount":50000,"options":{"STOP_ON_WARNING":"true"},"fieldMappings":[{"sourceField":"","targetField":"Review Status"},{"sourceField":"User First Name","targetField":"User First Name"},{"sourceField":"User Lan ID","targetField":"User Lan ID"},{"sourceField":"User Last Name","targetField":"User Last Name"},{"sourceField":"Attribute Requirement","targetField":"Attribute Requirement"},{"sourceField":"DB Field Name","targetField":"DB Field Name"},{"sourceField":"Reference Number","targetField":"Reference Number"},{"sourceField":"Attribute Glossary Name","targetField":"Attribute Glossary Name"},{"sourceField":"User Email","targetField":"User Email"},{"sourceField":"Business Logic","targetField":"Business Logic"},{"sourceField":"Governance Role","targetField":"Governance Role"},{"sourceField":"Attribute Definition","targetField":"Attribute Definition"},{"sourceField":"Attribute Glossary Parent Name","targetField":"Attribute Glossary Parent Name"},{"sourceField":"Attribute Name","targetField":"Attribute Name"},{"sourceField":"Attribute System","targetField":"Attribute System"},{"sourceField":"DB Format","targetField":"DB Format"},{"sourceField":"Key","targetField":"Key"},{"sourceField":"Attribute Data Set","targetField":"Attribute Data Set"},{"sourceField":"Editability","targetField":"Editability"},{"sourceField":"Editability Role","targetField":"Editability Role"}]},{"id":"6","type":"CatalogueItem_bulkCreate","displayName":"Data Set : Upload New Items","progress":{"id":"6","status":"COMPLETED","message":"Job Completed successfully.","expectedTicks":10000},"creationTime":"2019-09-10T13:36:47.883+05:30","completedTime":"2019-09-10T13:44:36.326+05:30","createdBy":"1","itemsCount":10000,"options":{"STOP_ON_WARNING":"true"},"fieldMappings":[{"sourceField":"","targetField":"Data Set ID"},{"sourceField":"User First Name","targetField":"User First Name"},{"sourceField":"User Lan ID","targetField":"User Lan ID"},{"sourceField":"Glossary Name","targetField":"Glossary Name"},{"sourceField":"User Last Name","targetField":"User Last Name"},{"sourceField":"Lifecycle","targetField":"Lifecycle"},{"sourceField":"Data Set Name","targetField":"Data Set Name"},{"sourceField":"Reference Number","targetField":"Reference Number"},{"sourceField":"User Email","targetField":"User Email"},{"sourceField":"Governance Role","targetField":"Governance Role"},{"sourceField":"Glossary Parent Name","targetField":"Glossary Parent Name"},{"sourceField":"Data Set Definition","targetField":"Data Set Definition"},{"sourceField":"Data Set Type","targetField":"Data Set Type"},{"sourceField":"Data Set Usage Description","targetField":"Data Set Usage Description"},{"sourceField":"System Parent Name","targetField":"System Parent Name"},{"sourceField":"System Name","targetField":"System Name"}]},{"id":"5","type":"CatItemCategory_bulkCreate","displayName":"Glossary : Upload New Items","progress":{"id":"5","status":"COMPLETED","message":"Job Completed successfully.","expectedTicks":5000},"creationTime":"2019-09-10T13:33:21.689+05:30","completedTime":"2019-09-10T13:36:44.869+05:30","createdBy":"1","itemsCount":5000,"options":{"STOP_ON_WARNING":"true"},"fieldMappings":[{"sourceField":"","targetField":"Availability"},{"sourceField":"Glossary Alias Name","targetField":"Glossary Alias Name"},{"sourceField":"User First Name","targetField":"User First Name"},{"sourceField":"Glossary Definition","targetField":"Glossary Definition"},{"sourceField":"User Lan ID","targetField":"User Lan ID"},{"sourceField":"Glossary Name","targetField":"Glossary Name"},{"sourceField":"User Last Name","targetField":"User Last Name"},{"sourceField":"Lifecycle","targetField":"Lifecycle"},{"sourceField":"Parent Glossary Name","targetField":"Parent Glossary Name"},{"sourceField":"User Email","targetField":"User Email"},{"sourceField":"Business Logic","targetField":"Business Logic"},{"sourceField":"Security Classification","targetField":"Security Classification"},{"sourceField":"Governance Role","targetField":"Governance Role"},{"sourceField":"Format Type","targetField":"Format Type"},{"sourceField":"Glossary Type","targetField":"Glossary Type"},{"sourceField":"Format Description","targetField":"Format Description"},{"sourceField":"LDM Reference","targetField":"LDM Reference"},{"sourceField":"Examples","targetField":"Examples"}]},{"id":"4","type":"System_bulkCreate","displayName":"System : Upload New Items","progress":{"id":"4","status":"COMPLETED","message":"Job Completed successfully.","expectedTicks":400},"creationTime":"2019-09-10T13:33:04.751+05:30","completedTime":"2019-09-10T13:33:19.628+05:30","createdBy":"1","itemsCount":400,"options":{"STOP_ON_WARNING":"true"},"fieldMappings":[{"sourceField":"","targetField":"Availability"},{"sourceField":"User First Name","targetField":"User First Name"},{"sourceField":"User Lan ID","targetField":"User Lan ID"},{"sourceField":"User Last Name","targetField":"User Last Name"},{"sourceField":"Lifecycle","targetField":"Lifecycle"},{"sourceField":"System Type","targetField":"System Type"},{"sourceField":"System Description","targetField":"System Description"},{"sourceField":"System Long Name","targetField":"System Long Name"},{"sourceField":"System Classification","targetField":"System Classification"},{"sourceField":"User Email","targetField":"User Email"},{"sourceField":"Asset ID","targetField":"Asset ID"},{"sourceField":"System Url","targetField":"System Url"},{"sourceField":"Governance Role","targetField":"Governance Role"},{"sourceField":"External","targetField":"External"},{"sourceField":"System Name","targetField":"System Name"},{"sourceField":"Parent System Name","targetField":"Parent System Name"}]},{"id":"3","type":"InvolvedParty_bulkCreate","displayName":"People : Upload New Items","progress":{"id":"3","status":"COMPLETED","message":"Job Completed successfully.","expectedTicks":10000},"creationTime":"2019-09-10T12:58:04.739+05:30","completedTime":"2019-09-10T13:33:04.567+05:30","createdBy":"1","itemsCount":10000,"options":{"STOP_ON_WARNING":"true"},"fieldMappings":[{"sourceField":"","targetField":"Sourced From"},{"sourceField":"Description","targetField":"Description"},{"sourceField":"Email","targetField":"Email"},{"sourceField":"Lifecycle","targetField":"Lifecycle"},{"sourceField":"First Name","targetField":"First Name"},{"sourceField":"Office Telephone","targetField":"Office Telephone"},{"sourceField":"LAN Id","targetField":"LAN Id"},{"sourceField":"Profile","targetField":"Profile"},{"sourceField":"Mobile/Cell","targetField":"Mobile/Cell"},{"sourceField":"Function","targetField":"Function"},{"sourceField":"Office Location","targetField":"Office Location"},{"sourceField":"Function Description","targetField":"Function Description"},{"sourceField":"Employment Type","targetField":"Employment Type"},{"sourceField":"Org Unit Reference","targetField":"Org Unit Reference"},{"sourceField":"Last Name","targetField":"Last Name"},{"sourceField":"Internal Mail Code","targetField":"Internal Mail Code"},{"sourceField":"Password","targetField":"Password"}]},{"id":"2","type":"OrgUnit_bulkCreate","displayName":"Org. Unit : Upload New Items","progress":{"id":"2","status":"COMPLETED","message":"Job Completed successfully.","expectedTicks":100},"creationTime":"2019-09-10T12:57:51.036+05:30","completedTime":"2019-09-10T12:58:02.299+05:30","createdBy":"1","itemsCount":100,"options":{"STOP_ON_WARNING":"true"},"fieldMappings":[{"sourceField":"","targetField":"Org Unit ID"},{"sourceField":"Description","targetField":"Description"},{"sourceField":"Org Unit Name","targetField":"Org Unit Name"},{"sourceField":"Parent Org Unit Reference","targetField":"Parent Org Unit Reference"},{"sourceField":"Reference","targetField":"Reference"},{"sourceField":"Axon Status","targetField":"Axon Status"}]}]


Step 2:

capture the values from post processor




Step 3:

In jsr223 Sampler write the code like


def response= prev.getResponseMessage();


FileWriter fstream = new FileWriter("C:/Users/trinadhs/Desktop/test.csv",true);

for (i=1;i<=5;i++){

fstream.write(vars.get("type_"+i) +","+ vars.get("creationTime_"+i) +"," +vars.get("completedTime_"+i) +"\n")

}

fstream.close();

Comments

Post a Comment

Popular posts from this blog

Convert Swagger apis into jmeter script

Method #1 1. Download "openapi-generator-cli-7.9.0.jar" from https://repo1.maven.org/maven2/org/openapitools/openapi-generator-cli/ 2. get the json file from swagger 3. execute the below command in cmd prompt  java -jar openapi-generator-cli-7.9.0.jar generate -i sampleAPI.json -g jmeter  Note:  java should be  in env variables and jar be in  the same path Method #2 import to Postman and export each API with the curl command copy the curl command and Jmeter->Tools->import from cUrl-> place the command and import. Note: Manual effort and recommended for specific APIs 
Read more

Script for replace the data into the file content using groovy with jsr223

Image
import java.nio.file.* def usdcor = vars.get('TestData_name') //TestData_name was defined in userdefined or any corralted value log.info("Current Working Directory: " + System.getProperty("user.dir")) // Path to the file to be updated def filePath = "./Scripts/file.txt" // Replace with your file's path // Define the new content def newData = "This is the new content being added./\n   asdfasdfasdfasdfsadf" + usdcor try {     // Overwrite the file with the new content (clears the old data)     Files.write(Paths.get(filePath), newData.getBytes())     log.info("File content replaced successfully!") } catch (Exception e) {     log.error("Error while updating the file: " + e.getMessage()) }
Read more

Jmeter Preprocessor to add Dynamic parameters

Image
sub: one scenario need to capture the data from previous request and pass as a parameters in jmeter Problem: but key and pair both are dynamic and very huge values. we can't handle each parameter as below Note: Here Key and values both are dynamic Solution : we need to capture all the respose data and segrigate and pass through JSR223Preprocessor. Here is the solution. Step1: Step 2: Modify the request Add JSR223Preprocessor in the request //int count=Integer.parseInt(vars.get(“paths_matchNr”)) //log.info “parameters count” + count //vars.put("JsonResponse", prev.getResponseDataAsString()); import java.util.regex.Matcher; import java.util.regex.Pattern; import java.text.*; import java.util.*; //Paths Data List result= new ArrayList(); def count = Integer.parseInt(vars.get("ALLVALUES_matchNr")); log.info("count=" + count);//83 //["#31:218","#62:1","#61:1","#63:1","#31:2...
Read more