Report Export API

Authentication

Authorization: Bearer <api_key>

All report endpoints support ?days=30. Use days=0 for all available history.

Reports also support environment=live and environment=test. Use the environment that matches the routing data you want to export.

GET /clients/{client_id}/exports/routing-decisions-report?days=30&environment=live

Filename format

App-generated report downloads include the client, environment, date window, and timestamp so users can distinguish live vs. test exports and avoid stale-file confusion.

routeiq_latest_order_routing_detail_client_{client_id}_{environment}_last_{days}_days_{timestamp}.csv

Latest Order Routing Detail

GET /clients/{client_id}/exports/routing-decisions-report?days=30&environment=live

Detailed order/SKU/allocation report. The CSV filename starts with routeiq_latest_order_routing_detail. This export includes unroutable reason fields for NONE decisions: unroutable_reason_code, unroutable_category, unroutable_reason, and recommended_action.

This report also includes routing-control audit fields:

Field	Description
routing_profile_applied	true when the order matched an enabled Routing Profile.
routing_profile_name	The matched Routing Profile name, or Default when no profile applied.
routing_profile_partner_id	The partner/channel/order-class value that matched the Routing Profile.
item_control_applied	true when one or more Item Control rules affected the routing decision.
item_control_summary	Customer-readable summary of the applied Item Control rule, such as restricted warehouses, split/partial restrictions, max transit rules, or notes.

Routing Quality Summary

GET /clients/{client_id}/exports/routing-quality-summary?days=30&environment=live

Summarizes order count, percentage, and value by routing quality and fulfillment status.

Warehouse Performance Summary

GET /clients/{client_id}/exports/warehouse-performance-summary?days=30&environment=live

Summarizes allocation volume, units, value, and quality counts by customer-configured warehouse.

SKU Issue Summary

GET /clients/{client_id}/exports/sku-issue-summary?days=30&environment=live

Summarizes SKUs driving inventory-related unroutable results, unfulfilled quantity, and suboptimal routing. Invalid order data such as invalid destination ZIPs is reported in the order routing detail and dashboard unroutable reasons, not as a SKU issue.

Customer-safe warehouse fields

Report CSVs use customer-facing configured warehouse IDs and names. RouteIQ support fields and internal warehouse codes are not included in customer-facing report exports.

For unroutable orders, unroutable_reason_code is the stable machine-readable field. unroutable_reason and recommended_action are written for operators and support teams.

Routing Profile and Item Control fields are included so customers can audit which configured routing controls affected a decision without exposing internal implementation details.