---
title: "List operator_player_lookups for NHL"
method: GET
path: "/api/v1/nhl/operator_player_lookups"
tags: ["NHL"]
---

# List operator_player_lookups for NHL

`GET /api/v1/nhl/operator_player_lookups`

## Request

- Base URL: `https://api.stat-api.com`
- URL: `https://api.stat-api.com/api/v1/nhl/operator_player_lookups`
- Auth: HTTP bearer

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

## Query parameters

- `operator_id` integer
- `limit` integer
- `from_id` integer
- `format` 'json' | 'csv'

## Response `200`

operator_player_lookups rows matching the declared filter set.

- NHLOperatorPlayerLookupsListResponse
  - `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`.
  - `operator_player_lookups` NHLOperatorPlayerLookups[], required
    - `decided_at` string, date-time, nullable: When the pin or block was decided.
    - `decided_reason` string, nullable: Evidence behind a pinned or blocked decision.
    - `decision` string, nullable: 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.
    - `id` integer, required: Primary Key
    - `operator_id` integer, required: Operator id: 1 DraftKings, 2 FanDuel, 3 Yahoo; every id is listed at /api/v1/reference/operators.
    - `operator_player_id` string, required: External player ID from operator
    - `player_id` integer, nullable: Internal nhl.players.id reference
    - `player_name` string, nullable: Player name for reconciliation
    - `position` string, nullable: Position for reconciliation

## 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)