Read an NFL player's game log

A game log is one player's per-game stat lines with the game context joined back in. Resolve the season, index its games by id, borrow a player from one game's box score, then page that player's stats and join each row to its game.

1.Resolve the current season

const season = (await api.nfl.seasons.list({ limit: 200 })).seasons
  .reduce((cur, s) => (s.start_year > cur.start_year ? s : cur)).start_year

The complete program

Every step as one runnable file. It reads STAT_API_KEY from the environment, and is the same file that ships in the cookbook project for each SDK.

import { StatApi, type NFLGame, type NFLGamePlayerStat } from '@stat-api/client'

const api = new StatApi() // reads STAT_API_KEY from the environment

// Resolve the current season
const season = (await api.nfl.seasons.list({ limit: 200 })).seasons
  .reduce((cur, s) => (s.start_year > cur.start_year ? s : cur)).start_year

// Page the season's games
const games: NFLGame[] = []
for await (const row of api.nfl.games.iter({ season_id: season })) games.push(row)

// Index games by id
const game_by_id = new Map<number, NFLGame>()
for (const row of games) game_by_id.set(row.id, row)

// Borrow a player from one game's box score
const seed = (await api.nfl.game_player_stats.list({ game_id: games[0].id, limit: 1 })).game_player_stats

// Page that player's game log
const gamelog: NFLGamePlayerStat[] = []
for await (const row of api.nfl.game_player_stats.iter({ player_id: seed[0].player_id })) gamelog.push(row)

// Print the game log
console.log("NFL game log (fantasy points)")
console.log(["game_time", "fantasy_pts"].join('\t'))
for (const row of gamelog) {
  console.log([String(game_by_id.get(row.game_id)?.game_time ?? row.game_id), String(row.fantasy_pts ?? '')].join('\t'))
}