Loading...

About Client

BI Plugin is a plugin which basically converts SQL queries into different charts/table format. The plugin converts SQL query results into JSON format and shows the values on screen as columns/rows. It also gives the facility to download those charts/tables in the desired format.

The requirement was to automate these features using Selenium.

Challenges

The requirement was to check whether the values returned by web service are shown correctly on screen or not. Sometimes application downloads corrupted file for one of the features. The challenge was to check whether the downloaded file was corrupted or not through automation script only.

The application allowed to access page only after valid login. So the challenge was to retrieve the data from Web Service response through automation script with authentication

The response was in JSON format so we need to parse the JSON format

Yet another difficult task was to get the latest downloaded file and its location

Our Solution

Proposed solution

We have used Java for writing automation scripts with Selenium. The Java code gets a response from the request provided. It then parses the JSON received according to the requirement and fetches required values.

We get the download preference (the folder where all downloaded files are stored) for the browser on which the script is being executed. From that directory, we get the latest downloaded file and check if it is corrupted or not.

Implementation

Get Response: Using Base64 encoding, we get authorization token for a user who has logged in. On passing the token in HttpURLConnection, the response is fetched in JSON format.

Parsing JSON: We have used JSONParser for parsing JSON and retrieving values.

Checking downloaded file: We get the last downloaded file from download location and then check the extension of the downloaded file. If it does not match with selected/provided list, the script throws an exception as a corrupted file. If the extension matches, we read that file with a different class for different extensions. If there is an exception while reading the file, we consider it as corrupted file and script throws an exception.

CS-CTA-1

Similar Project Idea?

Looking for automation testing. Our automation engineers help improve the quality of your software from every possible point of view.

Submit Request

Technologies & Tools

Selenium-Logo
Selenium

Our Process

Research-icon
  Research/Analysis

Our detailed and accurate research , analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.

Design_icon
  Design

We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.

Code_icon
  Coding

Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.

Testing
  Testing

Quality is at the helm of our projects. We leave no stone unturned in ensuring superior excellence and assurance in all our solutions and services.

Launch_icon
  Launch

We have a well-defined, robust, and secure launch criteria that offers us a successful implementation clubbed with detailed testing, customer acceptance and satisfaction.

Business Benefits

Reduce chances of human error and give accurate output

Check multiple combinations in less time compared to the manual execution

Find bugs at an early stage

Ensures cost-savvy, time-savvy automated testing at every step

CS-CTA-2

Looking For Something Similar?

We have worked with some of the best innovative ideas and brands in the world across industries

Connect With Us