---
title: "Get a single team_player_roster by id"
method: GET
path: "/api/v1/mlb/team_player_rosters/{id}"
tags: ["MLB"]
---

# Get a single team_player_roster by id

`GET /api/v1/mlb/team_player_rosters/{id}`

## Request

- Base URL: `https://api.stat-api.com`
- URL: `https://api.stat-api.com/api/v1/mlb/team_player_rosters/{id}`
- Auth: HTTP bearer

## Path parameters

- `id` integer, required: Primary Key

## Response `200`

Single team_player_rosters row.

- MLBTeamPlayerRosters: Day-by-day player-to-team affiliations across the MLB season — who was on each 40-man roster, who was on the IL, who was optioned to the minors, and who was designated for assignment.
  - `day` integer, required
  - `id` integer, required: Primary Key
  - `player_id` integer, required
  - `position` string, nullable
  - `position_depth` integer, nullable
  - `position_group` string, nullable
  - `roster_type` string, required
  - `season_id` integer, required
  - `team_id` integer, required

## Other responses

- `404`: Row not found.

---

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