POSTMAN BEGINNER TUTORIAL 15 💡 Data Driven Testing | How to get data from CSV, JSON file

Рет қаралды 239,045

Күн бұрын

All FREE courses - automationstepbystep.com/
Today we will learn:
1. How to get data from csv file
2. How to get data from json file
3. How to Run data-driven API Requests
4. How to Run data-driven Tests
Useful TIPS
Data variables can be used wherever environment variables can be used except in pre-request and test scripts
References :
reqres.in/
codebeautify.org/jsonviewer
________________________________________________________________
POSTMAN Beginner Tutorials - • POSTMAN BEGINNER TUTOR...
Playlists - / @raghavpal
________________________________________________________________
Do like, share and subscribe
Keep Learning,
Raghav
HIT SUBSCRIBE & BELL TO GET NEW VIDEOS
_______ ONLINE COURSES TO LEARN _______
automationstepbystep.com/
----------- UI TESTING -----------
Selenium Beginners - bit.ly/2MGRS8K
Selenium Java Framework from Scratch - bit.ly/2N9xvR6
Selenium Python - bit.ly/2oyMp5x
Selenium Tips - bit.ly/2owxc50
Selenium Builder - bit.ly/2MKNtlq
Katalon Studio - bit.ly/2wARFdi
Robot Framework - bit.ly/2Px6Ue9
----------- API TESTING -----------
Web Services (API) - bit.ly/2MGafL7
SoapUI - bit.ly/2MGahmd
Postman - bit.ly/2wz8LrW
General - bit.ly/2PYdwmV
----------- MOBILE TESTING -----------
Mobile Playlist - bit.ly/2PxpeUv
----------- CI | CD | DEVOPS -----------
Jenkins Beginner - bit.ly/2MIn8EC
Jenkins Tips & Trick - bit.ly/2LRt6xC
Docker - bit.ly/2MInnzx
----------- VERSION CONTROL SYSTEM -----------
Git & GitHub - bit.ly/2Q1pagY
----------- PERFORMANCE TESTING -----------
JMeter Beginner - bit.ly/2oBbtIU
JMeter Intermediate - bit.ly/2oziNVB
JMeter Advanced - bit.ly/2Q22Y6a
JMeter Tips & Tricks - bit.ly/2NOfWD2
Performance Testing - bit.ly/2wEXbLS
----------- JAVA -----------
Java Beginners - bit.ly/2PVUcXs
Java Tips & Tricks - bit.ly/2CdcDnJ
----------- MAVEN -----------
Maven - bit.ly/2NJdDRS
----------- OTHERS -----------
Redis- bit.ly/2N9jyCG
Misc - bit.ly/2Q2q5xQ
Tools & Tips - bit.ly/2oBfwoR
QnA Friday- bit.ly/2NgwGpw
Sunday Special - bit.ly/2wB23BO
Ask Raghav - bit.ly/2CoJGWf
Interviews - bit.ly/2NIPPxk
All Playlists - bit.ly/2LSiezA
Keep Learning,
Raghav
Website - automationstepbystep.com/
LifeCharger - lifecharger.org/
Udemy Courses - www.udemy.com/user/raghav-pal-3/
Facebook - / automationstepbystep
Twitter - / automationsbs
KZfaq - / automationstepbystep

Пікірлер: 530

@RaghavPal 4 жыл бұрын

Free online courses - automationstepbystep.com/online-courses/

@nagarjunapunyala7391 4 жыл бұрын

Hi Ragav Can you please make a video on "Save api responses to local drive in excel"

@RaghavPal 4 жыл бұрын

I will try to do that soon Nagarjuna

@nagarjunapunyala7391 4 жыл бұрын

@@RaghavPal thank you

@YoshiKirishima 6 жыл бұрын

This video series was AMAZING! So organized, so professional, so easy to understand! The way you explain things is perfect. Other videos skip so many important details. Covered all the major areas of PostMan, including how to automate it with newman/Jenkins. Thank you so much!

@RaghavPal 6 жыл бұрын

Thanks for watching and sending me this message Yoshi.

@djdegoed 5 жыл бұрын

This is an excellent introduction to Postman, very well described, it is very clear and easy to follow. Good job!

@RaghavPal 5 жыл бұрын

Thanks for the message Dick de Goede

@mzamomahaeng268 3 жыл бұрын

The man does it again. Masterclass indeed thank you Mr Pal. I will give the same demo to my team.

@RaghavPal 3 жыл бұрын

Most welcome Mzamo

@jaybongcaron4758 4 жыл бұрын

Thank you, Raghav! This was very helpful. Keep up the great work!

@RaghavPal 4 жыл бұрын

Glad it was helpful Jay

@innadolina3870 3 жыл бұрын

Thanks Raghav for knowledge sharing! I had the same problem at first - each iteration showed the same body. So my little advice, for those who have this struggle - make sure that the name of the global variables (endpoint, email, password) are equal to those names you use in your JSON file and in a body of your request you run.

@RaghavPal 3 жыл бұрын

Thanks for the tips Inna

@benwang3663 3 жыл бұрын

Very good tutorial with clear instructions, nice touch on validating the json format, good on you, cheers!

@RaghavPal 3 жыл бұрын

Glad it was helpful Ben

@AkeelAmeen 6 жыл бұрын

