Postman data driven testing

Postman data driven testing DEFAULT

Data-driven Testing is nothing but getting testing data from a different file. Data can be stored in different data storage applications such as Excel, notepad, Wordpad, etc. Data are not generally stored in a single format but in different formats.

Data-driven testing can be done in two different ways. One is the way to use the data from a file. And the other way is to use the data from a different request-response.

The data stored in the file can be used for different applications such as CSV, JSON, HTML, etc. To get the data from a different file, first, we have to create variables and then the data stored in the file can be referred to.

CSV file

To show the application of data-driven testing, we shall use a CSV file. A CSV file is a file that contains all the values separated by a comma(). And so the CSV is the acronym for comma-separated values. The data stored in the CSV file is easily understandable and can be easily retrieved.

Creating Global Variables

First, create global variables that can be substituted in the request URL and in the body. To create global variables first go to the manage environment icon on the top-right corner on the homepage of the POSTMAN software. And then, go to globals and input the variables.

Go to manage Environment in POSTMAN :


Then, go to globals :

Now, enter the variable names and enter the corresponding values. I have named my variables as- endpoint, email, and password.


Now, go back to the request page and then replace the endpoint values with the variable name in the URL bar. And also replace the values in the body with the appropriate variable name.

Now, save and send the request and see whether the request is generating the same response.

Now, you have seen that variables can be used in the request URL as well as in the body.

Now, we shall see how to get the same values from a CSV file. That is we shall create a CSV(Comma Separated Value) file and will have some values like: end-point, email, and password.

Now, just go to any folder or location of your computer and create a file called

Now, save the file in any location you want and reopen it in any text editor, and just put a (,) after all the values inside. This is done to indicate a CSV(comma-separated value) file. In case, not separated by a comma, there can be a format-related error at the time of running the collection.

I have used notepad++ software to open the file and edit it.

Now, to the collection runner and select the Data File Type as text/CSV file there. Also, upload the file there using the Select File button.

Now, run the collection by clicking the Run Collection button on the same page.

Now, the response, along with all the details can also be exported into any folder you want. Just click on the export button on the top-right corner of the collection runner page and export the file.

Now, the location, you selected at the time of saving, check on that location for your exported file.

Similarly, the way to import data from a file is also the same. Just write the script in a text file, save it as a file, and address the file in the collection runner.

This is how a file looks like. There are three values- endpoint, email, and password.

Now, select your file in the Collection runner window:

The report file can be exported in a similar way as we did.

Postman Interview Questions

Data cascading is nothing, but using data from one response and using it into another variable. Data cascading can be done in different ways such as- Single Level cascading, Multi-level cascading, and multiple cascading.

It is possible to get the data from one response of an API and fetch the same data into a different API. Now, let us see how you can do it.

First of all, you have to create two different requests. I shall use the same collection, and inside it, I shall create two API requests. One is the GET type and the other is a POST type. The way to create the API request is the same. Visit the same link- And select the requests.

For the first API request, select the GET: List User. Then copy the URL and also the request endpoint and then create the request. (This is your first request).

Now, paste it into the URL bar of the first request and create your first request and name it. I have named it as: .

Now, create the second request. Visit the link: And then select the PUT: Update.

Copy the URL and the request end-point and paste it into the URL bar of your second request. I have named it as: .

Now, you have created both the requests.

Now, the next step is to parameterize the value in the body section of the request. Go to the second request (update user) and navigate to the body section and then select the raw. Then select a field and replace it with a variable.

So, my original content of the body was:

And now I have to change the into .

Now, the is a variable and has to be updated as a global variable or environment variable. I shall select the environment variable.

To set an environment variable, go to the Manage environment (gear icon) in the top-right corner of the POSTMAN interface or create a new environment by clicking on the New button.

Now, click on the send button and see the output. As you can see below, the name which earlier is now changed to

Fetching data from API Response

Now, to fetch the data from the API response, navigate to the first API response. And go to the Tests option. And edit the below code there:

The data[3].first_name is the path of the first name. So, to get the path, visit: and then paste the response test into the editor of the website and then navigate into the right-side of the same page to get the path:

Now, paste it into the json Path finder.

