Industry: Business Intelligence
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.
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.
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.