operator_player_lookupsnhl.operator_player_lookups

How each sportsbook and fantasy operator names every NHL player — the mapping from each operator's player identifier to a unified player record.

Full field reference (9 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/nhl/operator_player_lookupsList operator_player_lookups for NHL

Requires one of: operator_id — requests satisfying none of these return 400.

Parameters

operator_idquerybigintoptional

Filter by operator.

limitqueryintegeroptionaldefault 100

Page size. Defaults to 100; 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/nhl/operator_player_lookups?operator_id=1'

Responses

200operator_player_lookups rows matching the declared filter set, wrapped in { operator_player_lookups, 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(9 fields)show schema ▸

Field	Type	References	Description
idkey	bigint	—	Primary Key
operator_id	bigint		Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo; every id is listed at /api/v1/reference/operators. e.g. — (all-null in sample)
operator_player_id	string	—	External player ID from operator e.g. — (all-null in sample)
player_id	bigintnullable		Internal nhl.players.id reference e.g. — (all-null in sample)
decided_at	timestamptznullable	—	When the pin or block was decided.
decided_reason	stringnullable	—	Evidence behind a pinned or blocked decision.
decision	stringnullable	—	How this mapping was decided: 'derived' (finder answer, overwritable), 'pinned' (decided on evidence, trigger-protected), 'blocked' (no player we hold is this id; player_id NULL, never retried). DB default 'derived'; a BEFORE UPDATE trigger preserves non-derived rows.
player_name	stringnullable	—	Player name for reconciliation e.g. — (all-null in sample)
position	stringnullable	—	Position for reconciliation e.g. — (all-null in sample)

GET/api/v1/nhl/operator_player_lookups/{id}Get a single operator_player_lookup by id

Parameters

idpathbigintrequired

Primary key (id) of the operator_player_lookup 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/nhl/operator_player_lookups/{pk_value}'

Responses

200Single operator_player_lookup row.application/jsonshow example ▸

404Row not found.

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

Response Schema(9 fields)show schema ▸

Field	Type	References	Description
idkey	bigint	—	Primary Key
operator_id	bigint		Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo; every id is listed at /api/v1/reference/operators. e.g. — (all-null in sample)
operator_player_id	string	—	External player ID from operator e.g. — (all-null in sample)
player_id	bigintnullable		Internal nhl.players.id reference e.g. — (all-null in sample)
decided_at	timestamptznullable	—	When the pin or block was decided.
decided_reason	stringnullable	—	Evidence behind a pinned or blocked decision.
decision	stringnullable	—	How this mapping was decided: 'derived' (finder answer, overwritable), 'pinned' (decided on evidence, trigger-protected), 'blocked' (no player we hold is this id; player_id NULL, never retried). DB default 'derived'; a BEFORE UPDATE trigger preserves non-derived rows.
player_name	stringnullable	—	Player name for reconciliation e.g. — (all-null in sample)
position	stringnullable	—	Position for reconciliation e.g. — (all-null in sample)