Newman Reporter CSV

Simple CSV Reporter Akash Dilwale

About

The outputted CSV file with the following Table:

| iteration | collectionName | requestName | testCaseName | url | status | code | responseTime | result | assertionErrorMessage | | --------- | ------------------ | ------------------ | -------------------------------------- | -------------------------------- | ------ | ---- | ------------ | ------ | ----------------------------------- | | 1 | Api_Excel_O/p_Prod | GetUser-Iterations | Id: 1 Response time is less than 200ms | https://reqres.in/api/users/1 | OK | 200 | 781 | Fail | expected 781 to be below 200 | | 1 | Api_Excel_O/p_Prod | GetUser-Iterations | Id: 1 Status code is 200 | https://reqres.in/api/users/1 | OK | 200 | 781 | Pass | | | 1 | Api_Excel_O/p_Prod | GetUser-Iterations | George First name Checking | https://reqres.in/api/users/1 | OK | 200 | 781 | Pass | | | 1 | Api_Excel_O/p_Prod | GoogleApi | 1Status code is 200 | https://script.google.com/ | OK | 200 | 3075 | Pass | | | 1 | Api_Excel_O/p_Prod | GoogleApi | 1Response time is less than 200ms | https://script.google.com/ | OK | 200 | 3075 | Fail | expected 3075 to be below 200 | | 2 | Api_Excel_O/p_Prod | GetUser-Iterations | Id: 7 Response time is less than 200ms | https://reqres.in/api/users/7 | OK | 200 | 156 | Pass | | | 2 | Api_Excel_O/p_Prod | GetUser-Iterations | Id: 7 Status code is 200 | https://reqres.in/api/users/7 | OK | 200 | 156 | Pass | | | 2 | Api_Excel_O/p_Prod | GetUser-Iterations | Akash First name Checking | https://reqres.in/api/users/7 | OK | 200 | 156 | Fail | expected 'Michael' to equal 'Akash' | | 2 | Api_Excel_O/p_Prod | GoogleApi | 7Status code is 200 | https://script.google.com/ | OK | 200 | 2446 | Pass | | | 2 | Api_Excel_O/p_Prod | GoogleApi | 7Response time is less than 200ms | https://script.google.com/ | OK | 200 | 2446 | Fail | expected 2446 to be below 200 |

Install this package:

npm install newman-reporter-csvsimple

For Force

npm install newman-reporter-csvsimple --force

For npm ERR! code ERESOLVE

npm install newman-reporter-csvsimple --legacy

OR

npm install newman-reporter-csvsimple --legacy-peer-deps

Usage

You can then use the -r csvsimple option to make Newman use the CSV Simple reporter.

node_modules/.bin/newman run postman_collection.json -e postman_environment.json -r csvsimple

Options

| CLI Option | Description | | ------ | ------ | | --reporter-csvsimple-export | Specify a path where the output CSV file will be written to disk. If not specified, the file will be written to newman/ in the current working directory. | | --reporter-csvsimple-includeBody | If you wish to save the response body for each request, use this option. |

node_modules/.bin/newman run postman_collection.json -e postman_environment.json -r csvsimple --reporter-csvsimple-includeBody