As usual very detail and informative. Being a postman user myself, even I learned a couple of things. Great tutorial, keep them coming :) P.S. If you can improve the sound of the videos in upcoming series would be a great. thanks

@RaghavPal 6 жыл бұрын

Thanks for watching Akeel, will definitely work on sound

@gayathris4422 3 жыл бұрын

I have started learning POSTMAN tool using this video only... The way u explain is very clear and understandable... Thanks a lot Raghav🙏🙏. Keepup ur work.. it's very informative..

@RaghavPal 3 жыл бұрын

You are most welcome Gayathri

@sherryraheem3603 6 жыл бұрын

Hi Raghav, Just want to say thank, you made it very easy.

@RaghavPal 6 жыл бұрын

You're welcome Sherry

@jeanhxu 3 жыл бұрын

love your class, short and useful!! thanks a lot!

@RaghavPal 3 жыл бұрын

You're very welcome Jean

@mukhaddarshaik7796 2 жыл бұрын

Thanks alot Raghav. I was able to fix an issue wrto the data driven testing with the help of this video.

@RaghavPal 2 жыл бұрын

You're welcome!

@riteshbhadani6317 4 жыл бұрын

Really nice videos. I like the way you covered all the minors tricks. This video helped me a lot. Thanks Raghav.

@RaghavPal 4 жыл бұрын

You're welcome Ritesh

@kiranjape3941 4 жыл бұрын

Best Video to get in about Data driven using postman ...Thanks

@RaghavPal 4 жыл бұрын

Glad it was helpful Kiran

@rammohan4056 5 жыл бұрын

Thanks Raghav, this Knowledge sharing was helpful to me.

@RaghavPal 5 жыл бұрын

Glad to know this Ram

@sahilpandita4658 2 жыл бұрын

Great Video..I was exactly looking for this. Much thanks..

@RaghavPal 2 жыл бұрын

You are most welcome

@sunitasharma5037 2 жыл бұрын

Thanks Raghav Very useful for beginners 🙏🏻🙏🏻

@RaghavPal 2 жыл бұрын

Most welcome Sunita

@abpatel5943 3 жыл бұрын

very helpful. very good series. thanks a lot Raghav Pal

@RaghavPal 3 жыл бұрын

Most welcome!

@aleksandraklimantova6694 5 жыл бұрын

Thank you very much for the tutorial! Helped a lot :-)

@RaghavPal 5 жыл бұрын

You're welcome

@riteshkumar6403 5 жыл бұрын

Excellent. Very informative video.

@RaghavPal 5 жыл бұрын

Thanks for watching Ritesh

@ishakahammed7176 2 жыл бұрын

Amazing Video. Thank YOU

@RaghavPal 2 жыл бұрын

Glad you enjoyed it Ishak

@PerpetuoBeats 3 жыл бұрын

the best video on the subject! Thank you!!!!!

@RaghavPal 3 жыл бұрын

I am so humbled. Thanks for watching

@itzdevaraj 5 жыл бұрын

Awesome Series !!!! THANKYOU

@RaghavPal 5 жыл бұрын

You're welcome Devaraj

@fachrizalmasugi8703 3 жыл бұрын

ty sir ur explanation so good very helpful to undrstnd.

@RaghavPal 3 жыл бұрын

You are most welcome Fachrizal

@radio655 3 жыл бұрын

Well explained Raghav-ji 😊

@RaghavPal 3 жыл бұрын

Thanks Jan

@amilcarrodriguez8449 3 жыл бұрын

Thanks, greetings from Panama 🇵🇦

@RaghavPal 3 жыл бұрын

Thanks for watching Amílcar

@erlynlebron5577 2 жыл бұрын

Useful! Thank you!

@RaghavPal 2 жыл бұрын

Most welcome Erlyn

@samcao4215 5 жыл бұрын

Excellent video! Thanks

@RaghavPal 5 жыл бұрын

You're welcome Sam

@gcscompany1563 5 жыл бұрын

thank you this tutorial helps a lot.

@RaghavPal 5 жыл бұрын

You're welcome

@shamax2201 2 жыл бұрын

Great tutorial. Thanks

@RaghavPal 2 жыл бұрын

Most welcome

@zulfiaman 4 жыл бұрын

This is a best video what I have seen on this topic

@RaghavPal 4 жыл бұрын

Happy and humbled to see this Zulfi

@shuitaoyang 6 жыл бұрын

Very helpful, thank u.

@RaghavPal 6 жыл бұрын

You're welcome Shuitao

@steasy5673 5 жыл бұрын

your time is 5 AM and you're making tutorials. not bad

@RaghavPal 5 жыл бұрын

I usually make them early mornings Steasy

@The-dw1ms 4 жыл бұрын

@@RaghavPal God bless you Raghav, you are good man and a hard working man on mission!!

@marcioalexandremarcondes557 3 жыл бұрын

Thank you so much for this!

@RaghavPal 3 жыл бұрын

You're so welcome Marcio

@PardeepKumarbindass 6 жыл бұрын

Hi Raghav, First of all, thanks for such an informative tutorial on API Testing using Postman, One more favour needed, could you pls upload some advanced level tutorial on API testing using POSTMAN also API Interview QnA. Thanks in Advance Happy Quality Testing.

