FutureFulfillment Picqer Dashboard v2

JSON-only API for dashboard data. No markdown responses.

Commands

All commands return JSON. No chat explanations.

dashboard.fetch

Returns complete DashboardData object with KPIs, picklists, stock, and revenue.

Input: { "command": "dashboard.fetch", "filters": { "dateFrom": "2024-01-01", "dateTo": "2024-01-31", "picker": "", "client": "" } }

picklists.fetch

Returns only picklists data (open, closed, picker stats).

Input: { "command": "picklists.fetch", "filters": {} }

stock.fetch

Returns stock movements with slow/fast mover categorization.

Input: { "command": "stock.fetch", "filters": {} }

revenue.fetch

Returns revenue per client for sell-stock clients.

Input: { "command": "revenue.fetch", "filters": {} }

Response Format

Always returns JSON. Example success:

{
  "kpis": { "openPicklists": 42, "closedPicklists": 128, ... },
  "picklists": { "open": [...], "closed": [...], "pickerStats": [...] },
  "stock": { "rows": [...] },
  "revenue": { "perClient": [...] },
  "filtersUsed": { ... }
}

Example error:

{ "error": "Picqer API not configured" }

Security

• API key only in local .env file
• No credentials in OpenClaw config
• Access via Tailscale only