Now, click into data, of the attributes and the corresponding path will be available above in the path bar. Then copy the path.

Now, also you can set variables as Global Variables. As there are different snippets available into the POSTMAN interface itself, you can use it simply and write the code for Global Variable.

Now edit the below code into the Text section of your second API request:

After that, save it, and click on the send button. And now check into your current environment, whether the variable has automatically taken the value:

So, in the above image, it is visible that the variable username01 has been initialized with the value . And so the current value is also the same for the variable.

Create both the request in the same environment, and try to execute the same under the same environment.


Postman Tutorial - Command Line & Data Driven Testing

How to Do API Testing?

Nowadays API testing is an integral part of testing. There are a lot of tools like postman, insomnia, etc. There are many articles that ask what is API, What is API testing, but the problem is How to do API testing? What I need to validate.

Note: In this article, I am going to use postman assertions for all the examples since it is the most popular tool. But this article is not intended only for the postman tool.

Let’s directly jump to the topic.

Let’s consider you have an API endpoint example{{username}} when you send the get request to that URL it returns the JSON response.

My API endpoint is{{username}}

The response is in JSON format like below


In the JSON we can see there are properties and associated values.

Now, For example, if we need details of the user with the username ‘ganeshhegde’ we need to send a **GET **request to ** **

Now there are two scenarios.

1. Valid Usecase: User is available in the database and it returns user details with status code 200

2. Invalid Usecase: User is Unavailable/Invalid user in this case it returns status with code 404 with not found message.

#tutorial #performance #api #test automation #api testing #testing and qa #application programming interface #testing as a service #testing tutorial #api test

  1. Gumball machine jar
  2. Kind bars mini costco
  3. 1 4 bunny figure

API Testing 'A Beginners View': Data-driven testing in Postman

Hi Everyone!!! Let’s check out some details about Data-Driven Testing with Postman using CSV and JSON files😊

Data-driven testing can be a very effective approach in testing an API against different data-sets. Postman supports CSV and JSON files to get data for the test scripts. The data-driven approach is useful when we need to execute a test with multiple sets of Data. Also, modifying or adding any data fields will just need updating the data files which is easier than going to test script and updating test data.

To explain the same I’ll use a sample request which I use in my daily work.

Steps to do this:-

  1. Now, in this example, I want to refer Row_No, UCI_Number, and Entity_ID from a CSV file. So, as a pre-requisite, we need to define these in a variable. In order to do so in the Pre-request Script tab we need to set the variables as in the screenshot, so that going ahead values will be read from variables.
  2. Create a CSV file having these variables and values.
  3. Now go to Collection Runner, and import this data file and click on the Run button.Data File Preview:

After hitting on the run:

Run can be stopped any time of execution:

With JSON data file: Now, let us do the same thing with the JSON file. Create a new JSON file, and in Collection, Runner uses this JSON file.

Sample JSON File:

After a run of a JSON data file:

That’s it, and now we have some insight into the Data-Driven Testing with Postman using CSV and JSON files.

Some interesting yet important notes related to the Data-Driven approach:

Note: We can randomly retrieve data from CSV data files in a data-driven approach.

The Approach to Note: Recently in my daily work had a scenario, wherein I had to randomly fetch data from the CSV data file and perform my test. Then found a way out to solve it. Here is what I did! The explanation is below:

  • In Pre-request I fetched the total records and used in the Test script to do my testing

//Finding the total number of iterations that are scheduled to run since Total number of iterations === Number of rows in your CSV File

var list =;


pm.environment.set(“Total_Records”, list);

  • In Test script I checked the modulo value and did the tests as needed >> IF ($rownumber%(square root of the total number of records in file))=0 {do you test} else {postman.setNextRequest(null);}

Hope this article was interesting. Let me know if this was helpful.

Can check the same article on my Personal BLOG too…

Happy Learning :innocent:

1 Like


Data Driven Testing In Postman

In the previous articles on Postman Tutorial, we have covered “JSON Schema Validation in Postman“

In this “Data-Driven Testing in Postman” article, I will be demonstrating how you can implement this concept and get a tight grip over this.