@RaghavPal 6 жыл бұрын

Hi Pardeep, I will do that surely

@anilraju93 3 жыл бұрын

super brother.. thank you.

@RaghavPal 3 жыл бұрын

So nice of you

@delloidigi1321 3 жыл бұрын

Got yourself a Sub Sir, very informative video! Keep it up!

@RaghavPal 3 жыл бұрын

Awesome, thank you!

@OscarDiaz-fb8jd 4 жыл бұрын

THank you man. Really good.

@RaghavPal 4 жыл бұрын

Glad you liked it Eliecer

@sajnapm9248 4 жыл бұрын

Awesome explaination 👌

@RaghavPal 4 жыл бұрын

Thank you Sajina

@shreyasb.s3819 4 жыл бұрын

Good video.Thanks

@RaghavPal 4 жыл бұрын

You're welcome Shreyas

@ukmpn8016 4 жыл бұрын

Really helpful thanks

@RaghavPal 4 жыл бұрын

You're welcome

@chandanroy87 3 жыл бұрын

Hi Raghav, These are excellent videos and you are really helping people learn things easily and quickly. Could you share some detail on how can we get inputs from DATABASE JDBC connection in postman?

@RaghavPal 3 жыл бұрын

Hi Chandan, you can see these examples documenter.getpostman.com/view/5922408/RznJmGfn?version=latest

@abhigupta9727 4 жыл бұрын

great video . Thank you Raghav ! Please help me with few questions: 1 - Do we have a similar process of data-driven if we use SOAPUI , pls share video if you have SOAP UI link for same concept 2- What coding language did you use in tests and do you have a video of that coding language? 3- What level of expertise is needed on that coding language to support API testing for a QA. 4- One of my colleagues demoed a similar concept for REST through SOAP UI but that was too complex like importing library and then writing a long code to read excel data cell and then passing that value to the env variable but yours is far easier..what is it so? Does SOAP UI tool need a lot of additional dependencies to read data from xls /csv ? . Please share the video for SOAPUI Vs POSTMAN diff in this context ... Sorry for so many questions but I'm eagerly waiting for a response! Thank you for all your great work !!

@RaghavPal 4 жыл бұрын

Hi Abhi, 1. You can check SoapUI tutorials here automationstepbystep.com/ and here automationstepbystep.com/udemy-discounts/ 2. Its JavaScript, You can find beginner tutorials on the above link 3. Basic and OOP will be good 4. with SoapUI free ver you will need to do a lot of custom things

@geneyoo179 5 жыл бұрын

HI, thank you for your awesome videos. They have helped me a lot for my new job. I was wondering if it was possible to do this with a variable in the header?

@RaghavPal 5 жыл бұрын

You're welcome Gene. Yes variables should work in headers too. Try out.

@raash133 6 жыл бұрын

Hi Raghav, Your tutorial is really informative and very helpful too. I have couple of question regarding Data driven testing in Postman 1. Is there any way we can do a SQL/Oracle query and retrieve data using postman 2. Also is there any way we can compare DB extract with an API response Thanks in advance.

@RaghavPal 6 жыл бұрын

HI Rakesh, In POSTMAN there is no out of the box feature to query db. Having API to interact with DB is one option. Read this blog.getpostman.com/2018/02/09/read-and-write-to-rest-enabled-databases/ github.com/postmanlabs/postman-app-support/issues/2185

@raabiyabasariya9426 6 жыл бұрын

Thanks for videos

@RaghavPal 6 жыл бұрын

You're welcome Raabiya

@sambenny1916 2 жыл бұрын

Thanks a lot brother

@RaghavPal Жыл бұрын

most welcome

@ArunVentures 6 жыл бұрын

you are doing a great job raghav. Can you post more videos?

@RaghavPal 6 жыл бұрын

I will do that soon, Thanks for watching.

@mhmdmar 6 жыл бұрын

thank you I learned alot from your videos , I hope I get accepted to the qa job I applied to :)

@RaghavPal 6 жыл бұрын

All the best.

@TheShaan3000 6 жыл бұрын

Hi mohe how did you go with the job? and I wanted to ask you Raghav if these videos will be enough to apply for a role where API testing experience is asked. Thanks

@chaudhryumair007 5 жыл бұрын

professional , Good Luck

@RaghavPal 5 жыл бұрын

Thanks for watching Umair

@chaudhryumair007 5 жыл бұрын

You are welcome @@RaghavPal

@mamtajeena5186 4 жыл бұрын

Thank you Raghav, learnt so much from you. I have 1 question that How we can run same via Jenkins?

@RaghavPal 4 жыл бұрын

Hi Mamta, there is a video on that, Check the postman playlist here - automationstepbystep.com/

@shubhamshrivastava5311 4 жыл бұрын

Hi Raghav, Thank you for making this series. These videos have been really helpful. For one of my project I am using an external data set(CSV File) for iterations. Is it possible to run a collection which is using a CSV or JSON file as an external data set through Newman? If yes, can you please explain that. Thank You

@RaghavPal 4 жыл бұрын

