api - How can I filter sales_order_shipment.list by order increment_id -
i want find shipments on order (sales order info not appear have information) data::printer dump format
[0] "sales_order_shipment.list", [1] [ [0] { increment_id { eq 100000025 } } ]
but filters shipment increment id. this
[0] "sales_order_shipment.list", [1] [ [0] { order_increment_id { eq 100000025 } } ]
which throws sql error. suspect need join tables via api somehow, i'm not sure how can that.
this possible using filter on order's order_id
value.
note order_id
different order's increment_id
usual customer facing reference number. therefore step required convert order's reference order_id
.
i can describe method:
- get order data order number (
increment_id
) usingsales_order.info
api call - get
order_id
order data - use
order_id
filter insales_order_shipment.list
- this give list of shipments each
increment_id
. id shipment's reference. - use shipment's
increment_id
insales_order_shipment.info
more details.
Comments
Post a Comment