Data-driven testing is when we have one test that we run multiple times with different data variables. It’s useful for things like, if we have a certain range of characters that we’re supporting in our names, to make sure that all those characters are supported in different tests.

Let the body of API be:

Postman Data Driven Testing





Add tests in Tests tab:

Postman Data Driven Testing



















pm.test("Status code is 201",function(){;




pm.test("Check email "+em,function(){




pm.test("Check password "+pwd,function(){




Using CSV file:

1. Create a CSV file.
2. Add email, password in columns of CSV file
3. Add possible test cases of email and password.

Postman Data Driven CSV File

4. Create a collection named Data-driven test
5. To get variable from CSV file, run this collection on Runner, click Run button

Postman Data Driven Test

6. Collection Runner window will appear.

Postman Run Data Driven Test

7. Iterations are the no. of data rows in CSV file
8. Add CSV file in the Data option. Preview button will display the preview of CSV file
9. Click on Run button in blue color
10. Result window will be displayed

Postman Run Data Driven Test Result

Using JSON file:

1. Create a JSON file.
2. Add email, password in JSON file separated by a comma
3. Add possible test cases of email and password.

Postman Data Driven Using JSon

4. Create a collection named Data-driven test.
5. To get variable from JSON file, run this collection on Runner, click Run button

Postman Data Driven Using JSon File Collection

6. Collection Runner window will appear.

Postman Data Driven Using JSon File Collection Runner

7. Iterations are the no. of data rows in JSON file.
8. Add JSON file in the Data option. The preview button will display the preview of JSON file.
9. Click on the Run button in blue color.
10. The Result window will be displayed.

Postman Data Driven Using JSon File Result

Next steps:

Learn “Monitor Collections in Postman” in the next tutorial.

Related posts:


Data testing postman driven

Hello Folks,

We have already seen How to read data from a json file in Postman.

In previous post, we have learnt Achieving Data driven testing using CSV in Postman. I will strongly recommended to go through above two links to understand about Data driven testing of API.

Instead of CSV , we will use JSON to achieve Data Driven testing in Postman.

Creating a JSON file for Postman:-

We need to create a JSON file in specific format so that Postman can read it. It must be a JSON Array of JSON Objects and each JSON Object will be treated as a new data set for execution of an API. If JSON Array consists of five JSON Objects, API will be executed five times with provided set of data one after another in sequence. An example is below:-

MultipleDataForHotelBooking.json :-

Note:- A JSON Array may contains single JSON Object as well as we did in
How to read data from a json file in Postman.

If you compare with csv of post Achieving Data driven testing using CSV in Postman , you can relate that each row of csv (except first row ) as an individual JSON Object.

Now there are similar steps as in Achieving Data driven testing using CSV in Postman . You just need to run API using collection runner and select the JSON file in Data section.

Run the collection, you will see three iteration have run with different data.

Data for iteration 1:-

Data for iteration 2:-

Data for iteration 3:-

You can import example collection from here:-


You can find all Selenium related post here.
You can find all API manual and automation related posts here.
You can find frequently asked Java Programs here.

Author: Amod Mahajan

My name is Amod Mahajan and I am an IT employee with 6+ years of experience in Software testing and staying in Bengaluru. My area of interest is Automation testing. I started from basics and went through so many selenium tutorials. Thanks to Mukesh Otwani as his tutorials are easy and cover basics to advance. I have habit of exploring concepts by deep diving. I used to make notes. I thought of sharing my knowledge through posts and now I am here. #KeepLearning #ShareLearning

Like this:



Tagged as: api automation in postmanData Driven Testing in Postman Using JSON Filepostman tutorialsSkip back to main navigationSours:
API Testing with Postman : Using Postman for Data Driven Testing -

First think, maybe you would like to. Do you want he finally realized my answer. - Yes, I confirmed my desire. What a handsome man he is, it is a pleasure to look at him. - Hurrah.

You will also like:

You were recommended to me as a specialist who can fix the leak. The man carefully examined the lady's heavily made-up face. Slanting eyes are summed up with greenish shadows. The brightly colored lips felt swollen, as if from prolonged kisses.

21087 21088 21089 21090 21091