EXCEL API AUTOMATION FRAMEWORK Framework for Fast API

INTRODUCTION • Java – Rest Assured – Excel based Framework • Developed for Simplifying

SCOPE • Request Type : GET, POST, PUT and DELETE • Header Authentication /

FRAMEWORK • Excel file will have all API Test Information • Framework will read

EXCEL FILE • Excel File will have Test Case Details like Name, End Point,

ADVANTAGES • No coding knowledge required except the initial setup • Anyone who is

Slides: 9

Download presentation

EXCEL API AUTOMATION FRAMEWORK Framework for Fast API Automation Scripting with just a line entry in Excel - Suseela. S

INTRODUCTION • Java – Rest Assured – Excel based Framework • Developed for Simplifying API Automation and Reduce Development Time • Anyone who is NOT having scripting knowledge can do API Automation • Extent Reports for Emailable Reports

SCOPE • Request Type : GET, POST, PUT and DELETE • Header Authentication / Certificate Authentication • All type of Input Methods (Query/Path/Form parameters) • Status Code Validation • Schema Validation • Data Integrity Testing • Detailed Reporting

FRAMEWORK • Excel file will have all API Test Information • Framework will read Excel file and run that as a API Test • Test Results will be logged using Extent Reports

EXCEL FILE • Excel File will have Test Case Details like Name, End Point, API Method, Input Data, Input Type, Status Code to verify, Schema File to Verify, Header method required for Authentication and Data Integrity Testing method. • Based on the above data, API Test will be generated automatically and run using Rest Assured

OUTPUT REPORTING

DEMO

ADVANTAGES • No coding knowledge required except the initial setup • Anyone who is not having Automation Knowledge can do API Automation with this Framework • Just a line entry in excel is enough to add new API for Testing • Development time is very minimal for API testing using this Framework • Easily Scalable

THANK YOU