How to save String from json response to excel or csv file?

Hello Everyone Here,

I am facing an issue related to saving String value from response body directly to csv file, actually I don’t know how to write a specific value from response body to csv/excel directly.

My test script reads values from csv file and then compare with values in response body. Now I want to save some required string/int/any format values from response body and save directly in the same csv file/or in another sheet of same file.

I can save required info into global/environmental variable and then export it but issue is same script will execute multiple time for different data as per iteration. lets say same script run three time, variable will have result of last iteration but I want to save required string of each iteration either in variable or csv file.

I found this but it doesn’t help me
https://documenter.getpostman.com/view/3407886/RWgp1fB5?version=latest#f0f97744-0413-4bcf-b4e4-7c85939c5a7f.

Any help or guidelines highly appreciated.

Thanks in advance

You can’t just write to a CSV file from Postman.

The only approach would be using Node.js and Newman, with something like this: