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

[@shyamsunder123]

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.

[@RaghavPal]

Thanks a ton Rudra

[@AniketShinde3211]

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🙂.

[@RaghavPal]

Most welcome Aniket

[@thejaswinilokesh7194]

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

[@RaghavPal]

You're very welcome Thejaswini

[@janziomek9172]

Thank you for providing this very usefull topic !!! I like your perfectionism and good teaching skills (talking what are you doing for instance saying "now I'm using ctrl+a to select all and then ctrl+i to make it look better" or something like this. I really appreciate it ! regards from Poland !

[@RaghavPal]

You're very welcome Jan, I will definitely visit Poland to teach someday

[@janziomek9172]

@@RaghavPal be my guest :D

[@ZehraKhatoon-zz1nq]

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

[@RaghavPal]

Thanks Zehra. this will help you - kzbin.info/www/bejne/eGWqY6eDeb6diLM

[@prashantarakeri6881]

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 !!

[@RaghavPal]

Most welcome Prashant

[@abhisharma85]

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.

[@RaghavPal]

Most welcome Abhishek

[@pratiksachani7095]

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

[@RaghavPal]

Most welcome Pratik

[@navyaa301]

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

[@RaghavPal]

Thank you, I will Navya

[@luvdekabal]

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.

[@RaghavPal]

Most welcome Krish

[@laxmikanthluckylucky]

Hi Raghav, Your tutorials are very clear and easy to understand. Can you please create some videos on the Rest-Assured framework level. Thanks.

[@RaghavPal]

Will upload soon Laxmikanth

[@aruns5896]

Thanks Ragav,Nice Video.Please add more videos in data driven testing using Rest Assured with real time examples (Excel and DB).It would be more helpful

[@RaghavPal]

Hi Arun, I will do

[@Ronik0201]

Awesome tutorial Raghav. Your teaching skills is amazing. Easy to understand and also you covered tiny things 👍

[@RaghavPal]

So happy to know Rohit

[@nalinithiagarajan896]

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?

[@RaghavPal]

Hi Nalini, will plan for it

[@rijojohnpatric9642]

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

[@RaghavPal]

I will try Rijo

[@abiaiye27]

Why do we use the ooxml(open office) version of the Apache POI over the others? Thanks

[@RaghavPal]

This one has all the features we generally require. NOt sure of other specific reasons

[@abiaiye27]

Automation Step by Step - Raghav Pal thanks

[@ChandanDas-dn8pj]

Nice video . Helped me a lot . you are doing a great job helping others with sharing your knowledge and experience.

[@RaghavPal]

Glad to hear that Chandan

[@supriyagawand2809]

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

[@RaghavPal]

Thanks Supriya, I will plan a video for this soon

[@vishallokhande6179]

Nice explanation...Thanks Ragav

[@RaghavPal]

Most welcome

[@ChandraSekhar0085]

Nice & cool presentation. Thanks Raghav

[@RaghavPal]

So nice of you Chandra

[@bharathlc7731]

Hi Raghav , Thank you so much for explaining it so neatly and effectively. I'm eagerly waiting for the next videos. When can we expect it ?

[@RaghavPal]

As soon as possible Bharath

[@ayushdeepdwivedi952]

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

[@RaghavPal]

Great to know Ayush

[@shwetakatare24]

Your all tutorial are very very very helpful 🎉🎊

[@RaghavPal]

Glad to hear that Shweta

[@jackkate001]

Awesome explanation, thanks lot

[@RaghavPal]

Most welcome

[@shadowfrost420]

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.

[@RaghavPal]

Thanks Arun for your kind words, I will plan a session on this

[@raajijeeru1972]

Once again best session and explanation. Thanks you @Raghav

[@RaghavPal]

Always welcome Raaji

[@miketysonschwarzeneggerpra9215]

Hi Raghav,thanks you so much for explanation. Please , many difficult find video with explanation about testing a API Rest. For example. How testing API Rest How validate API Rest. What is important testing in a API Rest. ... Step by step how testing API Rest,please make video . Thanks Mike (Brazil)

[@RaghavPal]

Will upload soon Mike

[@Ramesh00744]

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..

[@RaghavPal]

Hi Ramesh, I have videos on read - write excel - kzbin.info/www/bejne/eGWqY6eDeb6diLM

[@mayankjain9941]

Hi Raghav, thank you so much for the explanation. Can we read data from the database also for Rest Assured API Testing? If yes then could you please add video for that.

[@RaghavPal]

Yes we can Mayank, Will plan to add a video

[@adititripathi7422]

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

[@RaghavPal]

As soon as possible Aditi

[@surajdate2259]

Thank a lot for making and sharing videos. Thank you Raghav!

[@RaghavPal]

You're welcome Suraj

[@keerthiganesh400]

Great Teacher

[@RaghavPal]

Thanks Keerthi

[@vickyhiwarkar89]

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

[@RaghavPal]

Hi Vikcy, I will try to do a session on this, For now, can check this - medium.com/@Saranya_Ganesan/data-driven-testing-using-restassured-read-and-write-data-to-excel-973b6a3913eb

[@saraswatiyaliwal4498]

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 ?

[@RaghavPal]

Hi Saraswati, so happy to know this, These videos will be enough for getting started with any Rest Assured project and then based on the project or API needs you can add more over this

[@svetlanamazhaykina6918]

Thank you Raghav! Good job!

[@RaghavPal]

So nice of you Svetlana

[@Fei-D]

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!

[@RaghavPal]

So happy to know, Yes more tutorials will be coming soon

[@Aj21093]

You are an awesome teacher.

[@RaghavPal]

Glad you think so Anukriti. Humbled

[@bhaumik17able]

Easy to follow. Thank you Raghav sir.

[@RaghavPal]

You're welcome

[@ievgeniikravtsov1597]

Thank you for the helpful video!

[@RaghavPal]

Glad it was helpful!

[@siddharth8628]

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

[@RaghavPal]

I will plan Punamiya

[@Bell4Fun]

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

[@RaghavPal]

great to know Som

[@bharathlc3069]

Hi Raghav , can you please upload the remaining videos ? I'm planning to learn this skill before quarantine ends.. It would be of a great help..

[@RaghavPal]

I will plan to add Bharath

[@ashwinikhanna]

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! :-)

