GlideStats Basketball is a ServiceNow application built using the balldontlie.io API open source project. balldontlie.io is a free API with no signup or key required, so all you need to do is install this application and you can get started.
Features:
-Translates all endpoints available on balldontlie.io into easily usable functions on the ServiceNow platform
-Visualize and analyze NBA data using the power of ServiceNow's dashboards, lists, and reporting
-Automated daily job grabs all game data and player statlines from the previous day, and updates season average records for all players who played. It will also automatically update a player's current listed team if they are traded or change teams, and create new Player records for anyone making their NBA debut.
-Recommended setup script automatically grabs all current NBA teams, all NBA players since 1979, game data since the beginning of the 2020 season, and all player statlines for the previous month
-All calls have built in wait timers as to not exceed the balldontlie.io rate limit of 60 calls per minute.
After installing the app, it is strongly recommended that you execute the on demand scheduled job called "Recommended Initial Setup". This can be found at https://<base_url>.service-now.com/now/nav/ui/classic/params/target/sysauto_script.do%3Fsys_id%3Dc24bab23474211106dc4e357536d43d6
There is a script library called BasketballUtils that does most of the heavy lifting. You can leverage the functions here to pull in whatever NBA data you want; 1979 to present day. balldontlie.io API game stats are updated every ten minutes.
BasketballUtils functions:
getTeams() - Retrieves all current NBA teams and saves the data to the Teams table. Example usage: new BasketballUtils().getTeams();
getAllPlayers() - Retrieves all NBA players from 1979 to current day and saves the data to the Players table. Example usage: new BasketballUtils().getAllPlayers();
getGamesByDate(date) - Retrieves information about all games played on a single date and writes the data to the Games table. Example usage: new BasketballUtils().getGamesByDate('2022-04-28');
getGamesByDateRange(date1, date2) - Retrieves information about all games played during a date range and writes the data to the Games table. Example usage: new BasketballUtils().getGamesByDateRange('2022-01-01', '2022-03-31');
getPlayerStatsByGame(id) - Retrieves all player statlines for a game and writes the data to the Player Game Stats table; Game ID can be found on the Games table after running getGamesByDate() or getGamesByDateRange(). Example usage: new BasketballUtils().getPlayerStatsByGame('22194');
getGameIDsByDate(date) - Retrieves an array of all game IDs for games played on a specific date. Example usage: var ids = new BasketballUtils().getGameIDsByDate('2022-04-28');
getGameIDsByDateRange(date1, date2) - Retrieves an array of all game IDs for games played during a range of dates. Example usage: var ids = new BasketballUtils().getGameIDsByDateRange('2022-01-01', '2022-03-31');
getYesterdayStatsForAllPlayers() - Retrieves all player statlines from games the day before. If Game records have not yet been retrieved for the previous day, they will automatically be created. If any Player records do not exist for games played (NBA debut), they will automatically be created. Example usage: new BasketballUtils().getYesterdayStatsForAllPlayers();
getAllPlayerStatsByDate(date) - Retrieves all player statlines for a specific date. If Game records have not yet been retrieved for that day, they will automatically be created. Example usage: new BasketballUtils().getAllPlayerStatsByDate('2022-04-28');
getAllSeasonAvgForPlayer(id) - Retrieves season average records for every year for a single player, and saves the data to the Season Averages table; ID can be found on the Players table. Example usage: new BasketballUtils().getAllSeasonAvgForPlayer('322');
getSingleSeasonAvgForPlayer(season, id) - Retrieves a season average record for a single year for a single player, and saves the data to the Season Averages table. Example usage: new BasketballUtils().getSingleSeasonAvgForPlayer('322');
getUpdatedSeasonAvgs() - Retrieves updated season average record for all players who played yesterday, and saves the data to the Season Averages table. Example usage: new BasketballUtils().getUpdatedSeasonAvgs();
getGamesPlayersStatsByRange(date1, date2) - Retrieves all games, players, and statlines for a range of dates. I recommend keeping your range to a month or less, as this call can take a while due to API limits. Example usage: new BasketballUtils().getGamesPlayersStatsByRange('2022-01-01', '2022-01-31');
getPlayerStatlinesByYear(id, year) - Retrieves all single-game statlines for a player for an entire season, and saves them to the Player Game Stats table. Example usage: new BasketballUtils().getPlayerStatlinesByYear('322', '2021);
Please email me at glidestats@kyle.ws or post to the Github Discussions tab with any comments or questions.