REST Assured API testing Beginner Tutorial | Part 5 - How to read data from Excel

Hi Raghav, all sessions are excellent. Could you please make one video on how to pass response of one web service to input body for second service

Could you please make us understand on how to capture the response and store into object and assert multiple elements so that validation should be done

Thanks, Raghav...for sharing the knowledge in such an effective way. I can say simple teaching for complex terms ..can you please share a video on how we can pass this excel data in the request body of API (POST request) using Rest Assured

Once again best session and explanation. Thanks you @Raghav

Hi Raghav,
I have gone through all your 5 videos related to REST Assured API. I would say, it’s one best tutorial for learning Rest API from scratch level. I like the way you are explaining and giving some tips/ shortcuts during the session which would be useful a lot for freshers. I appreciate your videos and sharing your knowledge.

nice video keep uploading bro

Sir these 5 tutorials for rest assured are enough for learning api automation testing?

Nice explanation...Thanks Ragav

Hi Raghav, Thanks for your sessions, It is really helping me a lot to in my professional carrier. Can you also please make videos on Karate framework.

Hi Raghav , Thank you for this REST Assured API Automation series. can you please create video on API Chaining , Authentication and framework video if possible. you have magic the way you explain the concepts no doubt after watching your videos.

Hi Raghav, thanks for your sharing and now I had finished all your uploaded REST Assured API testing videos, just want to know is there going to be any other update on this video list? By finished those 5 videos with you, I did pick up a lot about REST Assured. As many other comments mentioned your teaching style are nice and clear, love it!

Thank you very much Radhav, If you already don’t have it, please share some interview questions for rest assured automation. Also, do you have a video on how to answer interview questions about agile project?

Hi Sir,

I want to watch the rest of the private videos can u please help me what is the procedure to watch those videos.

Dear Raghav, plz upload video on to validate response body using rest assured. And in your rest assured tutorials 6 ,7 ,8 video is showing as private, plz make it public if possible. Thanks

Thank you Raghav! Good job!

Very useful video, please try to make videos on mocha to automate API

Hi Raghav,
I am only getting HSSFW and not XSSFW. I take taken the 4.1.2 latest dependency of apache poi. With HSSF, I am unable to pass the argument "excelPath". Kindly guide.

Hi Raghav. Thanks for your contribution to us. I am getting one error when I tried to run a method for get call
java.lang.NoClassDefFoundError: Could not initialize class org.codehaus.groovy.reflection.ReflectionCache

Hi Raghav, is there a BDD framework with RestAssured from the scratch?

Hi Raghav, all sessions are excellent thanks for the session. Could you please make one video on How to Pass the values from excel to Examples in feature file and then pass it to Step Defination it would be really great if you can explain that as well and yes of course response of one web service to the request of others and so On
Thanks and Keep Rocking as always

Hi Raghav, Wonderful teaching.

I learned RestAssured from your video.

On git is there any framework for rest assured?

And Raghav, can you please upload a video for JMeter Java scripting video?

Kindly put more videos on rest assured

Good Presentation.....Could you please add session for Marshelling and Unmarshelling

Hi Raghav, How can I read data from csv file in Rest Assured using BDD

Thanks alot Raghav. Your sessions are really excellent and i have been keep watching all the videos in rest assured and cucumber and it really helps me to recall my memories back.

Thank you for the helpful video!

Please teach advance framework level. And you have been doing a great job!!!! Big thanks to you.

Hi Raghav, I want to know more about excel reading data , and once the data is read how to retrieve names corresponding to ids and how to update this names back to excel .

Hi , can someone please help me in solving one problem statement,
1.Registering the customer with the details present in the excel sheet and capture customer id from response body
2.Retrive the customer name using the customer id captured and verify it against the customer name in the excel sheet
3.On successful validation of customer name from response body against the customer name in the excel sheet, update the customer id in the excel sheet against the registered customer

Hi Raghav, Thank you for your video, could you please help us with looping concepts to read all the excel file data without giving the arguments values like [1][0]... please give me any suggestions or any existing video's for reference. Thank you..

Hi Raghav, thank you very much for the video. Could you please share the video how to retrive the json response return with Array? how to extract the Array values and validate using Deserialise and serialise concept. for ex. If i want to retrive the City from primary what will be the approach? Your response would be highly appriciated.

[
{
"primary": [
{
"city": "NewCastle",
"state": "Tyne and wear",
"country": "United Kingdom",
"postcode": "Ne270ut"
},
{
"city": "Leeds",
"state": "Yorkshire",
"country": "United Kingdom",
"postcode": "Ne128nh"
}
],
"secondary": [
{
"city": "London",
"state": "London",
"country": "United Kingdom",
"postcode": "Ls270ut"
},
{
"city": "Manchestor",
"state": "Manchestor",
"country": "United Kingdom",
"postcode": "Ma128nh"
}
]
}
]

Thanks a lot sir , it really gave me a solution to one of my high priority task in my project.

Thank you Raghav, this entire Rest Assured series is very useful and full of details to understand the basics for API automation. Thanks as lot and keep up the great work you are doing.

You did not mention how you can use excel data in Rest Assured

I was ZERO with API testing, now , I know at least basics

Nice explanation!
I always like the way you explain complex things with simple easy steps.
XFFS is so easy and straight forward. HSSF has unnecessary steps and complications! :-)

Best Tutorials I have ever watched. Very helpful. Thank you very much.

Great Teacher

Hi Raghav , today have completed all five videos though it was late awesome teaching learnt valuable concepts Thank you so much is this five videos are sufficient work with Rest Assured or do i need to watch any videos expect Rest assured beginners ?

It was a good tutorial , but just I want to know , how we can use this values from excel for Post?

pojo class why not used

Hi Ragahv pls create one framework video for rest assured using cucumber BDD

Hi Raghav, there are only 5 videos. Is it enough for API testing ?

Awesome explanation, thanks lot

I enjoyed all 5 videos sir. I would like to say in the last video of DDT with excel I thought it would have done by loop rather manually typing the rows and columns. Thank you so much

Thanks a ton Raghav for coming up with Rest Assured Series, Very neatly composed & explained with ease !! It will be very helpful if you add about JSON parsing & OAuth for this series !! You are doing great job for the Testing Community, kudos to you Raghav !!

Hello Raghav,
Can you do a short video with how to iterate over all the users from the excel file and add them all at once? Thanks.

It is very good to see that covering all the things including the basic commands and do it frequently in every session is phenomenal. Hatt's Off to your dedication and Humbleness, Thank U Raghav Sir🙂.

Hi Raghav...your way of explanation is really amazing. Could you please create a video on creating an excel and writing the data into it through Rest Assured? That will be really helpful

Where to get free excel for mac? LOL.