[@RaghavPal]

Hi Ashwini, thanks for watching

[@postakshrestha4527]

Thank you for your enormous works! Do you have a video to run the tests in suite with chained tests, pretty much like in Postman where you can grab the value from the response of a previous test and use that in the following test for update or delete?

[@RaghavPal]

I will be doing that video in some time

[@kawasakyl4040]

Hi Raghav,Thanks for your nice teaching.Can you please add videos for pojo classes and authentication topics as well.

[@RaghavPal]

Sure, I will add

[@kawasakyl4040]

ok thanks

[@soumyabanda3834]

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 .

[@RaghavPal]

Hi Soumya, this can help - kzbin.info/www/bejne/eGWqY6eDeb6diLM

[@soumyabanda3834]

@@RaghavPal hi Raghav. .I have gone through that already. .which is much about reading data from Excel. .but I want to see how to update the response after successful validation back to excel. .thank you anyways I will try to check once again. .thanks for the quick response. .

[@RaghavPal]

Okay Soumya, I will plan a session on this.

[@soumyabanda3834]

@@RaghavPal Thank you so much Raghav

[@bibhasdebbarman2800]

Hi Raghav, Great explanation. Can you please create videos on different type of authorization with Rest Assured

[@RaghavPal]

I will do Bibhas

[@testcotesto2361]

Hello Raghav Sir, Thank you for this tutorial. Its really very helpful. Quick question: Could you please show how to pass authentication/Authorization info like creds/ tokens required for API testing in Rest Assured.

[@RaghavPal]

Hi, I will add a session on that

[@testcotesto2361]

@@RaghavPal Thank you. Looking forward for more great sessions

[@karthickumar117]

Kindly put more videos on rest assured

[@RaghavPal]

Sure, I will do, find all here - automationstepbystep.com/

[@sidb2023]

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

[@RaghavPal]

HI Siddharth, do you have more info in the logs like Caused by

[@dragos0285]

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.

[@RaghavPal]

