List orders (sales and purchase)
finale_list_ordersRead-only
List orders without their line items: orderId, type (SALES_ORDER or PURCHASE_ORDER), status (ORDER_CREATED, ORDER_LOCKED = committed, ORDER_COMPLETED, ORDER_CANCELLED), dates, origin/destination facility, reference number, total. Get the items with finale_get_order. For a large order history always pass updated_since (Finale cuts unfiltered collections at 120,000 rows before applying other filters). GET /{account}/api/order/.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum rows to return, 1-1000 (default 100). | |
| fields | No | Fields to return per row (default: a compact useful set). | |
| status | No | Only orders in this status. | |
| order_type | No | Only sales or only purchase orders. | |
| updated_since | No | Only records last updated on or after this UTC time. Finale allows a range of at most 30 days (updated_until defaults to now). | |
| updated_until | No | Only records last updated on or before this UTC time (needs updated_since). |