API/Webservices Testing using RestAssured Part-3 | Data Driven Testing

Topic : Data Driven Testing

#########################
Udemy Courses:
#########################

Manual Testing+Agile with Jira Tool
************************************

Selenium with Java+Cucumber
********************************

Selenium with Python & PyTest
********************************

Selenium with python using Robot framework
****************************************

API Testing(Postman, RestAssured & SoapUI)
*****************************************

Web & API Automation using Cypress with Javascript
********************************************

Playwright with Javascript
**************************

Jmeter-Performance Testing
************************

SDET Essencials(Full Stack QA)
*************************

Appium-Mobile Automation Testing
************************************

Java Collections
*****************

Python Programming
*********************

Cucumber BDD Framework
***************************

Protractor with Javascript
***************************

####################################
Youtube Playlists:
####################################

Manual Testing & Agile
***********************

SQL
*************************

linux & Shell Scripting
**********************

Java
**********************

Selenium With Java+Cucumber
********************************

Python
********************************

Selenium With Python,Pytest&Behave
***************************************

Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************

API Testing (Postman,SoapUi,&Rest Assured)
**********************************************

Mobile App Testing Appium
****************************

Performance Testing Jmeter
*******************************

Maven,Jenkins,Git,Github,CI/CD
*******************************

SQL,DB Testing&ETL,Bigdata
*******************************

JavaScript Based Automation Tools
********************************

Selector Hub Tools
********************

GraphQL
******************

Cypress API Testing
********************

Cypress Web Testing
**********************

Playwright with Javascipt
**************************

#APItesting
#RestAssured
#APITestAutomation
#WebServicesTesting
#RestAPIs
#AutomatedTesting
#APIAutomation
#TestAutomation
#SoftwareTesting
#QAEngineering
#APIQuality
#APIIntegration
#APIEndpoints
#APIValidation
#APIRequest
#TestingTools
#APITestScripts
#ContinuousTesting
#QualityAssurance
#WebServicesAutomation
#PostmanTesting
#APIPerformance
#TestingFrameworks
#APIValidation
#TestScripts
#APISecurity
#RegressionTesting
#APIAssertions
#AutomationEngineer
#DevOpsTesting
#APIResponse
#TestingStrategies
#CodeTesting
#AgileTesting
#TestDrivenDevelopment
#IntegrationTesting
#CI_CDTesting
#TestFrameworks
#APIHealthcheck
#TestAutomationStrategy
#APIContractTesting
#LoadTesting
#APIStubs
#TestDataGeneration
#APIChallenges
#CodeQuality
#APIAnalytics
#TestingBestPractices
#APIManagement
#QualityEngineering

[EliasHossein]

Crystal clear explanation of how to read excel data as well as everything !

[ashwinikhanna]

Your content is great....
When I play your video at 0.85 speed I find it normal!

[nkr]

Sir, thank you very much for putting up a very informative video explaining data driven testing with restAssured automation. This comes as a great avenue of help for many of us learning rest api automation. I would like to express my gratitude for it, Thank you.

[pranaymudi]

Your tutorial is very helpful to gain knowledge

[mzamomahaeng]

excellent video. Using testNG data provider with apachr poi🙏🙏🙏👌🏾👌🏾thank you sir for the masterclass

[modupallimadan]

Nice one, thank you for sharing such kind of knowledge.

[shubhamwakhare]

Hi sir this session help me a lot thank u sir

[janvi]

Excellent training learned rest assured in couple of days..ausum..keep going

[prabhakaran-fjsc]

Great explanation. Kudos to all the efforts

[basavaraj]

Session help me a lot sir.. Thank you so much.

[VibewithVR]

Hi Sir, how to export the response data. After executing all API's need to share all Request and Response to manager so please tell me how to do that?

[lokapavanikoduru]

hi Pavan, why do we need use http client ? (doubt).can we use RestAssured given (), when(), then(), and() methods to write the same code.

[prabhakaran-fjsc]

You can access the XLUtility.java from the below location:

[aliostad]

Very informative. Could you please share the XlsUtils.java file along with XLS file.

[srinathmurthy]

Hi Sir, Thanks for the video. As part of Data driven test it would be great if you can also cover the scenario which can save the API response to the same excel associated to the given data. kindly share the link please if possible.

[syedfaruk]

Hi Everyone,


First of all Thanks Pavan for such an amazing and informative training provided. Secondly while i was working on the data driven video where my data provider reads the data from an excel sheet, i tried to execute the code and i get the error below. I checked it many times but still the issue occurs. Please help me as i am stuck here and unable to understand. Following is the error i see in my console.


FAILED: Data_Driven_Test

[public void Rest_Assured_API_Testing.Data_Driven_DataProvider_Static.Data_Driven_Test(java.lang.String, java.lang.String, java.lang.String)] has no parameters defined but was found to be using a data provider (either explicitly specified or inherited from class level annotation).
Data provider mismatch
Method: Data_Driven_Test([Parameter{index=0, type=java.lang.String, declaredAnnotations=[]}, Parameter{index=1, type=java.lang.String, declaredAnnotations=[]}, Parameter{index=2, type=java.lang.String, declaredAnnotations=[]}])
Arguments: [(java.lang.String) Rithesh, (java.lang.String) 30000, (java.lang.String) 29, (java.lang.String) ]
at
at
at
at
at
at
at
at
at
at
at
at
at
at
at
at
at
at
at
at
at
at
at



Default test
Tests run: 1, Failures: 1, Skips: 0




Default suite
Total tests run: 1, Passes: 0, Failures: 1, Skips: 0

[sarathethiraj]

Hi Pavan

This video is awesome. Can you please tell me how to take sample request from folder and edit the request with multiple test data using Json path and save the request in any folder and post that request.

[smithapatil]

Hi Pavan,

Could you take some complex request structure and build the requestbody for POST method? It will be very helpful for us.

Thanks

[vlads]

I need to run the collection consisting of 4 requests, but only request #3 will use data from excel.
How do i make requests #1, #2, #4 execute the same number of times as request #3 ?
Thanks for assistance

[balinarao]

Hi pavan.i need small help .you showes json having only single type parameters.like { "empid":"1234",
"empname":"qwewe"}.But some jsons having list of values like { "empid":"1234",
"empname":"qwewe", empaddress [ "city":"hyderabad", "picode": "23232"] } then how to read these type of json from xl sheet.could you please help me