Skip to main content

Export AWD Ledgers

GET 
/api/amazon/unified/awd/ledgers/export

Streams the AWD ledger list as a CSV file (capped at 100,000 rows). Accepts the same filters as the paginated list, so a filtered export restates exactly what the table shows. Columns: ID, Integration, Date, Event Type, FNSKU, MSKU, Product SKU, Reference ID, Fulfillment Center, Disposition, Quantity, Reconciled Quantity, Reconciled At, COGS (per-unit, from the FIFO subledger), Extended COGS (signed by the event direction — negative for departures), FIFO Layer Date, Effective At, Linked Warehouse Transfer, Linked Sales Order, Created At.

Not yet available to API tokens

This endpoint currently requires session authentication; Personal Access Token scope support is in progress.

The response is a text/csv file download, not JSON. Also carries 'FIFO Layer Date' and 'Effective At' — the valuation instants the Inventory Value Change report windows AWD rows by (arrivals by their created layer's date; departures by their consumptions' effective instant) — so an export can be re-windowed onto the report's basis. A final 'Row Source' column distinguishes real Amazon ledger rows from DERIVED subledger rows: when the export's date filter pins a full window (between/is on date), the file also carries the recognitions the valuation reports count that have no Amazon ledger row — summary true-ups, initial-inventory layers, unlinked consumptions, and closure-rounding flushes (IDs prefixed L-/C-/F-) — so a filtered export sums to the reports' change without leaving the file.

Request​

Responses​

Successful response