Hi Shubham, Yes you can. You can use -d flag and provide location of your csv or json file $ newman run mycollection.json -d data.json Steps to run test cases from command line :- • Open CMD • Now reach to the folder where your JSON are saved • Now hit command as below newman run Test_Collection.postman_collection.json -e Environment.postman_environment.json -g globals.postman_globals.json -d demoData.csv -reporters cli,html In above command -e represents environment variable, -g global variable, -d csv data file name, -reporters cli,html represents output as console and html reports. www.cuelogic.com/blog/postman-tutorial-for-automation

@chelsijain5249 2 жыл бұрын

Thanks for all the awesome videos. Is there any way to export JSON data into a CSV file from the postman or from Jenkins and trigger that job?

@RaghavPal 2 жыл бұрын

Hi Chelsi, I will need to check on that

@ytwoen4137 3 жыл бұрын

I truly enjoyed this video. I do have one question. How would i do a loop so all the result from the get get added in de put ?

@RaghavPal 3 жыл бұрын

Hi, thanks for watching, you can put in test script

@poojapatil188 3 жыл бұрын

Hi Raghav,Thanks for the explanation is very useful. I have a question that can we use Envrionment Varible in Pre-request script of another request?

@RaghavPal 3 жыл бұрын

Hi Pooja, yes, we can, you can also use global variables 1. Scope- Environment variables can be accessed with the corresponding environments. Global variables can be accessed broadly regardless of the selected environment. 2. Priority : priority is as follows: - local - data - environment - collection - global So in case a global variables shares same name with an environment variables, at runtime value will be referenced from env variable 3. Getting & Setting variables through scripts - Global - pm.globals.set() - pm.globals.get() - Env - pm.environment.set() - pm.environment.get() learning.getpostman.com/docs/postman/environments_and_globals/intro_to_environments_and_globals/ pm.variables is for local variables for e.g. pm.variables.set("variable_key", "variable_value"); Local variables are temporary values you set in your request scripts. Also //access a variable at any scope including local pm.variables.get("variable_key"); //access a global variable pm.globals.get("variable_key"); //access a collection variable pm.collectionVariables.get("variable_key"); //access an environment variable pm.environment.get("variable_key");

@ankitanautiyal370 6 жыл бұрын

Hi ,Thank you for the detailed Video really saved my day. What if the I run a job in collection Run and I have 20 Iterations , I want to save the response body of all 20 Iterations to my local machine returned by the API. Is it possible?

@RaghavPal 6 жыл бұрын

Hi Ankita, thanks for watching. Check this link github.com/postmanlabs/postman-app-support/issues/3033#issuecomment-301758179

@md.mahfuzulhuqtalukder6644 4 жыл бұрын

Thank you so much. Your all video tutorials are best for learning. Once again I want to say you are the best. I have one question, what is the benefit of creating the variable in Global?

@RaghavPal 4 жыл бұрын

Thanks for the kind words Mahfuzul. The global variables can be used across collections. Basically the diff is in scope and priority and you can use as per your needs. The diff is as follows: 1. Scope- Environment variables can be accessed with the corresponding environments. Global variables can be accessed broadly regardless of the selected environment. 2. Priority : priority is as follows: - local - data - environment - collection - global So in case a global variables shares same name with an environment variables, at runtime value will be referenced from env variable

@md.mahfuzulhuqtalukder6644 4 жыл бұрын

Thank you so much

@thanhproo1412 Жыл бұрын

just want to said thanks ^^

@RaghavPal Жыл бұрын

Most welcome Thanh

@balkrishnasethi1964 3 жыл бұрын

Your Video content is really good and I liked it. I have generic Question- When we use Headers? and how we will know we have to use Header in anycase? kindly clarify me. Thanks in advance.

@RaghavPal 3 жыл бұрын

Hi Balkrishna, in general we provide headers on content-type and accep. This is to tell the server the type of content we are sending like XMl, JSON etc and the format that we want to accept XML, JSON etc. Apart from this any other authentication and headers if you need to add should be given to you from the owners of the api or the dev team

@balkrishnasethi1964 3 жыл бұрын

@@RaghavPal Thank you for responding :) I got it :)

@naveenck7867 6 жыл бұрын

Thanks for video Raghav. Question - for testing REST API - which is preferred tool; SoapUI or Postman ? Thanks for your response !

@RaghavPal 6 жыл бұрын

Hi Naveen, both of these tools are good. Few things you can consider. 1. Both SoapUI and Postman have free and commercial versions 2. In Postman the free version has mostly all features and major difference is in terms of monthly calls, check here - www.getpostman.com/pricing 3. In SoapUI there are several features that are available as click and do in commercial versions, however in open source version you will have to add groovy scripts for the same. 4. Both these tools can handle REST well 5. In case of SOAP, SoapUI is better suited as of now. You can also watch my SoapUI tutorial which is on open source version here - kzfaq.info/sun/PLhW3qG5bs-L-Bt9T_bnyflQ0Te4VgFhKF New videos will be added soon

@siddharthau489 Жыл бұрын

Thanks for the detailed explanation. Can we write a pre request script to upload an image as binary in the Body of the request? I have an api in which I upload the image binary in the body before sending the request. I'm trying to validate this through script. Could you please guide me how to write the script for this. Thank You.

@RaghavPal Жыл бұрын

Hi Siddhartha, this can help you community.postman.com/t/how-to-upload-images-to-a-post-request/15256

@vinaykrishna297 5 жыл бұрын

