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.infoapi call - get
order_idorder data - use
order_idfilter insales_order_shipment.list - this give list of shipments each
increment_id. id shipment's reference. - use shipment's
increment_idinsales_order_shipment.infomore details.
Comments
Post a Comment