Script

Character Audit Script

Google spreadsheet automated audit of every player details in the World of Warcraft guild.

Overview

A quick look at general information about the project with a brief description of the development process.

Project

A script that automate process of retrieving information from Blizzard WoW API about players characters. It receives raw data, run checks and validation on every character statistics and provide with clean visualisation of how each player is progressing with the game content with cached results. As a client i used google spreadsheets for displaying results in tabs.

Project difficulties

The main challenge was to retrieve data from API, go through API authentication, and understand documentation. At the same time, it was my first time with JavaScript. As I did not use a typical client, debugging was problematic.

Solutions

For HTTP requests I used Postman to check the received data. I wrote code in Sublime to have at least code highlighting. From a JavaScript perspective, I tried to stick to basic syntax which allowed me to list, check and display the pieces of information I needed. So the goal was not to be focused on code structure, but on functionality. Because of API requests limitation, every query was cached for fifteen minutes.

Notable features

  • Getting data from official Blizzard API.

  • Process data with validation and custom checks.

  • Automatic display using google sheets as a client.

  • Cached data for performance boost.

Tech stack

  • JavaScript

  • Blizzard API

  • Google Sheets

GET IN TOUCH

Contact

Want to reach out about a project, collaboration, or just want to say friendly hello?

Message not send