Hi Raghav, thanks for the series and I have a question here. In this video before selecting the data file in the collection runner screen the ITERATION was 1 and after selecting it is automatically changed to 2. When I tried it did not happen that way, and it is still shown as 1 and Postman does not execute the script with the second set of data. Should not it execute both the data even when iteration is 1?

@RaghavPal 5 жыл бұрын

Hi Vinay, Try to not give any iteration count and check

@enver6414 4 жыл бұрын

Hi, Raghav. thank you for these very useful videos. i am always enjoying learning from your channel. i have an question how to upload multiple objects from csv to postman. can you please help figure it out. thank you

@RaghavPal 4 жыл бұрын

Hi Enver, I will check and plan a session. For now, pls try online help. Let me know if you find something. Can help others

@NaveenKumar-dl2ez 3 жыл бұрын

Very informative videos. Good work. A simple query, at 15:05, responsebody.has(). This will look for "some value" in response body irrespective on the key under which that value is present, right?

@RaghavPal 3 жыл бұрын

Yes, correct Naveen

@cdr8556 4 жыл бұрын

Thanks. I had trouble with smart quotes while creating json file in my tiny screen mac.

@RaghavPal 4 жыл бұрын

Please let me know if you are still facing issues.

@cdr8556 4 жыл бұрын

I am all set. Thanks. Just letting people know there are some editors that will auto-correct “plain straight quotes” to “smart curly quotes” and hard to notice unless you look closely.

@sultan-algarbi 3 жыл бұрын

9:17 you have to save the csv file as [ csv (comma delimited) ] type, so the excel will add the comma automatically

@RaghavPal 3 жыл бұрын

thanks for adding

@avinashbaburavi 4 жыл бұрын

Hi Raghav. Thanks for the video. Can you post video on how to get data from database to our request body in postman. It would be really helpful. Thank you.

@RaghavPal 4 жыл бұрын

Hi Avinash, will plan to add a session on this

@ahmedabulela5730 5 жыл бұрын

Dear Raghav, Hope you are well, i have a question, if i can read from the collection runner preview (specifically the response) and past it to the equivalent values of the row in the CSV file as the actual result. Hope you can have some way to help me.

@RaghavPal 5 жыл бұрын

Hi Ahmed, You will have to do scripting for that. Pls try some online help

@nina10103 4 жыл бұрын

Hi Raghav, the only way for using the data file is when you run the request with the collection runner? Thanks

@RaghavPal 4 жыл бұрын

Hi Ana, Yes, or you can do custom scripting

@khaledlimem4531 4 жыл бұрын

This is perfect. How to get data from csv file using CLI (Newman) ?

@RaghavPal 4 жыл бұрын

Hi Khaled, you can use -d flag and provide location of your csv or json file $ newman run mycollection.json -d data.json Steps to run test cases from command line :- • Open CMD • Now reach to the folder where your JSON are saved • Now hit command as below newman run Test_Collection.postman_collection.json -e Environment.postman_environment.json -g globals.postman_globals.json -d demoData.csv -reporters cli,html In above command -e represents environment variable, -g global variable, -d csv data file name, -reporters cli,html represents output as console and html reports. www.cuelogic.com/blog/postman-tutorial-for-automation

@khaledlimem4531 4 жыл бұрын

Thank you Raghav :)

@nihalsiingh099 6 жыл бұрын

Hello Raghav Pal, Thanks for these videos, i'm new to API testing and learned a lot from your videos. I do have a question, When we are passing invalid value through JSON or CSV then how do we write a validation for it? (I know we can write it in Test section) do you have any specific video which tells us how to do the validation or point me to your blog or any other blog which can help me?

@RaghavPal 6 жыл бұрын

Hi Nihal, so as you mentioned you can write a test for it, So test scripts will run after the test on response. Do you want to do something diff than this

@nihalsiingh099 6 жыл бұрын

Hello Raghav. I'm trying to write a scenario, i have a field which accepts only 10 character. var jsonData = JSON.parse(request.data); if (pm.expect(jsonData.criteria.carmodelInformation.carmodelName.length).to.be.below(11)) { pm.test("Valid Car Model Name is Passed", function () { pm.response.to.have.status(200); } ); } else { pm.test("Verification of Error Message in the response Body", function() { pm.response.to.have.status(400); } ); } My scenario is, if i enter more than 10 characters for the field then it fails. i get "There was an error in evaluating the test script: AssertionError: expected 15 to be below 11" error. error message. But when i enter less than 10 characters then scenario is passed. Is there a problem with script or can you please point me to where am i doing mistake. Thanks for the help.

@sudeepbasak1116 4 жыл бұрын

Hi Raghav, I like all of your videos, I regularly watch your video. You are doing great job. I have a question, as I am very new to POSTMAN, you have used few Syntax like "Responsebody.has" in Tests bar. What does this Syntax "Responsebody.has" means ? and where I will get the list of all Syntax with descriptions.

@RaghavPal 4 жыл бұрын

Hi Sudeep, thanks for the message, you can check the test snippets in the test section

@kovilamooneegadoo495 4 жыл бұрын

Hi Raghav, firstly very well done on the beginner tutorial - one question though: In testscripts section, should a global variable always be used? Can you use a local variable in there ? Thank you in advance for your response ^_^

@RaghavPal 4 жыл бұрын

