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:

``console
npm install newman-reporter-csvsimple
`


For Force


`console
npm install newman-reporter-csvsimple --force

`

For npm ERR! code ERESOLVE


`console
npm install newman-reporter-csvsimple --legacy

`
OR
`console
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.

`console
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. |

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