Can we read data from excel in postman for js tests?

javascript postman newman
Shubham Jain picture Shubham Jain · Jun 15, 2017 · Viewed 7.2k times · Source

Can we read data from excel in postman for js tests? OR can we write a js script which read data from excel/csv/notepad.

I have wrote some js script which automate my API tests. I am using Newman to execute them from command prompt.

I am writing automated test in postman. I want to import data from excel for my tests. Is it possible? There is any plug-in or anything present which can help me to achieve same

I have a thought that using js I try to write a code which directly read/interacts file like excel/csv/notepad. Is it possible?

Any help would be appreciated

Answer

Pratik Mandrekar picture Pratik Mandrekar · Jun 15, 2017

You can if you export your excel to csv and the format is similar to this file.

You can also do this with newman using -d <source>, --iteration-data <source>.

Specify a data source file (CSV) to be used for iteration as a path to a file or as a URL. Working with data files.

If you want to use Postman app, you can use the Collection Runner -

The Collection Runner let’s you import a CSV or a JSON file and then use the values from the data file inside HTTP requests and scripts. We call these variables data variables. To use them inside the Postman UI, you have to follow the same syntax as environment or global variables. Having the same syntax helps you test individual requests inside Postman using dummy environment values. When you move to the Collection Runner you don't have to change anything.

More on the blog here.

Related questions

how Postman send requests? ajax, same origin policy

I have found this very useful Chrome extension called Postman. This is a very useful extension especially when you are into programming RESTful applications. One thing I am confused on is that how this plugin/extension able to send POST …

Read More
How to run one request from another using Pre-request Script in Postman

I'm trying to send an authenticated request with one click in postman. So, I have request named "Oauth" and I'm using Tests to store the token in a local variable. var jsonData = JSON.parse(responseBody); postman.setEnvironmentVariable("token", jsonData.access_…

Read More
Counting records in JSON array using javascript and Postman

I have a control that returns 2 records: { "value": [ { "ID": 5, "Pupil": 1900031265, "Offer": false, }, { "ID": 8, "Pupil": 1900035302, "Offer": false, "OfferDetail": "" } ] } I need to test via Postman, that I have 2 records returned. I've tried various methods I've found here and elsewhere but with no …

Read More