Hi Kovila, you can use a script variable if he scope is only in that script. Global var should be used when you want to access them across project and env variables should be used when you want to use diff values for diff env.

@jeremyrubio1531 2 жыл бұрын

Hi, Thank you for sharing your knowledge. I just have some questions though, can I read the output in the postman terminal and can I also create validation in Data Driven Testing ? Thank you.

@RaghavPal 2 жыл бұрын

yes you can Jeremy, I will plan to add sessions

@jeremyrubio1531 2 жыл бұрын

@@RaghavPal Thank you. Done subscribing hahaha

@vibhorsharma2436 3 жыл бұрын

This is amazing video, could please explain if we have multiple request and every request i need to pass different data, how can we do this because right now for every request i need to upload different file, so i just want can we upload one file, Pls help on this

@RaghavPal 3 жыл бұрын

Hi Vibhor, you can use a single file and add your data and in your requests add the variables accordingly, You can also set the iterations from Collection Runner

@vibhorsharma2436 3 жыл бұрын

@@RaghavPal thanks for this, when i add the variable for the second request in same json file then the data for that second request does not appear in the preview, as the variable are different. Also when i add two arrays for two request in json then it only execute for two iterations and does not pick data and gets fail

@RaghavPal 3 жыл бұрын

when you run from collection runner, increase the iteration count

@vibhorsharma2436 3 жыл бұрын

