Build the MLB standings

season_team_stats has one row per team per season — wins, losses, games played. Resolve the current season, page the whole table, and sort by wins to build the standings.

1.Resolve the current season

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

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 MLBSeasonTeamStat } from '@stat-api/client'

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

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

// Page every team's season record
const rows: MLBSeasonTeamStat[] = []
for await (const row of api.mlb.season_team_stats.iter({ season_id: season })) rows.push(row)

// Order by wins, best first
const standings = [...rows].sort((a, b) => b.wins - a.wins)

// Take the top ten
const top = standings.slice(0, 10)

// Print the standings
console.log("MLB standings — top 10 by wins")
console.log(["team_id", "wins", "losses"].join('\t'))
for (const row of top) {
  console.log([String(row.team_id ?? ''), String(row.wins ?? ''), String(row.losses ?? '')].join('\t'))
}