game_player_propsmlb.game_player_props

MLB player prop bets for each game — hits, runs, RBIs, total bases, home runs, strikeouts (for pitchers), and other player-statistic markets offered by sportsbooks.

Full field reference (18 columns) → Data Dictionary Query in GraphQL →

⚠️ This endpoint is documented but not yet live. Calls return 503 until data is wired in.

GET/api/v1/mlb/game_player_propsList game_player_props for MLB

Requires one of: game_id or player_id — requests satisfying none of these return 400.

Parameters

game_idquerybigintoptional

Filter to a single game.

player_idquerybigintoptional

Filter to a single player.

limitqueryintegeroptionaldefault 50

Page size. Defaults to 50; max 5000.

from_idquerybigintoptional

Return rows with id strictly greater than this value; page using the previous response's `next_from_id`. Omit on the first page.

Restores the documented defaults (trial keys only accept the unchanged defaults).

Request

curl -sS --compressed \
  -H 'Authorization: Bearer YOUR_API_KEY' \
  'https://api.stat-api.com/api/v1/mlb/game_player_props?game_id=1'

Responses

200game_player_props rows matching the declared filter set, wrapped in { game_player_props, limit, next_from_id }. next_from_id is the last row's id on a full page — pass it back via ?from_id= to walk the full result; null marks the terminal page.application/jsonshow example ▸

400No declared filter set was satisfied — response body matches MissingRequiredFiltersError; pick one combo from the accepted-sets hint and resend.application/json

503Coming soon — handler returns 503 until data is wired in.

Response Schema(18 fields)show schema ▸

Field	Type	References	Description
idkey	bigint	—	Primary Key
game_id	bigint		—
operator_id	bigint		—
player_id	bigint		—
season_id	bigint		Denormalized for efficient season-level queries
book_count	integer	—	Number of curated books contributing to this consensus value
captured_at	timestamptz	—	—
category	string	—	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
is_opening	boolean	—	—
line	decimalnullable	—	Prop line for over/under markets (e.g., 5.5 strikeouts)
market_key	string	—	Raw market key from source API (e.g., pitcher_strikeouts)
no_odds	integernullable	—	—
outcome_type	string	—	ou \| yes_no
over_odds	integernullable	—	—
period_code	stringnullable	—	Optional period code (F5)
subcategory	stringnullable	—	Optional subtype (alternate, boosted, etc.)
under_odds	integernullable	—	—
yes_odds	integernullable	—	—

GET/api/v1/mlb/game_player_props/{id}Get a single game_player_prop by id

Parameters

idpathbigintrequired

Primary key (id) of the game_player_prop row.

Restores the documented defaults (trial keys only accept the unchanged defaults).

Request

curl -sS --compressed \
  -H 'Authorization: Bearer YOUR_API_KEY' \
  'https://api.stat-api.com/api/v1/mlb/game_player_props/{pk_value}'

Responses

200Single game_player_prop row.application/jsonshow example ▸

404Row not found.

503Coming soon — handler returns 503 until data is wired in.

Response Schema(18 fields)show schema ▸

Field	Type	References	Description
idkey	bigint	—	Primary Key
game_id	bigint		—
operator_id	bigint		—
player_id	bigint		—
season_id	bigint		Denormalized for efficient season-level queries
book_count	integer	—	Number of curated books contributing to this consensus value
captured_at	timestamptz	—	—
category	string	—	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
is_opening	boolean	—	—
line	decimalnullable	—	Prop line for over/under markets (e.g., 5.5 strikeouts)
market_key	string	—	Raw market key from source API (e.g., pitcher_strikeouts)
no_odds	integernullable	—	—
outcome_type	string	—	ou \| yes_no
over_odds	integernullable	—	—
period_code	stringnullable	—	Optional period code (F5)
subcategory	stringnullable	—	Optional subtype (alternate, boosted, etc.)
under_odds	integernullable	—	—
yes_odds	integernullable	—	—