@@RaghavPal Thanks for the reply, i think, i bit confuse to explain my problem, I have collection, that collection contains 7 different request, and I have to pass different data for every request, Few Steps - 1) open runner 2) select the collection (when i select the collection the all 7 request selected, Now if i want to run all 7 request so how can i do it because if i am uploading json/.csv file (this file contains only request 1 data) in the runner, other (2nd to 7th request) are fail. So my problem is how can prepare .csv / json for all 7 request in the single file or there is another way we can run continuous all request through one file (but all request have different data) Again thanks you for the reply

@RaghavPal 3 жыл бұрын

Check this Vibhor community.postman.com/t/csv-data-files-for-multiple-requests-within-one-collection/819

@2qood4lyfe 4 жыл бұрын

quick question Raghav!! where did preprod come from? I forgot but I saw it in an earlier video. Is it a type of environment or variable?

@RaghavPal 4 жыл бұрын

Yes it is example of env PreProduction

@mlungisimabobo4544 3 жыл бұрын

Hi Raghav, thank you so much for this tutorial once again... Now, I am struggling with running the on the Collection from command line using the external file...any idea how I can that?

@RaghavPal 3 жыл бұрын

Hi Mlungisi, you can use -d flag and provide location of your csv or json file $ newman run mycollection.json -d data.json Steps to run test cases from command line :- • Open CMD • Now reach to the folder where your JSON are saved • Now hit command as below newman run Test_Collection.postman_collection.json -e Environment.postman_environment.json -g globals.postman_globals.json -d demoData.csv -reporters cli,html In above command -e represents environment variable, -g global variable, -d csv data file name, -reporters cli,html represents output as console and html reports. www.cuelogic.com/blog/postman-tutorial-for-automation

@EmanueleRotolo 4 жыл бұрын

Hi, thanks for the video. I'm getting unauthorized with a csv or json with a multiple row. The first row went fine but for the other i get unauthorized with no error. Iteration are correct. Did you have this kind of problem?

@RaghavPal 4 жыл бұрын

HI Emanuele, pls check postman console to verify what is the value referred. kzfaq.info/get/bejne/pMthhdaKyM3Pg40.html

@saurabhjajoo9371 5 жыл бұрын

Hi Raghav, what commands to use, if we need to run it(the data driven test) through command line. When running a collection from GUI, we are selecting the .csv file manually at runtime. Just wondering, how will the collection know, which file to pick, when we run this using command line.

@RaghavPal 5 жыл бұрын

Hi Saurabh, you can use -d, --data flag from command line to give data file location

@RahulSharma-di4uh 6 жыл бұрын

Hi Raghav, could you please suggest is it possible in postman to get data from oracle dB (Sql Developer) and set that data as globals for further validations

@RaghavPal 6 жыл бұрын

Hi Rahul, have not done it, check this link - blog.getpostman.com/2018/02/09/read-and-write-to-rest-enabled-databases/

@Cassatoa 4 жыл бұрын

I was just struggling with an issue that others seem to have where each iteration will show the same body, even after the preview works. Make sure to check your environment, I was in QA which previously instructed us to set variables that seem to overwrite the data file. changed to No Environment and it worked as expected

@RaghavPal 4 жыл бұрын

Thanks for sharing this Andrew

@Bhakkiyapriya 3 жыл бұрын

I am struggling with this error. environment not works out for me. Can u help?

@lowrencekalyansingh5922 4 жыл бұрын

Raghav, one question here. When you assign variables in a global env, and then refer the endpoint from that variable... like you did for the api/register/preprod with Endpoint. Should I be in the "No Environment" and execute ? or should I be in QA env and execute. Coz in each env, it gives different results.. pl explain

@RaghavPal 4 жыл бұрын

Hi Lowrence, I will suggest to be very honest in interviews, If you do not have the skills required for the job, you can try to get some basic knowledge before the interview and in the interview you can mention, that, "I did not get a chance to work on this in my job until now, but I have tried to get knowledge and exp on this on my own and I am eagerly looking forward to work on this technology. If given an opportunity, I am ready to learn and perform. I can also take out my personal time to learn the required skills before I join the job here." Experienced and genuine interviewers always appreciate honesty and are always ready to hire somebody who has the will to learn and perform on any duty.

@lowrencek3592 4 жыл бұрын

@@RaghavPal My question was about Postman Raghav, one question here. When you assign variables in a global env, and then refer the endpoint from that variable... like you did for the api/register/preprod with Endpoint. Should I be in the "No Environment" and execute ? or should I be in QA env and execute. Coz in each env, it gives different results.. pl explain

@RaghavPal 3 жыл бұрын

Hi Lawrence, looks like I mixed up responses. Sorry for that. When you create env variables, you give name to your env. Now when you run your request you will need to select the env from the dropdown (top right) and only then the values will get referred from that env.

@monalikajain 3 жыл бұрын

Hi Raghav.... great learning from u..I hv one doubt in this vid...why use preprod at last in api???

@RaghavPal 3 жыл бұрын

Hi Monali, it was to refer the variable endpoint. You can replace with your url

@monalikajain 3 жыл бұрын

@@RaghavPal but we are added preprod in the end of api like api/registers/preprod after that we replace it with endpoint...dats y m confused y added just after register.

@RaghavPal 3 жыл бұрын

This was just to demo how we may have to update part of the endpoint for diff env in real world

@jawadmisbah5203 4 жыл бұрын

Hello Raghav, Thanks for all the excellent videos on POSTMAN. Could you please create a video for exporting responses body of all the request executed through data driven tests in collection runner. As of now, response from the collection runner is available to for viewing in Collection runner window. Thanks again. Jawad

@RaghavPal 4 жыл бұрын

Hi Jawad, I will check on this, May be some scripts will be required.

@meghagowda9077 4 жыл бұрын

@@RaghavPal Hi Raghav, even i am waiting for the scripts which reads the response body and export it to the csv file..

@bandit7348 3 жыл бұрын

Hey Raghav, could you plz let me know how can we use data files if we want to run entire collection which has multiple requests and needs multiple files. Thanks in advance...& BTW video was super informative and helped me a lot. Thanks for that buddy!!

@RaghavPal 3 жыл бұрын

Hi Saumil, you can use -d flag and provide location of your csv or json file $ newman run mycollection.json -d data.json Steps to run test cases from command line :- • Open CMD • Now reach to the folder where your JSON are saved • Now hit command as below newman run Test_Collection.postman_collection.json -e Environment.postman_environment.json -g globals.postman_globals.json -d demoData.csv -reporters cli,html In above command -e represents environment variable, -g global variable, -d csv data file name, -reporters cli,html represents output as console and html reports. www.cuelogic.com/blog/postman-tutorial-for-automation

@manekagayomi9079 6 жыл бұрын

Hi Raghav, Is there any way to import postman collection to jmeter including test

@RaghavPal 6 жыл бұрын

Hi Maneka, yes you can use JMeter Test Script recorder and capture requests from POSTMAN. I will try to do a session on that soon.

@malsongraca6236 6 жыл бұрын

Hi Raghav, Thank you so much for this great tutorial. I am wondering why my running results only taking into account the first row data, even though it shows 2 iterations results but both show the data from the first row. Thanks

@RaghavPal 6 жыл бұрын

Hi Malson, when you select your file in collection runner, do you get the view of all the data

@malsongraca6236 6 жыл бұрын

Hi Raghav, Thanks for a prompt reply. Yes, when I select the file in collection runner I get the view of all data in the preview data window. However, once I run it I see 2 iterations in the run results window but both displaying the first row data.

@RaghavPal 6 жыл бұрын

Try to manually give the iteration count in the iteration field and check

@pavankumarpabbisetty8743 2 жыл бұрын

I had learnt more with your videos thank you so much for all support. Could advise what is postman version used within this videos, i am not able to view the import of environment config and data config file. Is this license version of postman? please advise.

@RaghavPal 2 жыл бұрын

Hi Pavan, you may see some changes in the new ver, I will plan to add new videos

@pavankumarpabbisetty8743 2 жыл бұрын

@@RaghavPal Thank you :) could provide the version used for demo, please.

@RaghavPal 2 жыл бұрын

I do not specifically remember the ver, I may have shown in some video

@sagarbobade2036 5 жыл бұрын

Hey Raghav, is it possible that environment variable and collection variable to be same name ? If yes then how to identify/differentiate them while accessing in script ?

@RaghavPal 5 жыл бұрын

Hi Sagar, we use the following pm.variables.get() pm.environment.get() globals.get() This will help - learning.getpostman.com/docs/postman/environments_and_globals/variables/

@giladhershcovitz1849 4 жыл бұрын

Hello Raghav, 1st of all thank you very much for your tutorials. I wanted to ask about the variables in postman Let's say that I have a variable called ''url'' at the collection level, and I have another variable with the same name at the global level. And let's say I refer the variable ''url'' in my request body. How does postman knows which variable to use? Thanks in advance and stay safe during these trying times.

@RaghavPal 4 жыл бұрын

Hi Gilad, Variables will be referred in the following Priority Priority Local Data Env Collection Global Can check a video here - kzfaq.info/get/bejne/a8d9pNyJv7jaqJs.html

