Postman Beginner Tutorial 13 | Data Driven Testing | How to get data from CSV and JSON files

Data Driven Testing
How to get data from CSV file
How to get data from JSON file
How to run Data Driven API requests
How to run Data Driven tests
Useful Tips

Step 1 - Create a api request
Step 2 - Create variables and refer in request
Step 3 - Goto Run Collection
Step 4 - Create a CSV file and add data - Refer this file in Run Collection
Step 5 - Create a JSON file and add data - Refer this file in Run Collection
Step 6 - Refer data in test scripts

#PostmanDataDrivenTesting
____________________________________________________________

Every LIKE & SUBSCRIPTION gives me great motivation to keep working for you

You can support my mission for education by sharing this knowledge and helping as many people as you can

If my work has helped you, consider helping any animal near you, in any way you can.

________ ONLINE COURSES TO LEARN ________

------------ UI TESTING ------------

------------ API TESTING ------------

------------ MOBILE TESTING ------------

------------ CI | CD | DEVOPS ------------

-------------VIRTUALISATION-------------
------------ VERSION CONTROL SYSTEM ------------

------------ PERFORMANCE TESTING ------------

------------ PROGRAMMING ------------

------------ IDE ------------

------------ BUILD TOOLS ------------

------------ OTHERS ------------

----------- Connect with Raghav ------------

Never Stop Learning
Raghav

[michaelmendoza]

Excellent, clear, easy to understand, and follow instructions. This is an amazing Postman learning resource! Thank You Raghav.

[svetlanamazhaykina]

Thanks for your work, Raghav! Well done!

[sabhyatasaxena]

Really, your teaching way is so simple and by watching your videos, everything cleared... Thanks

[amarnath]

Thanks for your time and contribution Raghav.

[ameyadani]

Excellent session, thanks a lot raghav!

[rangaswamy]

Thank you so much for sharing your valuable knowledge raghav

[hfevrol]

Thank you for sharing details .This is really helpful

[junnamma]

Thank you so much it's very usefull

[nidhidani]

@Raghav, In my collection there are multiple requests. Some if them need to be tested with multiple sets if data. In this case, should I create multiple csv files (for the required requests)? How to specify those files while execution of collection with newman?

[aravapallimanikanta]

Hi Raghav,
Tutorial is helpful, I have question if I want to check multiple status codes & responses for single API by using the above way
How to do it?

[janyam]

Hi Raghav, i did the same exact thing you did, except I used url environment variable also, but it is throwing error, can we use mix of variables like some from environment, folder and some from data files in runtime?

[mv]

Always, you have such a great presentation method. I am curious, when I use a time variable that I created in my Pre-Request Script, the body tab shows my variable name 'timeVariable' italicized, as in "time":"{{timeVariable}}", Is this due to the variable 'timeVariable' being dynamic?

[shalujain]

HI Raghav, Thanks for excellent tutorials. Really appreciate your way of teaching by creating small videos to easily digest new concepts. just having one doubt against this data driven concept as many times we face this while working in real time project. What if we just want to run the request for some rows and not all like first 5 rows or 1, 3, 5 row but need to have all the rows written in datafile. how do we achieve that in postman to dynamically select the rows?

[kavitha-]

Hi Raghav,
I really enjoyed learning with your youtube series
In my folder, I have both two scripts. One uses the csv file and the other uses the json file. In that case, how to upload both the files if I wanted to run both the scripts?
I tried to run the folder (which has the above two scripts) and when I try to upload both files, it replaces the prev file, which means I can only execue one script. So, it looks like it does not allow. Just wanted to double check with you.
Thank you!

[itsme-vcfs]

Raghav there is a senario like this, when i sign up with email password and confirm password every a new token gets generated, i need to give this random token to run another verify email api. How can i create csv file for this? How can we give comma in csv file as u have shown in note pad? With out endpoint can create only for variables like email, password and confirm password?. Please answer this

[yalcinkaya]

Excellent explanation ! By the way, I have a question, how do you draw that red square like 1:18?

[Stan_sprinkle]

10:11 so it assumes row 1 in the csv is headers? You don’t have set it somewhere if your file has headers?

[hellotest]

Hi Raghav,

Thanks for the Data Driven Test session. Can you let me know how to save the JSON response back to .csv from data driven test using .csv file?

[bjmhnmn]

Thanks Raghav. How do we come to know that we need to use /QA and /reg. In reqres website the endpoint url is /api/register

[DanielAlves-vkkh]

Hi Raghav i have a doubt, when i run the collection everything is going fine but it gives me error 404 on the endpoint. if i put the endpoint writen manual it goes well. What can i do?