Sure Dragos, sure I will do, for now you can follow these steps: Add the Apache POI library to your Eclipse project. You can download the library from the Apache POI website and add it to your project's build path. Create an Excel file with the user data you want to add. For example, you can create a spreadsheet with columns for "username", "email", "password", etc. and rows for each user. In your Java code, create a new FileInputStream object to read the Excel file. For example: FileInputStream file = new FileInputStream(new File("path/to/excel/file.xlsx")); Create a new XSSFWorkbook object to represent the Excel workbook, and retrieve the first sheet from the workbook. For example: XSSFWorkbook workbook = new XSSFWorkbook(file); XSSFSheet sheet = workbook.getSheetAt(0); Iterate over the rows in the sheet, starting from the second row (since the first row contains the column headers). For each row, create a new user object with the data from the row, and use Rest Assured to add the user to your system. For example: for (int i = 1; i

[@dragos0285]

@@RaghavPal I am spechless over your detailed and explicit example. I have managed to add the users. Thank you very much and respect for all the work effort you are doing with these videos.

[@krishnamurthyyarram6768]

Hi Raghav You are awesome .Thanks a lot for sharing the knowledge .Eagerly waiting for next videos or is it the last video for this series?

[@RaghavPal]

Will come soon Krishna

[@krishnamurthyyarram6768]

@@RaghavPal thank you Raghav

[@yogeshyog9215]

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.

[@RaghavPal]

Noted, I will plan Yogesh

[@mariacortezano7576]

Hi Raghav, I tried to add the poi-ooxml as dependency but getting error upon saving the pom, getting below error and stating lots of missing artifact - Failed to read artifact descriptor for org.apache.poi:poi-ooxml:jar:4.1.2, checking if you can help me with this? Thank you.

[@RaghavPal]

Hi Carla, Please try 1. Menu > Project -> Clean 2. Restart Eclipse 3. Disable then re-enable dependency management (right-click Maven -> Disable Dependency Management then Maven -> Enable Dependency Management 4. Close and Reopen Project 5. Project -> Run as -> Maven Build -> Set goals as clean install -> Select options Update Snapshots Debug Output Non Recursive Resolve Workspace Artifacts -> Apply and Run 6. Repeat Step 5 after removing dependencies from ~/.m2/repository 7. Check that your Maven settings are configured correctly. If you are behind a proxy you'll need to configure the proxy settings in the global or user settings.

[@themohitwa]

Hi Raghav, great video. Could you please add the part where will be able to send this data from excel into DataProvider. From this video we have seen the utility to read excel but then to be able to send it into dataProvider would have been very useful from the restAPI automation perspective. Thanks in advance.

[@RaghavPal]

I will do Mohit, although I have covered this process in Selenium Java playlist here - kzbin.info/aero/PLhW3qG5bs-L8oRay6qeS70vJYZ3SBQnFa

[@themohitwa]

@@RaghavPal Okay thankyou :)

[@nikhilkanojia1683]

hi Raghav, how to pass the dynamic rows and columns instead of hardcoding it, as per the below code? excel=new ExcelUtils(excelpath, sheetname); excel.getRowCount(); excel.getCellData(1, 0); excel.getCellData(1, 1); excel.getCellData(1, 2);

[@RaghavPal]

Hi Nikhil, you can use conditional and loops as per your needs. This can be helpful - kzbin.info/www/bejne/eGWqY6eDeb6diLM

[@MrNeeleshp]

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?

[@RaghavPal]

Hi Neelesh, can check here github.com/Raghav-Pal/REST-assured_Project github.com/Raghav-Pal/REST-assured github.com/Raghav-Pal/REST-assured-demo Will check on JMeter Java Scripting Can find all here - automationstepbystep.com/

[@MrNeeleshp]

@@RaghavPal Thankyou Raghav. Raghav, if i want to be your assistant in udemy teaching.....where i can solve the students query regarding selenium.... How i can apply for that?

[@RaghavPal]

Hi Neelesh, are you looking for a voluntary work? Pls send your details at [e-mail]

[@MrNeeleshp]

@@RaghavPal Sent Raghav. Thankyou

[@Gopal2709]

Hi Raghav , Excellent presentation , worth all the time spent . Can we send the entire JSON payload using excel parameterization and make a post it would make life easier also can you cover connecting db and asserting the response value from the DB with response payload , it would be a great value add to this course , thank you

[@RaghavPal]

I will plan to cover these Gopal

[@Gopal2709]

Thank you Raghav

[@SureshKumar-xh7kv]

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

[@RaghavPal]

