Automate WebServices Rest API (testing) using Java

Discover how web services enable cross-platform communication by exchanging requests and responses between vendors and aggregators, illustrated with travel bookings and bank apis, using Java and rest services.

Explore soap web services and rest api concepts, comparing xml-based soap requests with rest services, and learn how wsdl describes soap apis for Java automation.

Explore how rest APIs use get, post, put, and delete for create, read, update, and delete, contrast with soap and WSDL, and note rest is stateless and json-based.

Discover how maven uses pom.xml to manage jar versions for test automation, enabling consistent dependencies and a streamlined maven project setup in Eclipse for api testing.

Set up a maven-based rest api test project by configuring pom.xml, adding testng, rest assured, json-path, and json-schema-validator dependencies, and using testng.xml to manage test suites with automatic jar downloads.

Set up a Maven-based Java project for rest API testing by configuring pom.xml dependencies for Rest Assured, JSON, and Jackson, and learning to download and manage jars from Maven repository.

Demonstrates a Java Rest-Assured get request test for a weather API, fetching by city name, and validating status codes 200 and 401 while parsing the response to verify success.

Learn to write your first GET request test for a REST API using Rest Assured in Java; implement a simple GET call with a city parameter and validate status codes.

learn how to use rest-assured to make parameterized get requests and validate api responses, including status codes like 200 and 201, with practical authorization concepts.

Learn to test rest APIs with java using rest assured by passing city and appid parameters in a get request, verify 200 responses, and automate API checks across multiple scenarios.

Learn to handle get requests in rest api testing with Java by parsing json responses. Fetch current weather data using city name or id and validate status.

Learn how to use json path to locate elements in a json structure, calculate all authors, and access book details in a store with index-based queries.

Learn to construct complex data queries for rest api testing by navigating a book store: select, order, and filter books using head, store, minus operations, isbn presence, and price conditions.

Learn how to verify API responses with Rest Assured by checking content-type, extracting JSON fields such as weather description, and comparing actual results to expected reports to ensure correct behavior.

This lecture demonstrates testing a rest api by retrieving weather reports via city id and via latitude and longitude, then comparing responses and extracting json data for verification.

Install and configure a local API server for testing web services, then launch it to test endpoints on localhost:3000, using get, post, update, and delete operations.

Automate post requests with a string body and content-type, send updates to a rest api, and verify results using subsequent get requests and json data in java.

Learn to perform a post request by sending a Java object as the request body, using getters and setters for id, title, and author, with content-type JSON and object-based payload.

Explore how to use put requests to update existing entries in a rest API, and how post requests create new entries in the database, using json payloads and content-type headers.

Explore patch requests for updating existing entries by sending only the changed fields, avoid null values, and compare with post requests that create or replace entire records, using json content-type.

Learn how delete requests remove records from a database in REST API testing with Java, including sending delete calls, types of delete requests, and handling unclear API documentation.

Generate complex objects for post requests in Java rest api testing. Build nested data models, configure json payloads, and send post requests to validate api behavior.

Learn to post arrays of objects in a java rest api, building address and post data classes, sending json payloads with application/json, and testing responses as data grows.

Use the latest rest-assured library to measure api response time in milliseconds during get requests and validate it against a threshold such as 800 ms.

Create a relational database table for REST API (testing) in Java, defining an employee table with id, first name, last name, and country, using create table in a chosen database.

Insert data into the employee table using insert statements, adding records with id, first name, last name, and country. Run and verify the script shows rows inserted, totaling six records.

Explore how to delete a table by issuing drop table employee. The employee table will be deleted within the database.

Learn how to add a new column to the employee table by altering the table with SQL, naming it test, and selecting all rows to verify the addition.

Learn to drop a column from an employee table using the alter table statement, confirming the test column is removed and the table reflects the change.

Modify a column's data type from numeric to character in a test database for the employee table. Note Oracle screens and sql dialect nuances.

Update a table record by setting the first name, last name, and country for a specific employee using employee id 1205.

Learn how to delete a database record using delete from with a where clause, specifying conditions like employee_id and country, then verify deletion with a select query.

Explore de-select and simple select statements, including the distinct option, to retrieve data from an employee table. Learn how to print all data or select specific columns like employee_id and country.

Learn how to use the distinct select statement to fetch unique values from a column, preventing duplicates in results and applying it to a sample country column.

Learn how to use the where clause in SQL to filter records in employees table, selecting all or specific columns and applying operators like =, >, <, >=, and <=.

Learn to use the OR operator in SQL where clauses to filter records by employee id 1205 or 1206 and by other columns such as last name.

Learn how to apply the where clause with and to filter records by country is India and employee ID equals 1205, requiring both conditions to be true.

Explore using the not operator in a SQL where clause to filter records, excluding specific values such as priority or employee IDs, and return only the matching results.

learn how to sort data with order by, applying ascending or descending on a column such as employee id or first name, with default ascending behavior.

Discover how to limit query results with top and rownum, showing the top n rows from an employee table, including examples for top three and rownum for two.