Sign in
Reporting

Lists report-ready shipment line rows from the shipping reporting view, including pre-computed dollar columns ($ shipped, $ unshipped, total $ ordered, unit price) so callers do not need to hand-join shipments to sales-order line items.

post/api/reporting/shipping/list

Query parameters

Sort.Fieldstring

Sort field

Sort.Dir'ascending' | 'descending'

Specify sorting direction.

Sort direction

Skipinteger

Number of records to skip.

Takeinteger

Number of records to return (maximum)

Request body

shipByDateFromstring date-time nullable

Inclusive lower bound applied to the shipment's Ship By Date. Null means no lower bound.

shipByDateTostring date-time nullable

Inclusive upper bound applied to the shipment's Ship By Date (the whole to day is included). Null means no upper bound.

shippedDateFromstring date-time nullable

Inclusive lower bound applied to the date the shipment actually shipped — its ship-date override when one is set, else its recorded ship date. Distinct from FulcrumProduct.PublicApi.Dto.Reporting.ShippingReportFilter.ShipByDateFrom, which bounds the date it was due to ship rather than the date it did. Matches only shipments whose status is Shipped: a ship-date override can be set while a shipment is still open, so the date alone does not mean it went out. Null means no lower bound.

shippedDateTostring date-time nullable

Inclusive upper bound applied to that same actual ship date (the whole to day is included, whatever time of day the shipment went out), and likewise matching only shipments whose status is Shipped. Null means no upper bound.

statusstring nullable

Optional exact-match filter on the shipment lifecycle status (e.g. "Shipped", "Open"). Null means no status filter.

Response

A page of shipping report rows with the total matching count.

pageinteger required

The 1-indexed page

pageSizeinteger required

The page size

totalCountinteger required

The total count of records

totalPagesinteger required

The total pages

hasPreviousPageboolean required

True if there is a previous page

hasNextPageboolean required

True if there is a next page

Changes

Changed in 1 of the 12 revisions of this API.8

  • a41e60b375bc8See the full diff
    • ○

      added the new optional request property shippedDateFrom (media type: application/json-patch+json)

      new-optional-request-property

    • ○

      added the new optional request property shippedDateFrom (media type: application/json)

      new-optional-request-property

    • ○

      added the new optional request property shippedDateFrom (media type: text/json)

      new-optional-request-property

    • ○

      added the new optional request property shippedDateFrom (media type: application/*+json)

      new-optional-request-property

    • ○

      added the new optional request property shippedDateTo (media type: application/json-patch+json)

      new-optional-request-property

    • ○

      added the new optional request property shippedDateTo (media type: application/json)

      new-optional-request-property

    • ○

      added the new optional request property shippedDateTo (media type: text/json)

      new-optional-request-property

    • ○

      added the new optional request property shippedDateTo (media type: application/*+json)

      new-optional-request-property