Last Known Data API

Tato stranka popisuje JSON REST API pro vystaveni poslednich znamych hodnot ze souboru data/sp-daily-balance-YYYY-MM.csv.

Status:

• Implemented in shift-planner-app.

Endpoint

GET /api/v1/lastKnownData

Authentication

• endpoint je chraneny pres Authorization: Bearer <token>
• tokeny se cteou z data/sp-api-tokens.csv
• zmeny v CSV se nactou bez restartu aplikace

Goal

Endpoint vraci pro kazdy sklad posledni znamy zaznam a pro kazdou metriku dve hodnoty:

• warehouse.cme_id: CME identifikator skladu z data/sp-warehouse.csv
• value: posledni ulozena hodnota
• saved_date: datum ulozeni ve formatu YYYY-MM-DD bez casove slozky

Pokud sklad jeste nema zadna ulozena data, endpoint vrati business_date: null a vsechny metriky jako 0 s saved_date: null.

Response Shape

{
  "data": [
    {
      "warehouse": {
        "cme_id": 6,
        "name": "Jablonec"
      },
      "business_date": "2026-04-20",
      "metrics": {
        "full_pallets": {
          "value": 10,
          "saved_date": "2026-04-20"
        },
        "full_roll_cages": {
          "value": 11,
          "saved_date": "2026-04-20"
        },
        "empty_pallets": {
          "value": 12,
          "saved_date": "2026-04-20"
        },
        "empty_roll_cages": {
          "value": 13,
          "saved_date": "2026-04-20"
        },
        "pallets_to_be_stocked": {
          "value": 14,
          "saved_date": "2026-04-20"
        },
        "dispatched_yesterday_pallets": {
          "value": 15,
          "saved_date": "2026-04-20"
        },
        "dispatched_yesterday_roll_cages": {
          "value": 16,
          "saved_date": "2026-04-20"
        }
      }
    }
  ],
  "meta": {
    "warehouse_count": 5,
    "populated_warehouse_count": 2
  }
}