Hi Suresh, I will plan a session, you can also check some online examples

[@AmanSingh-gs4ue]

Hello Raghav Sir I have completed watching your awesome playlist on Rest Assured and also I have coded along with your videos...now after completing the playlist I do not understand what should I do next to learn further, I want to learn RestAssured really very nicely as it is needed in my work..please do reply sir. And Thanks alot for this wonderfull tutorials.

[@RaghavPal]

Hi Aman, I will be adding more tutorials in some time. You can check other sections meanwhile, here - automationstepbystep.com/

[@AmanSingh-gs4ue]

Thnx alot !!!!will be waiting for those tutorials very eagerly.......please try to make those tutorials in such a way that it can mimic like working in a real life project....Thanks again for your reply....keep up the good work!!!!

[@indsrats8833]

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.

[@RaghavPal]

Hi, what is the error message you get, Check the logs, Can also try using a diff ver of apache poi

[@juanox31]

Try with apache POI poi dependency I downloaded 5.0.0 version and it worked

[@amitbhardwaj7824]

nice video keep uploading bro

[@RaghavPal]

Thank you, I will Amit

[@mayankmadhur4630]

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

[@RaghavPal]

ok Mayank

[@satyadurgadeviv503]

how to run the test multiple times using excel data(for all the rows) like we did in data provider?

[@RaghavPal]

I will plan a session for this Satya

[@satyadurgadeviv503]

@@RaghavPal thank you

[@nemakalsudhirchakravarthi4311]

Thankyou Raghav...

[@RaghavPal]

You're welcome

[@engineernaveedrehman258]

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

[@RaghavPal]

No Naveen, Check the API Automation section here - automationstepbystep.com/ I will be adding more videos to REST-assured

[@engineernaveedrehman258]

@@RaghavPal sir in the given link there is only 5 videos for rest assured.

[@engineernaveedrehman258]

@@RaghavPal my question is hoe much syllabus is required for complete api testing for api automation testing?

[@RaghavPal]

Hi Naveed, if you talk about a complete API testing, then there are different tools and platforms, I have also created a Udemy course on this. Can check here automationstepbystep.com/udemy-discounts/

[@engineernaveedrehman258]

@@RaghavPal okay

[@maheshwarivachan287]

eagerly waiting for the next videos of rest assured

[@RaghavPal]

Hi Maheshwari, will do soon

[@bhaskar4222]

Hi Raghav, Thank you very much for sharing the knowledge in such an effective way.Great channel.One request however, please share some interview preparation guide/questions on Rest Assured

[@RaghavPal]

Sure Bhaskar, I will do

[@belodushiva156]

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.

[@RaghavPal]

Hi, they are under process and will be public in a few days

[@belodushiva156]

@@RaghavPal Thank you Sir

[@umap79]

Hi Raghav, Very interesting and thanks a lot for sharing, will you be uploading any mini project on API testing using rest Assured?

[@RaghavPal]

Yes, will do Uma

[@umap79]

@@RaghavPal Thanks so much Raghav. 😊

[@umap79]

Hi Raghav, I have a MS office installed in my system and created a testdata file, But im not getting those icons (under data) as yours, I have added apache poi dependency also. Please help

[@RaghavPal]

that is fine as long as it works, Else you can always get WP office

[@umap79]

@@RaghavPal Thank you raghav,

[@VaranasiVagabond]

Is this the end of rest api automation tutorial?? @raghav

[@RaghavPal]

Hi, I will be adding more tutorials, but can take some time.

[@ravindragogula6966]

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

[@RaghavPal]

Hi Ravindra, can check here - automationstepbystep.com/

[@ravindragogula6966]

@@RaghavPal Hi Raghav, I saw in that website, but don't have it there. I need rest-assured with the BDD framework from the scratch. Please let me know where it is...

[@RaghavPal]

Rest assured itself follows a BDD style, Let me know if you are looking for some exact BDD tools

[@ravindragogula6966]

@@RaghavPal Hi Raghava, Yes I am looking exact BDD tool with rest assured(API Testing). Using get, post, put and delete.

[@sampadachendake6337]

Hi Raghav, Thanks for this Session on REST ASSURED. Could you please make videos on How to Pass Payload, Authenticators like details which we need to provide as part of Requests ? Since as Real Time Examples this will be very much helpful to us. Also i am not aware about git source code for REST ASSURED, If you could share ?

