{
  "info": {
    "name": "NFL Gridiron Intelligence Hub API (1999\u20132026)",
    "description": "Live Python v2 Azure Functions REST API querying **Azure SQL Database** (`broadmoorweather.database.windows.net` / `NFL`) across **28 NFL seasons (1999\u20132026)**, **23 normalized relational tables**, **7,548 games**, **16,666 players**, and **767,293 total rows**.\n\n## Highlights\n1. **Zero-Config Public Read Endpoints (`ANONYMOUS`)**: All read & analytics endpoints support CORS (`*`) and transparent `gzip` compression for payloads > 2 KB.\n2. **Smart Short-TTL Caching + Instant Bypass**: Read endpoints cache responses in worker memory for 30\u2013120 seconds to protect Azure SQL DTUs. Pass `?refresh=1` on any GET endpoint or call `POST /api/refresh` to force a fresh SQL query.\n3. **Automated Weekly Sync**: `nfl_weekly_tuesday_sync` runs every Tuesday at midnight Central Time (`0 0 0 * * 2`), pulling official NFL GSIS/nflverse schedules, rosters, 6-category box scores, and injuries, then recomputing standings and career rollups. On-demand sync is available via `POST /api/sync-nfl` (requires Function Key).",
    "schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json"
  },
  "item": [
    {
      "name": "Telemetry & Cache",
      "item": [
        {
          "name": "GET /api/health",
          "request": {
            "method": "GET",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/health",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "health"
              ]
            },
            "description": "Verifies live connectivity to Azure SQL (`broadmoorweather.database.windows.net` / `NFL`), returns the active Python SQL driver (`pyodbc` or `pymssql`), loaded season span (`1999\u20132026`), total game count, and per-table row counts from `sys.partitions`."
          },
          "response": [
            {
              "name": "200 OK \u2014 Sample Response",
              "originalRequest": {
                "method": "GET",
                "header": [
                  {
                    "key": "Accept",
                    "value": "application/json",
                    "type": "text"
                  }
                ],
                "url": {
                  "raw": "{{baseUrl}}/api/health",
                  "host": [
                    "{{baseUrl}}"
                  ],
                  "path": [
                    "api",
                    "health"
                  ]
                },
                "description": "Verifies live connectivity to Azure SQL (`broadmoorweather.database.windows.net` / `NFL`), returns the active Python SQL driver (`pyodbc` or `pymssql`), loaded season span (`1999\u20132026`), total game count, and per-table row counts from `sys.partitions`."
              },
              "status": "OK",
              "code": 200,
              "_postman_previewlanguage": "json",
              "header": [
                {
                  "key": "Content-Type",
                  "value": "application/json"
                }
              ],
              "body": "{\n  \"status\": \"ok\",\n  \"mode\": \"live_azure_sql\",\n  \"driver\": \"pymssql\",\n  \"server\": \"broadmoorweather.database.windows.net\",\n  \"database\": \"NFL\",\n  \"generated_at\": \"2026-11-17T19:16:10.412890+00:00\",\n  \"seasons_range\": [\n    1999,\n    2026\n  ],\n  \"games_count\": 7548,\n  \"total_rows\": 767293,\n  \"table_counts\": [\n    {\n      \"table_name\": \"DefensiveStat\",\n      \"row_count\": 286009\n    },\n    {\n      \"table_name\": \"ReceivingStat\",\n      \"row_count\": 113720\n    },\n    {\n      \"table_name\": \"Injury\",\n      \"row_count\": 90754\n    },\n    {\n      \"table_name\": \"RosterEntry\",\n      \"row_count\": 68629\n    },\n    {\n      \"table_name\": \"RushingStat\",\n      \"row_count\": 59147\n    },\n    {\n      \"table_name\": \"Contract\",\n      \"row_count\": 48663\n    },\n    {\n      \"table_name\": \"ReturnStat\",\n      \"row_count\": 28198\n    },\n    {\n      \"table_name\": \"PassingStat\",\n      \"row_count\": 18026\n    },\n    {\n      \"table_name\": \"Player\",\n      \"row_count\": 16666\n    },\n    {\n      \"table_name\": \"KickingStat\",\n      \"row_count\": 14694\n    },\n    {\n      \"table_name\": \"Game\",\n      \"row_count\": 7548\n    }\n  ]\n}"
            }
          ]
        },
        {
          "name": "POST /api/refresh",
          "request": {
            "method": "POST",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/refresh",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "refresh"
              ]
            },
            "description": "Clears all cached entries in the Azure Function worker memory and immediately executes a live health check against Azure SQL. Used by the **Live Azure SQL Sync** button in the web app header."
          },
          "response": [
            {
              "name": "200 OK \u2014 Sample Response",
              "originalRequest": {
                "method": "POST",
                "header": [
                  {
                    "key": "Accept",
                    "value": "application/json",
                    "type": "text"
                  }
                ],
                "url": {
                  "raw": "{{baseUrl}}/api/refresh",
                  "host": [
                    "{{baseUrl}}"
                  ],
                  "path": [
                    "api",
                    "refresh"
                  ]
                },
                "description": "Clears all cached entries in the Azure Function worker memory and immediately executes a live health check against Azure SQL. Used by the **Live Azure SQL Sync** button in the web app header."
              },
              "status": "OK",
              "code": 200,
              "_postman_previewlanguage": "json",
              "header": [
                {
                  "key": "Content-Type",
                  "value": "application/json"
                }
              ],
              "body": "{\n  \"status\": \"ok\",\n  \"cache_entries_cleared\": 6,\n  \"generated_at\": \"2026-11-17T19:20:04.119042+00:00\",\n  \"games_count\": 7548,\n  \"total_rows\": 767293\n}"
            }
          ]
        },
        {
          "name": "GET /api/refresh",
          "request": {
            "method": "GET",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/refresh",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "refresh"
              ]
            },
            "description": "GET convenience alias for `POST /api/refresh` so browsers or CLI health probes can flush the worker cache with a simple GET request."
          },
          "response": []
        }
      ]
    },
    {
      "name": "Dashboard & Season Analytics",
      "item": [
        {
          "name": "GET /api/dashboard",
          "request": {
            "method": "GET",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/dashboard",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "dashboard"
              ]
            },
            "description": "Primary initialization endpoint for the NFL Gridiron Intelligence Hub. Returns all 32 teams (`v_TeamDirectory`), 28-season franchise standings (`v_Standings`), all 7,548 games (`dbo.Game`), Capology contract ROI (`dbo.Contract`), NFL trade ledger (`v_TradeLedger`), Rounds 1\u20133 draft picks with career PPR/sacks, stadium/roof/surface splits, QB indoor/outdoor splits, plus the requested season's fantasy rankings, weekly logs, DvP matrix, team pulse, and injury reports."
          },
          "response": [
            {
              "name": "200 OK \u2014 Sample Response",
              "originalRequest": {
                "method": "GET",
                "header": [
                  {
                    "key": "Accept",
                    "value": "application/json",
                    "type": "text"
                  }
                ],
                "url": {
                  "raw": "{{baseUrl}}/api/dashboard",
                  "host": [
                    "{{baseUrl}}"
                  ],
                  "path": [
                    "api",
                    "dashboard"
                  ]
                },
                "description": "Primary initialization endpoint for the NFL Gridiron Intelligence Hub. Returns all 32 teams (`v_TeamDirectory`), 28-season franchise standings (`v_Standings`), all 7,548 games (`dbo.Game`), Capology contract ROI (`dbo.Contract`), NFL trade ledger (`v_TradeLedger`), Rounds 1\u20133 draft picks with career PPR/sacks, stadium/roof/surface splits, QB indoor/outdoor splits, plus the requested season's fantasy rankings, weekly logs, DvP matrix, team pulse, and injury reports."
              },
              "status": "OK",
              "code": 200,
              "_postman_previewlanguage": "json",
              "header": [
                {
                  "key": "Content-Type",
                  "value": "application/json"
                }
              ],
              "body": "{\n  \"generated_at\": \"2026-11-17T19:16:15.102938+00:00\",\n  \"api_mode\": \"live_azure_sql\",\n  \"server\": \"broadmoorweather.database.windows.net\",\n  \"database\": \"NFL\",\n  \"active_season\": 2025,\n  \"seasons\": [\n    2026,\n    2025,\n    2024,\n    2023,\n    2022,\n    2021,\n    2020,\n    2019,\n    1999\n  ],\n  \"table_counts\": [\n    {\n      \"table_name\": \"DefensiveStat\",\n      \"row_count\": 286009\n    }\n  ],\n  \"teams\": [\n    {\n      \"team_id\": 29,\n      \"abbreviation\": \"SEA\",\n      \"city\": \"Seattle\",\n      \"team_name\": \"Seahawks\",\n      \"conference\": \"NFC\",\n      \"division\": \"West\",\n      \"home_stadium\": \"Lumen Field\",\n      \"stadium_city\": \"Seattle\",\n      \"surface\": \"turf\",\n      \"roof_type\": \"open\",\n      \"founded_year\": 1976\n    }\n  ],\n  \"standings\": [\n    {\n      \"season_year\": 2025,\n      \"conference\": \"NFC\",\n      \"division\": \"West\",\n      \"team_id\": 29,\n      \"abbreviation\": \"SEA\",\n      \"team_name\": \"Seahawks\",\n      \"wins\": 10,\n      \"losses\": 7,\n      \"ties\": 0,\n      \"win_pct\": 0.588,\n      \"points_for\": 389,\n      \"points_against\": 368,\n      \"point_diff\": 21,\n      \"division_rank\": 2,\n      \"made_playoffs\": false,\n      \"playoff_seed\": null,\n      \"playoff_result\": null,\n      \"head_coach\": \"Mike Macdonald\"\n    }\n  ],\n  \"games\": [\n    {\n      \"game_id\": 1007286,\n      \"season_year\": 2025,\n      \"week\": 1,\n      \"game_type\": \"regular\",\n      \"kickoff\": \"2025-09-07T16:05:00\",\n      \"home_team_id\": 29,\n      \"home_abbr\": \"SEA\",\n      \"home_name\": \"Seahawks\",\n      \"home_score\": 26,\n      \"away_team_id\": 10,\n      \"away_abbr\": \"DEN\",\n      \"away_name\": \"Broncos\",\n      \"away_score\": 20,\n      \"winner_abbr\": \"SEA\",\n      \"margin\": 6,\n      \"stadium_name\": \"Lumen Field\",\n      \"stadium_city\": \"Seattle\",\n      \"stadium_state\": \"WA\",\n      \"surface\": \"turf\",\n      \"roof_type\": \"open\",\n      \"overtime\": false\n    }\n  ],\n  \"season_fantasy\": [\n    {\n      \"season_year\": 2025,\n      \"player_id\": 109674,\n      \"first_name\": \"Ja'Marr\",\n      \"last_name\": \"Chase\",\n      \"full_name\": \"Ja'Marr Chase\",\n      \"position\": \"WR\",\n      \"team\": \"CIN\",\n      \"games\": 17,\n      \"passing_yards\": 0,\n      \"passing_tds\": 0,\n      \"interceptions\": 0,\n      \"rushing_yards\": 32,\n      \"rushing_tds\": 0,\n      \"targets\": 175,\n      \"receptions\": 127,\n      \"receiving_yards\": 1708,\n      \"receiving_tds\": 17,\n      \"fantasy_pts_std\": 276.0,\n      \"fantasy_pts_half_ppr\": 339.5,\n      \"fantasy_pts_ppr\": 403.0,\n      \"ppg_ppr\": 23.71,\n      \"pos_rank_ppr\": 1,\n      \"pos_rank_half_ppr\": 1,\n      \"pos_rank_std\": 1\n    }\n  ]\n}"
            }
          ]
        },
        {
          "name": "GET /api/season-analytics",
          "request": {
            "method": "GET",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/season-analytics",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "season-analytics"
              ]
            },
            "description": "Queries Azure SQL for any single NFL season (`1999\u20132026`) when the user switches the global Season selector. Returns the top 150 season fantasy scorers (with positional ranks across Standard, Half-PPR, and Full-PPR), game-by-game weekly fantasy logs for the top 90 skill players, 32-team Defense vs. Position (DvP) points/yards allowed, weekly team offensive pulse (points for/against + team passer rating), and up to 2,500 weekly injury designations for that season."
          },
          "response": [
            {
              "name": "200 OK \u2014 Sample Response",
              "originalRequest": {
                "method": "GET",
                "header": [
                  {
                    "key": "Accept",
                    "value": "application/json",
                    "type": "text"
                  }
                ],
                "url": {
                  "raw": "{{baseUrl}}/api/season-analytics",
                  "host": [
                    "{{baseUrl}}"
                  ],
                  "path": [
                    "api",
                    "season-analytics"
                  ]
                },
                "description": "Queries Azure SQL for any single NFL season (`1999\u20132026`) when the user switches the global Season selector. Returns the top 150 season fantasy scorers (with positional ranks across Standard, Half-PPR, and Full-PPR), game-by-game weekly fantasy logs for the top 90 skill players, 32-team Defense vs. Position (DvP) points/yards allowed, weekly team offensive pulse (points for/against + team passer rating), and up to 2,500 weekly injury designations for that season."
              },
              "status": "OK",
              "code": 200,
              "_postman_previewlanguage": "json",
              "header": [
                {
                  "key": "Content-Type",
                  "value": "application/json"
                }
              ],
              "body": "{\n  \"season\": 2024,\n  \"generated_at\": \"2026-11-17T19:16:18.221000+00:00\",\n  \"season_fantasy\": [\n    {\n      \"season_year\": 2024,\n      \"player_id\": 107234,\n      \"full_name\": \"CeeDee Lamb\",\n      \"position\": \"WR\",\n      \"team\": \"DAL\",\n      \"games\": 17,\n      \"receptions\": 101,\n      \"receiving_yards\": 1194,\n      \"receiving_tds\": 6,\n      \"fantasy_pts_ppr\": 263.4,\n      \"ppg_ppr\": 15.49,\n      \"pos_rank_ppr\": 8\n    }\n  ],\n  \"weekly_fantasy\": [\n    {\n      \"season_year\": 2024,\n      \"week\": 1,\n      \"game_type\": \"regular\",\n      \"player_id\": 107234,\n      \"full_name\": \"CeeDee Lamb\",\n      \"position\": \"WR\",\n      \"team\": \"DAL\",\n      \"opp\": \"CLE\",\n      \"venue\": \"AWAY\",\n      \"targets\": 10,\n      \"receptions\": 5,\n      \"receiving_yards\": 61,\n      \"receiving_tds\": 0,\n      \"fantasy_pts_ppr\": 13.6\n    }\n  ],\n  \"dvp\": [\n    {\n      \"season_year\": 2024,\n      \"def_team\": \"BAL\",\n      \"position\": \"QB\",\n      \"games_faced\": 17,\n      \"pts_allowed_ppr_per_game\": 18.42,\n      \"pts_allowed_half_per_game\": 18.42,\n      \"pts_allowed_std_per_game\": 18.42,\n      \"pass_yds_allowed\": 4150,\n      \"rush_yds_allowed\": 312,\n      \"rec_yds_allowed\": 0\n    }\n  ],\n  \"team_weekly_pulse\": [\n    {\n      \"season_year\": 2024,\n      \"week\": 1,\n      \"game_type\": \"regular\",\n      \"team\": \"SEA\",\n      \"opponent\": \"DEN\",\n      \"venue\": \"HOME\",\n      \"pf\": 26,\n      \"pa\": 20,\n      \"pass_yds\": 171,\n      \"pass_tds\": 1,\n      \"ints\": 1,\n      \"sacks_taken\": 2,\n      \"team_passer_rating\": 84.7\n    }\n  ],\n  \"injuries\": [\n    {\n      \"season_year\": 2024,\n      \"team\": \"SEA\",\n      \"player_name\": \"Kenneth Walker III\",\n      \"position\": \"RB\",\n      \"injury_date\": \"2024-09-13\",\n      \"body_part\": \"Oblique\",\n      \"status\": \"Doubtful\"\n    }\n  ]\n}"
            }
          ]
        }
      ]
    },
    {
      "name": "Encyclopedia & Entity Profiles",
      "item": [
        {
          "name": "GET /api/players",
          "request": {
            "method": "GET",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/players",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "players"
              ]
            },
            "description": "Returns a compact columnar matrix (`cols` + `rows`) of all **16,666 NFL players** in `dbo.Player` joined with `dbo.PlayerCareerSummary`, including physical measurables, college, draft year/round/pick/team, chronological franchise list, active season span, and career regular-season passing, rushing, receiving, defensive, kicking, return, and PPR fantasy totals."
          },
          "response": [
            {
              "name": "200 OK \u2014 Sample Response",
              "originalRequest": {
                "method": "GET",
                "header": [
                  {
                    "key": "Accept",
                    "value": "application/json",
                    "type": "text"
                  }
                ],
                "url": {
                  "raw": "{{baseUrl}}/api/players",
                  "host": [
                    "{{baseUrl}}"
                  ],
                  "path": [
                    "api",
                    "players"
                  ]
                },
                "description": "Returns a compact columnar matrix (`cols` + `rows`) of all **16,666 NFL players** in `dbo.Player` joined with `dbo.PlayerCareerSummary`, including physical measurables, college, draft year/round/pick/team, chronological franchise list, active season span, and career regular-season passing, rushing, receiving, defensive, kicking, return, and PPR fantasy totals."
              },
              "status": "OK",
              "code": 200,
              "_postman_previewlanguage": "json",
              "header": [
                {
                  "key": "Content-Type",
                  "value": "application/json"
                }
              ],
              "body": "{\n  \"generated_at\": \"2026-11-17T19:16:22.811000+00:00\",\n  \"cols\": [\n    \"id\",\n    \"name\",\n    \"pos\",\n    \"side\",\n    \"status\",\n    \"ht\",\n    \"wt\",\n    \"dob\",\n    \"college\",\n    \"teams\",\n    \"min_yr\",\n    \"max_yr\",\n    \"d_yr\",\n    \"d_rnd\",\n    \"d_pick\",\n    \"d_team\",\n    \"g\",\n    \"pass_yds\",\n    \"pass_td\",\n    \"pass_int\",\n    \"rush_yds\",\n    \"rush_td\",\n    \"rec\",\n    \"rec_yds\",\n    \"rec_td\",\n    \"tkl\",\n    \"sacks\",\n    \"def_int\",\n    \"fgm\",\n    \"fga\",\n    \"ret_yds\",\n    \"ret_td\",\n    \"ppr\"\n  ],\n  \"rows\": [\n    [\n      109674,\n      \"Ja'Marr Chase\",\n      \"WR\",\n      \"offense\",\n      \"ACT\",\n      72,\n      201,\n      \"2000-03-01\",\n      \"LSU\",\n      \"CIN\",\n      2021,\n      2025,\n      2021,\n      1,\n      5,\n      \"CIN\",\n      62,\n      0,\n      0,\n      0,\n      65,\n      0,\n      395,\n      5425,\n      46,\n      0,\n      0.0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      1220.0\n    ]\n  ]\n}"
            }
          ]
        },
        {
          "name": "GET /api/game/{{game_id}}",
          "request": {
            "method": "GET",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/game/{{game_id}}",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "game",
                "{{game_id}}"
              ]
            },
            "description": "Queries Azure SQL for a single game (`dbo.Game`) by `game_id` and returns:\n- Full scoreboard, kickoff, overtime, stadium, surface, and roof metadata\n- Both teams' season standings & head coaches (`away_standing`, `home_standing`)\n- Complete per-player box-score stat lines across all **6 official stat tables** (`passing`, `rushing`, `receiving`, `defense`, `kicking`, `returns`)\n- Complete 1999\u20132026 head-to-head series history (`h2h`) between the two franchises."
          },
          "response": [
            {
              "name": "200 OK \u2014 Sample Response",
              "originalRequest": {
                "method": "GET",
                "header": [
                  {
                    "key": "Accept",
                    "value": "application/json",
                    "type": "text"
                  }
                ],
                "url": {
                  "raw": "{{baseUrl}}/api/game/{{game_id}}",
                  "host": [
                    "{{baseUrl}}"
                  ],
                  "path": [
                    "api",
                    "game",
                    "{{game_id}}"
                  ]
                },
                "description": "Queries Azure SQL for a single game (`dbo.Game`) by `game_id` and returns:\n- Full scoreboard, kickoff, overtime, stadium, surface, and roof metadata\n- Both teams' season standings & head coaches (`away_standing`, `home_standing`)\n- Complete per-player box-score stat lines across all **6 official stat tables** (`passing`, `rushing`, `receiving`, `defense`, `kicking`, `returns`)\n- Complete 1999\u20132026 head-to-head series history (`h2h`) between the two franchises."
              },
              "status": "OK",
              "code": 200,
              "_postman_previewlanguage": "json",
              "header": [
                {
                  "key": "Content-Type",
                  "value": "application/json"
                }
              ],
              "body": "{\n  \"generated_at\": \"2026-11-17T19:16:28.504000+00:00\",\n  \"game\": {\n    \"game_id\": 1007286,\n    \"season_year\": 2025,\n    \"week\": 16,\n    \"game_type\": \"regular\",\n    \"kickoff\": \"2025-12-21T16:25:00\",\n    \"home_team_id\": 29,\n    \"home_abbr\": \"SEA\",\n    \"home_name\": \"Seahawks\",\n    \"home_score\": 24,\n    \"away_team_id\": 20,\n    \"away_abbr\": \"MIN\",\n    \"away_name\": \"Vikings\",\n    \"away_score\": 27,\n    \"winner_abbr\": \"MIN\",\n    \"margin\": 3,\n    \"stadium_name\": \"Lumen Field\",\n    \"stadium_city\": \"Seattle\",\n    \"stadium_state\": \"WA\",\n    \"surface\": \"turf\",\n    \"roof_type\": \"open\",\n    \"overtime\": false,\n    \"attendance\": 68740\n  },\n  \"away_standing\": {\n    \"abbreviation\": \"MIN\",\n    \"wins\": 14,\n    \"losses\": 3,\n    \"ties\": 0,\n    \"win_pct\": 0.824,\n    \"division_rank\": 2,\n    \"head_coach\": \"Kevin O'Connell\"\n  },\n  \"home_standing\": {\n    \"abbreviation\": \"SEA\",\n    \"wins\": 10,\n    \"losses\": 7,\n    \"ties\": 0,\n    \"win_pct\": 0.588,\n    \"division_rank\": 2,\n    \"head_coach\": \"Mike Macdonald\"\n  },\n  \"passing\": [\n    [\n      1007286,\n      104312,\n      \"SEA\",\n      43,\n      31,\n      314,\n      3,\n      2,\n      2,\n      96.5,\n      \"Geno Smith\"\n    ]\n  ],\n  \"rushing\": [\n    [\n      1007286,\n      110245,\n      \"SEA\",\n      8,\n      31,\n      0,\n      0,\n      \"Kenneth Walker III\"\n    ]\n  ],\n  \"receiving\": [\n    [\n      1007286,\n      110988,\n      \"SEA\",\n      12,\n      8,\n      95,\n      1,\n      42,\n      \"Jaxon Smith-Njigba\"\n    ]\n  ],\n  \"defense\": [\n    [\n      1007286,\n      105112,\n      \"SEA\",\n      7,\n      4,\n      1.0,\n      0,\n      0,\n      1,\n      0,\n      \"Leonard Williams\"\n    ]\n  ],\n  \"kicking\": [\n    [\n      1007286,\n      103901,\n      \"SEA\",\n      2,\n      1,\n      43,\n      3,\n      3,\n      \"Jason Myers\"\n    ]\n  ],\n  \"returns\": [\n    [\n      1007286,\n      111402,\n      \"SEA\",\n      2,\n      54,\n      1,\n      12,\n      0,\n      \"Laviska Shenault Jr.\"\n    ]\n  ],\n  \"h2h\": [\n    {\n      \"game_id\": 1007286,\n      \"season_year\": 2025,\n      \"week\": 16,\n      \"game_type\": \"regular\",\n      \"away_abbr\": \"MIN\",\n      \"away_score\": 27,\n      \"home_abbr\": \"SEA\",\n      \"home_score\": 24,\n      \"winner_abbr\": \"MIN\",\n      \"stadium_name\": \"Lumen Field\",\n      \"overtime\": false\n    }\n  ]\n}"
            }
          ]
        },
        {
          "name": "GET /api/player/{{player_id}}",
          "request": {
            "method": "GET",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/player/{{player_id}}",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "player",
                "{{player_id}}"
              ]
            },
            "description": "Queries Azure SQL for a single player (`dbo.Player`) by `player_id` and aggregates:\n- Biographical profile, draft pedigree (`dbo.DraftPick`), and career franchise timeline\n- Year-by-year **regular-season** (`seasons`) and **postseason** (`post_seasons`) stat splits across all 6 stat categories + roster entries\n- Week-by-week **game log** (`game_log`) for `season` (defaults to the player's most recent active season)\n- OverTheCap contract history (`contracts`), NFL trade transactions (`trades`), and weekly injury designations (`injuries`)."
          },
          "response": [
            {
              "name": "200 OK \u2014 Sample Response",
              "originalRequest": {
                "method": "GET",
                "header": [
                  {
                    "key": "Accept",
                    "value": "application/json",
                    "type": "text"
                  }
                ],
                "url": {
                  "raw": "{{baseUrl}}/api/player/{{player_id}}",
                  "host": [
                    "{{baseUrl}}"
                  ],
                  "path": [
                    "api",
                    "player",
                    "{{player_id}}"
                  ]
                },
                "description": "Queries Azure SQL for a single player (`dbo.Player`) by `player_id` and aggregates:\n- Biographical profile, draft pedigree (`dbo.DraftPick`), and career franchise timeline\n- Year-by-year **regular-season** (`seasons`) and **postseason** (`post_seasons`) stat splits across all 6 stat categories + roster entries\n- Week-by-week **game log** (`game_log`) for `season` (defaults to the player's most recent active season)\n- OverTheCap contract history (`contracts`), NFL trade transactions (`trades`), and weekly injury designations (`injuries`)."
              },
              "status": "OK",
              "code": 200,
              "_postman_previewlanguage": "json",
              "header": [
                {
                  "key": "Content-Type",
                  "value": "application/json"
                }
              ],
              "body": "{\n  \"generated_at\": \"2026-11-17T19:16:29.110000+00:00\",\n  \"player\": {\n    \"id\": 109674,\n    \"name\": \"Ja'Marr Chase\",\n    \"pos\": \"WR\",\n    \"side\": \"offense\",\n    \"status\": \"ACT\",\n    \"ht\": 72,\n    \"wt\": 201,\n    \"dob\": \"2000-03-01\",\n    \"college\": \"LSU\",\n    \"teams\": [\n      \"CIN\"\n    ],\n    \"min_yr\": 2021,\n    \"max_yr\": 2025,\n    \"d_yr\": 2021,\n    \"d_rnd\": 1,\n    \"d_pick\": 5,\n    \"d_team\": \"CIN\",\n    \"g\": 62,\n    \"pass_yds\": 0,\n    \"pass_td\": 0,\n    \"pass_int\": 0,\n    \"rush_yds\": 65,\n    \"rush_td\": 0,\n    \"rec\": 395,\n    \"rec_yds\": 5425,\n    \"rec_td\": 46,\n    \"tkl\": 0,\n    \"sacks\": 0.0,\n    \"def_int\": 0,\n    \"fgm\": 0,\n    \"fga\": 0,\n    \"ret_yds\": 0,\n    \"ret_td\": 0,\n    \"ppr\": 1220.0\n  },\n  \"season_cols\": [\n    \"yr\",\n    \"team\",\n    \"jersey\",\n    \"g\",\n    \"att\",\n    \"cmp\",\n    \"pass_yds\",\n    \"pass_td\",\n    \"pass_int\",\n    \"sck_taken\",\n    \"rtg\",\n    \"car\",\n    \"rush_yds\",\n    \"rush_td\",\n    \"fum\",\n    \"tgt\",\n    \"rec\",\n    \"rec_yds\",\n    \"rec_td\",\n    \"yac\",\n    \"tkl\",\n    \"ast\",\n    \"sacks\",\n    \"def_int\",\n    \"ff\",\n    \"pd\",\n    \"def_td\",\n    \"fga\",\n    \"fgm\",\n    \"fgl\",\n    \"xpa\",\n    \"xpm\",\n    \"kr\",\n    \"kr_yds\",\n    \"pr\",\n    \"pr_yds\",\n    \"ret_td\",\n    \"ppr\"\n  ],\n  \"seasons\": [\n    [\n      2025,\n      \"CIN\",\n      1,\n      17,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      null,\n      3,\n      32,\n      0,\n      0,\n      175,\n      127,\n      1708,\n      17,\n      787,\n      0,\n      0,\n      0.0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      0,\n      403.0\n    ]\n  ],\n  \"post_seasons\": [],\n  \"active_years\": [\n    2025,\n    2024,\n    2023,\n    2022,\n    2021\n  ],\n  \"log_season\": 2025,\n  \"game_log\": [\n    {\n      \"game_id\": 1007201,\n      \"season_year\": 2025,\n      \"week\": 1,\n      \"game_type\": \"regular\",\n      \"kickoff\": \"2025-09-07T13:00:00\",\n      \"home_abbr\": \"CIN\",\n      \"away_abbr\": \"NE\",\n      \"home_score\": 10,\n      \"away_score\": 16,\n      \"winner_abbr\": \"NE\",\n      \"team\": \"CIN\",\n      \"att\": 0,\n      \"cmp\": 0,\n      \"pyd\": 0,\n      \"ptd\": 0,\n      \"pint\": 0,\n      \"car\": 0,\n      \"ryd\": 0,\n      \"rtd\": 0,\n      \"tgt\": 6,\n      \"rec\": 6,\n      \"recyd\": 62,\n      \"rectd\": 0,\n      \"tkl\": 0,\n      \"sck\": 0.0,\n      \"dint\": 0,\n      \"pd\": 0,\n      \"fgm\": 0,\n      \"fga\": 0,\n      \"xpm\": 0,\n      \"retYds\": 0,\n      \"retTd\": 0\n    }\n  ],\n  \"contracts\": [\n    [\n      \"CIN\",\n      \"2021-06-02\",\n      \"2025-12-31\",\n      30.82,\n      30.82\n    ]\n  ],\n  \"injuries\": [\n    [\n      \"2023-12-22\",\n      \"CIN\",\n      \"Shoulder\",\n      \"Out\"\n    ]\n  ],\n  \"trades\": []\n}"
            }
          ]
        },
        {
          "name": "GET /api/team/{{team_abbr}}",
          "request": {
            "method": "GET",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/team/{{team_abbr}}",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "team",
                "{{team_abbr}}"
              ]
            },
            "description": "Queries Azure SQL for an NFL franchise by its standard abbreviation (`SEA`, `KC`, `SF`, `BUF`, etc.) and returns:\n- Franchise directory metadata (conference, division, home stadium, surface, roof, founded year)\n- All 1999\u20132026 year-by-year season records, playoff results & head coaches (`standings`)\n- Full game schedule & scores for `season` (`schedule`)\n- Full deduplicated `season` team roster enriched with each player's height, weight, college, and `season` stat totals (`roster`)\n- All-time modern era (`1999\u20132026`) top-12 regular-season franchise leaders in Passing, Rushing, Receiving, and Defense (`leaders`)\n- Coaching tenures (`coaches`) and all franchise draft picks (`draft_picks`)."
          },
          "response": [
            {
              "name": "200 OK \u2014 Sample Response",
              "originalRequest": {
                "method": "GET",
                "header": [
                  {
                    "key": "Accept",
                    "value": "application/json",
                    "type": "text"
                  }
                ],
                "url": {
                  "raw": "{{baseUrl}}/api/team/{{team_abbr}}",
                  "host": [
                    "{{baseUrl}}"
                  ],
                  "path": [
                    "api",
                    "team",
                    "{{team_abbr}}"
                  ]
                },
                "description": "Queries Azure SQL for an NFL franchise by its standard abbreviation (`SEA`, `KC`, `SF`, `BUF`, etc.) and returns:\n- Franchise directory metadata (conference, division, home stadium, surface, roof, founded year)\n- All 1999\u20132026 year-by-year season records, playoff results & head coaches (`standings`)\n- Full game schedule & scores for `season` (`schedule`)\n- Full deduplicated `season` team roster enriched with each player's height, weight, college, and `season` stat totals (`roster`)\n- All-time modern era (`1999\u20132026`) top-12 regular-season franchise leaders in Passing, Rushing, Receiving, and Defense (`leaders`)\n- Coaching tenures (`coaches`) and all franchise draft picks (`draft_picks`)."
              },
              "status": "OK",
              "code": 200,
              "_postman_previewlanguage": "json",
              "header": [
                {
                  "key": "Content-Type",
                  "value": "application/json"
                }
              ],
              "body": "{\n  \"generated_at\": \"2026-11-17T19:16:25.304000+00:00\",\n  \"team\": {\n    \"team_id\": 29,\n    \"abbreviation\": \"SEA\",\n    \"city\": \"Seattle\",\n    \"team_name\": \"Seahawks\",\n    \"conference\": \"NFC\",\n    \"division\": \"West\",\n    \"home_stadium\": \"Lumen Field\",\n    \"stadium_city\": \"Seattle\",\n    \"surface\": \"turf\",\n    \"roof_type\": \"open\",\n    \"founded_year\": 1976\n  },\n  \"view_season\": 2025,\n  \"seasons\": [\n    2026,\n    2025,\n    2024,\n    2023,\n    1999\n  ],\n  \"standings\": [\n    {\n      \"season_year\": 2025,\n      \"conference\": \"NFC\",\n      \"division\": \"West\",\n      \"team_id\": 29,\n      \"abbreviation\": \"SEA\",\n      \"team_name\": \"Seahawks\",\n      \"wins\": 10,\n      \"losses\": 7,\n      \"ties\": 0,\n      \"win_pct\": 0.588,\n      \"points_for\": 389,\n      \"points_against\": 368,\n      \"point_diff\": 21,\n      \"division_rank\": 2,\n      \"made_playoffs\": false,\n      \"head_coach\": \"Mike Macdonald\"\n    }\n  ],\n  \"schedule\": [\n    {\n      \"game_id\": 1007286,\n      \"season_year\": 2025,\n      \"week\": 1,\n      \"game_type\": \"regular\",\n      \"kickoff\": \"2025-09-07T16:05:00\",\n      \"home_abbr\": \"SEA\",\n      \"home_score\": 26,\n      \"away_abbr\": \"DEN\",\n      \"away_score\": 20,\n      \"winner_abbr\": \"SEA\",\n      \"stadium_name\": \"Lumen Field\",\n      \"overtime\": false\n    }\n  ],\n  \"roster\": [\n    {\n      \"player_id\": 110988,\n      \"name\": \"Jaxon Smith-Njigba\",\n      \"pos\": \"WR\",\n      \"jersey\": 11,\n      \"status\": \"ACT\",\n      \"ht\": 72,\n      \"wt\": 197,\n      \"college\": \"Ohio State\",\n      \"pyd\": 0,\n      \"ptd\": 0,\n      \"ryd\": 26,\n      \"rtd\": 0,\n      \"rec\": 100,\n      \"recyd\": 1130,\n      \"rectd\": 6,\n      \"tkl\": 0,\n      \"sck\": 0.0,\n      \"dint\": 0,\n      \"fgm\": 0,\n      \"fga\": 0\n    }\n  ],\n  \"leaders\": {\n    \"passing\": [\n      [\n        101845,\n        \"Russell Wilson\",\n        158,\n        3079,\n        4735,\n        37059,\n        292,\n        87\n      ]\n    ],\n    \"rushing\": [\n      [\n        100912,\n        \"Shaun Alexander\",\n        119,\n        2176,\n        9429,\n        100\n      ]\n    ],\n    \"receiving\": [\n      [\n        102401,\n        \"Tyler Lockett\",\n        161,\n        661,\n        914,\n        8594,\n        61\n      ]\n    ],\n    \"defense\": [\n      [\n        101902,\n        \"Bobby Wagner\",\n        168,\n        1566,\n        27.5,\n        13,\n        6,\n        4\n      ]\n    ]\n  },\n  \"coaches\": [\n    [\n      \"Mike Macdonald\",\n      \"Head Coach\",\n      \"2024-01-31\",\n      null\n    ]\n  ],\n  \"draft_picks\": [\n    [\n      6980,\n      2023,\n      1,\n      20,\n      \"SEA\",\n      \"SEA\",\n      110988,\n      \"Jaxon Smith-Njigba\",\n      \"WR\",\n      \"Ohio State\"\n    ]\n  ]\n}"
            }
          ]
        }
      ]
    },
    {
      "name": "Admin & Data Sync",
      "item": [
        {
          "name": "POST /api/sync-nfl",
          "request": {
            "method": "POST",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              },
              {
                "key": "x-functions-key",
                "value": "{{functionKey}}",
                "type": "text"
              },
              {
                "key": "Content-Type",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/api/sync-nfl",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "api",
                "sync-nfl"
              ]
            },
            "description": "Pulls the latest official NFL schedules, rosters, 6-category weekly player stats, and weekly injury designations from `nflreadpy` (`nflverse`), upserts them into Azure SQL (`dbo.*`), executes `EXEC dbo.usp_RecomputeStandings` and `EXEC dbo.usp_RefreshCareerSummary`, and clears the live API cache.\n\n**Authentication:** Protected with `AuthLevel.FUNCTION`. Supply your Azure Function Key via the `x-functions-key` header (click **Authorize** in Swagger UI) or `?code=<function_key>` query parameter.",
            "body": {
              "mode": "raw",
              "raw": "{\n  \"season\": 2026,\n  \"week\": 10\n}",
              "options": {
                "raw": {
                  "language": "json"
                }
              }
            }
          },
          "response": [
            {
              "name": "200 OK \u2014 Sample Response",
              "originalRequest": {
                "method": "POST",
                "header": [
                  {
                    "key": "Accept",
                    "value": "application/json",
                    "type": "text"
                  },
                  {
                    "key": "x-functions-key",
                    "value": "{{functionKey}}",
                    "type": "text"
                  },
                  {
                    "key": "Content-Type",
                    "value": "application/json",
                    "type": "text"
                  }
                ],
                "url": {
                  "raw": "{{baseUrl}}/api/sync-nfl",
                  "host": [
                    "{{baseUrl}}"
                  ],
                  "path": [
                    "api",
                    "sync-nfl"
                  ]
                },
                "description": "Pulls the latest official NFL schedules, rosters, 6-category weekly player stats, and weekly injury designations from `nflreadpy` (`nflverse`), upserts them into Azure SQL (`dbo.*`), executes `EXEC dbo.usp_RecomputeStandings` and `EXEC dbo.usp_RefreshCareerSummary`, and clears the live API cache.\n\n**Authentication:** Protected with `AuthLevel.FUNCTION`. Supply your Azure Function Key via the `x-functions-key` header (click **Authorize** in Swagger UI) or `?code=<function_key>` query parameter.",
                "body": {
                  "mode": "raw",
                  "raw": "{\n  \"season\": 2026,\n  \"week\": 10\n}",
                  "options": {
                    "raw": {
                      "language": "json"
                    }
                  }
                }
              },
              "status": "OK",
              "code": 200,
              "_postman_previewlanguage": "json",
              "header": [
                {
                  "key": "Content-Type",
                  "value": "application/json"
                }
              ],
              "body": "{\n  \"status\": \"success\",\n  \"timestamp_utc\": \"2026-11-17T06:00:19.442100+00:00\",\n  \"season\": 2026,\n  \"target_week\": 10,\n  \"new_players_inserted\": 4,\n  \"roster_entries_refreshed\": 1696,\n  \"new_games_inserted\": 0,\n  \"existing_games_updated\": 14,\n  \"stats_upserted\": {\n    \"PassingStat\": 31,\n    \"RushingStat\": 104,\n    \"ReceivingStat\": 218,\n    \"DefensiveStat\": 482,\n    \"KickingStat\": 28,\n    \"ReturnStat\": 41,\n    \"Injury\": 390\n  },\n  \"standings_recomputed\": true\n}"
            }
          ]
        }
      ]
    },
    {
      "name": "Analytics",
      "item": [
        {
          "name": "POST /fantasy-advisor",
          "request": {
            "method": "POST",
            "header": [
              {
                "key": "Accept",
                "value": "application/json",
                "type": "text"
              },
              {
                "key": "Content-Type",
                "value": "application/json",
                "type": "text"
              }
            ],
            "url": {
              "raw": "{{baseUrl}}/fantasy-advisor",
              "host": [
                "{{baseUrl}}"
              ],
              "path": [
                "fantasy-advisor"
              ]
            },
            "description": "Evaluates a 7-to-10-slot lineup (`QB, RB1, RB2, WR1, WR2, TE, FLEX, FLEX2, K, DEF`) across played weeks, 3-season trajectory (`Y-2..Y`), 12-team league starter median, and upcoming target-week matchup projections using current & prior NFL statistics (`blend`, `current`, or `prior` model).",
            "body": {
              "mode": "raw",
              "raw": "{\n  \"season\": 2026,\n  \"week\": 10\n}",
              "options": {
                "raw": {
                  "language": "json"
                }
              }
            }
          },
          "response": []
        }
      ]
    }
  ],
  "variable": [
    {
      "key": "baseUrl",
      "value": "https://nfl-giambattista-func.azurewebsites.net",
      "type": "string"
    },
    {
      "key": "season",
      "value": "2025",
      "type": "string"
    },
    {
      "key": "game_id",
      "value": "1007286",
      "type": "string"
    },
    {
      "key": "player_id",
      "value": "109674",
      "type": "string"
    },
    {
      "key": "team_abbr",
      "value": "SEA",
      "type": "string"
    },
    {
      "key": "functionKey",
      "value": "",
      "type": "string"
    }
  ]
}