# Loot ledger

## `GET /api/epgp/ledger`

**Get the SQL ledger**

Returns SQL (SideQuest Loot) ledger entries, newest first.

**Parameters**

| Name | In | Type | Required | Description |
|---|---|---|---|---|
| `member_id` | query | integer \| null | no | Only return entries for this member. |
| `character` | query | string \| null | no | Only return entries for this character name. |
| `limit` | query | integer | no | Max entries to return. |
| `before` | query | string (date-time) \| null | no | Only return entries before this time. |

**Response `200` — A page of ledger entries.**

Model: {ref}`EpgpLedgerPage <model-epgpledgerpage>`

| Field | Type | Required | Description |
|---|---|---|---|
| `entries` | array of {ref}`EpgpLedgerRow <model-epgpledgerrow>` | yes |  |


## `GET /api/epgp/loot`

**Get loot awards**

Returns loot awards, newest first.

**Parameters**

| Name | In | Type | Required | Description |
|---|---|---|---|---|
| `limit` | query | integer | no | Max awards to return. |

**Response `200` — A page of loot awards.**

Model: {ref}`EpgpLootPage <model-epgplootpage>`

| Field | Type | Required | Description |
|---|---|---|---|
| `items` | array of {ref}`EpgpLootRow <model-epgplootrow>` | yes |  |


## `GET /api/epgp/progression`

**Get boss progression**

Returns kill and wipe tallies per boss, grouped by instance.

**Response `200` — The boss progression.**

Model: {ref}`EpgpProgression <model-epgpprogression>`

| Field | Type | Required | Description |
|---|---|---|---|
| `instances` | array of {ref}`EpgpProgressionInstance <model-epgpprogressioninstance>` | yes |  |


## `GET /api/epgp/standings`

**Get SQL standings**

Returns decayed-on-read EP/GP standings, highest PR first.

**Response `200` — The SQL (SideQuest Loot) standings.**

Model: {ref}`EpgpStandings <model-epgpstandings>`

| Field | Type | Required | Description |
|---|---|---|---|
| `generated_at` | string (date-time) | yes |  |
| `rules` | {ref}`EpgpRules <model-epgprules>` | yes |  |
| `rows` | array of {ref}`EpgpStandingsRow <model-epgpstandingsrow>` | yes |  |