[@RaghavPal]

Hi Sampada, yes I will do more sessions on this

[@deepanshuaggarwal7042]

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

[@RaghavPal]

Enough to get started with Rest Assured Deepanshu, you can find more API tutorials here - automationstepbystep.com/

[@jyothiniranjan2805]

My question was different. I have to register the customer and the in request payload I have parameters like list. SO, i have used JSONArray. But, here I have another question that is, I have to read the data from the excel sheet and register the customer details { "custName":"" "custPhno":"" "custAdd":"" ""Account":"List"[ "accno":"" ""acctype:"" ] } so for this account I have taken JSONArray for the remaining customer details, I have read the data from excel sheet using for loop but I don't understand how to add the code for this JSONArray for accout details. please help me on that.

[@RaghavPal]

Hi Jyothi, looks like you created a new comment, It helps if you reply over the same comment to set context and refer. I will try to create a session on this

[@miketysonschwarzeneggerpra9215]

Sensational, thank you .

[@miketysonschwarzeneggerpra9215]

Please, help me . Make tutorial automation testing mainframe with Java. Do you have anything tutorial? I need test api rest after validate in the mainframe data.

[@RaghavPal]

Not yet but I will try to do something in future

[@miketysonschwarzeneggerpra9215]

@@RaghavPal Thank you Raghav 😀

[@playwizyard]

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

[@RaghavPal]

Sure Mudit, these videos are in processing and will be public in a few days

[@sugyanpatnaik2098]

Hi Raghav, Is the final video of the series?

[@RaghavPal]

Hi Sugyan, I will be adding new videos in a week

[@sugyanpatnaik2098]

@@RaghavPal thanks Raghav for the information 🙂

[@automationseleniumjavabasi2841]

Hi Raghav, This 5 videos REST Assured API testing are enough for basic level?? please provide syllabus.

[@AmanSingh-gs4ue]

Hi can anybody tell me, that where do i need to implement the test methods and use the read data from xlsx file to test????

[@RaghavPal]

Hi Aman, with the capabilities to get data from excel, you can put data for parameters, body etc and use from excel in a data driven test

[@rajivmishra3042]

Hi Raghav, when I run this code, I get below error. Can you please suggest the solution. Exception in thread "main" java.lang.NullPointerException at utils.ExcelUtils.getRowCount(ExcelUtils.java:35) at utils.ExcelUtilsTest.main(ExcelUtilsTest.java:12)

[@RaghavPal]

Hi Rajiv, logs are not complete. Mostly the issue looks that you are not able to get your workbook or sheet. Just check the name and locations are correct in the code

[@sushanttavrawala8394]

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" } ] } ]

[@RaghavPal]

Hi Sushant, I will check the playlist and add,

[@sushanttavrawala8394]

@@RaghavPal thanks a lot

[@dja781]

Great content when will the other videos be uploaded

[@RaghavPal]

Will do very soon Devatha

[@dja781]

@@RaghavPal looking forward to it..

[@soumyabanda3834]

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

[@RaghavPal]

Hi Soumya, basically you need to read write values from and to excel. This can help kzbin.info/www/bejne/eGWqY6eDeb6diLM

[@Roneet18]

i am getting error as "localhosts refused connection" . what is the solution for this ?

[@RaghavPal]

Hi Sonal, It may be due to port issue. Try changing port. Can also read this - www.quora.com/Localhost-refused-to-connect-What-should-I-do

[@himanishkopalle3536]

Hi Raghav, I dont see your code on GitHub?! Could you please push it and update us ?!

[@RaghavPal]

I will do Himanish

[@ankaiahb3000]

The course is still there or not

[@RaghavPal]

Hi Ankaiah, next video will be coming soon. Check here - automationstepbystep.com/

[@ankaiahb3000]

OK...tnq

[@sadanandareddypernati5682]

​ @Automation Step by Step - Raghav Pal I am not able to see the REST Assured API testing to POST from the Excel using Data-driven. In this video only we can get the data from the excel using Data-Driven but not posted on the server.

[@alim241081]

pojo class why not used

[@RaghavPal]

can do that way

[@Open-Media]

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

[@RaghavPal]

I will add more sessions on that