---
title: "List game_player_props for MLB"
method: GET
path: "/api/v1/mlb/game_player_props"
tags: ["MLB"]
---

# List game_player_props for MLB

`GET /api/v1/mlb/game_player_props`

## Request

- Base URL: `https://api.stat-api.com`
- URL: `https://api.stat-api.com/api/v1/mlb/game_player_props`
- Auth: HTTP bearer

⚠️ This endpoint is documented but not yet live. Calls return 503 until the MLB data load is in production.

## Query parameters

- `game_id` integer
- `player_id` integer
- `limit` integer
- `from_id` integer
- `format` 'json' | 'csv'

## Response `200`

game_player_props rows matching the declared filter set.

- MLBGamePlayerPropsListResponse
  - `game_player_props` MLBGamePlayerProps[], required
    - `book_count` integer, required: Number of curated books contributing to this consensus value
    - `captured_at` string, date-time, required
    - `category` string, required: Canonical category. Pitcher props: - strikeouts_pitcher, hits_allowed, walks_allowed, - earned_runs, outs_recorded, pitching_outs, win, quality_start Batter props: - hits, home_runs, rbis, total_bases, runs, walks, - stolen_bases, strikeouts_batter, hits_runs_rbis
    - `game_id` integer, required
    - `id` integer, required: Primary Key
    - `is_opening` boolean, required
    - `line` number, double, nullable: Prop line for over/under markets (e.g., 5.5 strikeouts)
    - `market_key` string, required: Raw market key from source API (e.g., pitcher_strikeouts)
    - `no_odds` integer, nullable
    - `operator_id` integer, required
    - `outcome_type` string, required: ou | yes_no
    - `over_odds` integer, nullable
    - `period_code` string, nullable: Optional period code (F5)
    - `player_id` integer, required
    - `season_id` integer, required: Denormalized for efficient season-level queries
    - `subcategory` string, nullable: Optional subtype (alternate, boosted, etc.)
    - `under_odds` integer, nullable
    - `yes_odds` integer, nullable
  - `has_more` boolean, required: True when a full page came back, so more rows can exist.
  - `limit` integer, required: Page size used for this response.
  - `next_from_id` integer, nullable, required: Pass this as `from_id` on the next request to page forward. `null` on the terminal page, and on a first page requested without `from_id` (that page uses the default sort): to walk every row, start with `from_id=0`.

## Other responses

- `400`: No declared filter set was satisfied by the request — see `accepted` in the body for the valid combinations.
- `503`: Coming soon — handler returns 503 until data is wired in.

---

[API](https://skmtc.dev/stat-api/apis/sports-db-public-api.md) · [All operations](https://skmtc.dev/stat-api/apis/sports-db-public-api/llms.txt) · [OpenAPI document](https://skmtc.dev/stat-api/apis/sports-db-public-api/revisions/23b66b957723?raw)