@chitreshagarwal 4 жыл бұрын

Kudos to you for the video content! Nice job. Please stop zooming in and out though. Its kinda irritating.

@RaghavPal 4 жыл бұрын

Sure Chitresh, I will take care of this.

@sayalideshmukh9310 4 жыл бұрын

Hello Raghav, Thanks for the awesome video :) Can we add test data for more than one request in a single data file? Right now I can only add the data for one request in a one data file. Thanks

@RaghavPal 4 жыл бұрын

You can Sayali, you will have to use the variables accordingly. This will help community.getpostman.com/t/csv-data-files-for-multiple-requests-within-one-collection/819/2

@sayalideshmukh9310 4 жыл бұрын

Thanks for your quick response. Is there any link to describe the exact steps for this ? From the above link,it is not that clear how to do the same. Currently I am facing below issue. I have prepared the data for multiple requests in a single data file, provided the parameter/variable names are different in all the requests. Request 1 has parameter names as A,B,C and request 2 has P,Q and R. Prepared 3 different data sets for request one and three for request 2. After passing the data file, in the preview option I can see 6 datasets for request one and not for 2.

@RaghavPal 4 жыл бұрын

Hi Sayali, I could not find any link with exact steps for you. May be I can try to create a session, but can take time.

@macdonaldchigubhu7265 3 жыл бұрын

Hi Raghav, I am following your course and has been too helpful for me. I have a POST API request which says all ok but no changes to the underlying database. Strange. would you suggest what the reason could be?

@RaghavPal 3 жыл бұрын

Hi, do you get successful response code and message, It may be issue from the backend.

@qusaiatoon2802 Жыл бұрын

Hello, What if I want to pass an integer in the request body, I noticed that a double qouts is mandatory. I'd really appriciate your answer.

@RaghavPal Жыл бұрын

Hi Qusai, should work with double quotes because the number without quotes is converted to a Javascript Number when the CSV gets parsed in the Postman app

@priyankasalunkhe3789 3 жыл бұрын

Hi Raghav, Thanks for sharing this videos with us, However I have come across one query regarding one scenario, would like for your suggestion on the same. So, my scenario is: I want to run multiple requests (eg 1000) for a single api with different user input fields, and in response, for every request I'll be getting the json form url which i need to validate. So how do i achieve this using postman? Please Advise.

@RaghavPal 3 жыл бұрын

Hi Priyanka, for data you can get from data file like csv. for validation as well you can create a post test script and refer the variable whose value will be coming from data file

@dougm7499 5 жыл бұрын

When I read in the JSON file per your example, it did not auto update the Iterations field so it left it at default of 1 and only runs one iteration. I had to manually update it to 2 and then it ran both iterations. It worked without incident for the .csv file. I did run the json through the beautifier so the syntax was correct.

@RaghavPal 5 жыл бұрын

Hi, try running this from commandline.

@dougm118 5 жыл бұрын

How do I do that? I only watched a couple videos based on what my manager told me to watch and may have missed that. Can you provide here or link me to the video that explains it.

@RaghavPal 5 жыл бұрын

You can select Postman from here and see the complete playlist - automationstepbystep.com/909-2/online-courses/

@shrutisaxena6797 6 жыл бұрын

Hi Raghav, I passed 3 data set from .csv file and trying to access response values however only able to verify 1st iteration one. Is there any way i can verify values for all the iterations? Also Can we store response data into .csv or .jason file ?

@RaghavPal 6 жыл бұрын

Hi Shruti, try by putting iteration count=3

@tejapradeep 6 жыл бұрын

@ 3:00 in this video when you added Preprod in the URL how did the ID and creat date details are added in the response ? can you please explain this in detail I didn't get it

@RaghavPal 6 жыл бұрын

this is something i just observed while doing some changes,

@saurabhkeshri740 4 жыл бұрын

Not able to generate Newman report for the data driven tests run by Collection Runner.Please suggest. Thanks in Advance.

@RaghavPal 4 жыл бұрын

What is the error

@hutchkishore 2 жыл бұрын

Hello Raghav, Thanks for a nice video. Is it possible set the path of data file using code rather than selecting it manually everytime. Whenver I run a collection runner, I have to select the file manually even though there is no change in test data. Could you pls advise how to acheive this? Thanks

@RaghavPal 2 жыл бұрын

Hi Kishore, yes, you can do it in the script and better you can do it from command line you can use -d flag and provide location of your csv or json file $ newman run mycollection.json -d data.json Steps to run test cases from command line :- • Open CMD • Now reach to the folder where your JSON are saved • Now hit command as below newman run Test_Collection.postman_collection.json -e Environment.postman_environment.json -g globals.postman_globals.json -d demoData.csv -reporters cli,html In above command -e represents environment variable, -g global variable, -d csv data file name, -reporters cli,html represents output as console and html reports. www.cuelogic.com/blog/postman-tutorial-for-automation

@hutchkishore 2 жыл бұрын

@@RaghavPal Sure Raghav. Will give it a try. Thanks a lot for your reply. Is it possible to specify the path in Postman instead of Newman as I am facing trouble setting up Newman.

@RaghavPal 2 жыл бұрын

for command line you will need to use Newman, else you can run from Postman UI