Postman Tutorial - Run API Request multiple times with different Data Sets using external JSON file

Learn how to use external data files like CSV and JSON files to run API request multiple times with different data sets.
Postman allows us to use external data files in Collection Runner to run API Requests in multiple iterations by using the data variables. We can select a JSON or CSV data file in Collection Runner. The data file will contain different variables with multiple values which in turn can be used within the API Requests or API Tests.
Found this video interesting - Please Like and Share the video.
Have Feedback/Questions - Leave a comment below.
Subscribe our RUclips Channel - / @qascript
Get access to 100 plus videos on different automation tools. Also never miss out on any new video posted on our channel.
Other Video Playlists on our Channel:
Selenium:
• Selenium Webdriver Aut...
Jenkins 2.0:
• Jenkins 2.0 & DevOps: ...
Maven:
• Mastering Maven and Co...
Blog Site: qascript.com

[@MrSalFav]

Very useful indeed. Thank you so much

[@QASCRIPT]

You are welcome!

[@user-mn1ty2ww2q]

Very Detailed. Most of other videos doesn't shows that we need to add Variables in Header.

[@QASCRIPT]

Thank You

[@johnsamuel6096]

Thanks a bunch. Yer a lifesaver.

[@QASCRIPT]

Glad it helped

[@9ankurbishnoi]

Thank you so much for this video.. I was trying to find this particular solution from quite a long time now but was unable to find it.

[@QASCRIPT]

Glad it was helpful

[@delinraj4394]

Thanks a lot bro

[@QASCRIPT]

Happy to help

[@mateussudbrack4006]

currently fav vid. fucking lov u for this. just used it at my job

[@QASCRIPT]

Glad it was helpful for you.

[@himanshumishra2053]

Great

[@QASCRIPT]

Thanks

[@CyberConnect0116]

its really fruitfull but can you share one video by .csv how we put mupltiple values

[@QASCRIPT]

Sure. Will try to create it soon.

[@harishkce1989]

Quick question : what if my collection has multiple request eg :5-10 request and if we upload a csv file as test data file ...is it applicable to use the test data value in all the multiple requests ? how does the iteration works ?

[@QASCRIPT]

Yes. If all your requests are using any values from the test data file then they will be iterated for all the rows of data.

[@foodfedyumm]

If we have different api request within same collection with different data .In that case how csv file should be designed .

[@QASCRIPT]

Ideally your collection should contain similar requests which uses the same data. You should create another collection for different requests.

[@aktar749]

when you run your test cases from collection runner,without selecting environmetn,your test should fail but they pass. mine failed and I selected weather api environment and they all passed. ???

[@QASCRIPT]

In this particular case I am not using any environment variables and hence the test passes. I am only passing data from an external file in collection runner.

[@WeinsteinPlayfair]

Runner is in the lower-right of the screen now, fwiw.

[@QASCRIPT]

Thanks for sharing