Order Flow API

Cross-document per-product report — customer order, supplier order, delivery note and invoice in a single row

Base URL

https://{tenant}.logzi.com/api/product-flow/

Every request returns a JSON response. On success result.code == 1, on error result.code == 0.

GET /api/product-flow/list

Retrieves the per-product order flow list. Each row shows a customer order line together with its linked supplier order, delivery note and invoice.

Query parameters

Parameter Type Required Description
list_count int Number of records per page (default: 10)
list_offset int Offset for pagination (default: 0)
list_condition[product_name] string Product name filter (partial match, case-insensitive)
list_condition[product_partnumber] string Part number filter (partial match)
list_condition[date_from] date Customer order fulfillment date from (format: YYYY-MM-DD)
list_condition[date_to] date Customer order fulfillment date to (format: YYYY-MM-DD)
list_condition[partner_id] int Customer partner ID — only orders belonging to this partner
list_sort[field] string Name of the field to sort by (e.g. order_in_date_perform, partnumber, product_name)
list_sort[sort] string Sort direction: ASC or DESC (default: DESC)

Example request

GET /api/product-flow/list?list_count=20&list_offset=0&list_condition[date_from]=2025-01-01&list_condition[date_to]=2025-12-31
X-API-KEY: {your_api_key}

Example response

{
  "result": { "code": 1, "message": "success" },
  "list_count": 20,
  "list_offset": 0,
  "list_all": 142,
  "data": [
    {
      "order_in_item_id": 1501,
      "order_in_id": 312,
      "order_in_identify": "VREND-2025-0312",
      "identify_customer": "VEVOI-REF-001",
      "order_in_date_create": "2025-03-10",
      "order_in_date_perform": "2025-03-20",
      "order_in_quantity": 5,
      "order_in_incoming_price": 8000,
      "order_in_price_margin": 10000,
      "order_in_price_margin_percent": 20.0,
      "order_in_price_netto": 50000,
      "order_in_price_brutto": 63500,
      "order_in_price_tax": 13500,
      "order_in_tax_id": 3,
      "order_in_currency_id": 1,
      "order_in_status_id": 3,
      "order_in_status_name": "Teljesítve",
      "customer_status_id": 2,
      "order_in_customer_status_name": "Átadva",
      "order_in_paymod_id": 1,
      "order_in_paymod_name": "Átutalás",
      "order_in_shipping_id": 2,
      "order_in_shipping_name": "Futárszolgálat",
      "order_in_partner": "Minta Kft.",
      "order_in_shipping_addr": "1117 Budapest, Példa utca 1.",
      "order_in_shipping_user": "Kovács János",
      "order_in_billing_addr": "1117 Budapest, Számla utca 2.",
      "product_id": 88,
      "product_group_id": 45,
      "partnumber": "TERM-0088",
      "product_name": "Minta termék",
      "category_id": 7,
      "stockable": 1,
      "synchronizable": 0,
      "drs": 0,
      "excisable": 0,
      "acquisition_partner_id": 12,
      "ledger_number_in_id": 3,
      "ledger_number_out_id": 5,
      "order_out_id": 201,
      "order_out_identify": "SZREND-2025-0201",
      "order_out_date_create": "2025-03-11",
      "order_out_date_perform": "2025-03-18",
      "order_out_status_id": 3,
      "order_out_status_name": "Teljesítve",
      "order_out_quantity": 5,
      "order_out_price_netto": 40000,
      "order_out_price_brutto": 50800,
      "order_out_price_tax": 10800,
      "order_out_partner": "Szállító Zrt.",
      "dn_id": 98,
      "dn_identify": "SZLEV-2025-0098",
      "dn_date_create": "2025-03-17",
      "dn_date_perform": "2025-03-18",
      "dn_status_id": 2,
      "dn_status_name": "Lezárva",
      "dn_quantity": 5,
      "dn_price_netto": 40000,
      "dn_price_brutto": 50800,
      "dn_price_tax": 10800,
      "dn_partner": "Szállító Zrt.",
      "invoice_id": 455,
      "invoice_identify": "SZL-2025-0455",
      "invoice_receipt_type_cr_id": null,
      "invoice_date_create": "2025-03-20",
      "invoice_date_perform": "2025-03-20",
      "invoice_date_validity": "2025-03-20",
      "invoice_date_payoff": "2025-04-03",
      "invoice_status_id": 2,
      "invoice_status_name": "Kiállítva",
      "invoice_paymode_id": 1,
      "invoice_paymod_name": "Átutalás",
      "invoice_quantity": 5,
      "invoice_price_netto": 50000,
      "invoice_price_brutto": 63500,
      "invoice_price_tax": 13500,
      "invoice_partner": "Minta Kft."
    }
  ]
}

Response field descriptions

Field Group Description
order_in_item_idCustomer orderUnique identifier of the order line (row ID)
order_in_idCustomer orderCustomer order header identifier
order_in_identifyCustomer orderCustomer order number
identify_customerCustomer orderCustomer's own order number
order_in_date_createCustomer orderDate the order was recorded (YYYY-MM-DD)
order_in_date_performCustomer orderCommitted fulfillment date (YYYY-MM-DD)
order_in_quantityCustomer orderOrdered quantity
order_in_incoming_priceCustomer orderPurchase price valid at time of order (HUF)
order_in_price_marginCustomer orderMargin amount (HUF)
order_in_price_margin_percentCustomer orderMargin rate (%)
order_in_price_nettoCustomer orderNet price (HUF)
order_in_price_bruttoCustomer orderGross price (HUF)
order_in_price_taxCustomer orderVAT amount (HUF)
order_in_status_nameCustomer orderOrder status name
order_in_customer_status_nameCustomer orderCustomer-facing status name
order_in_paymod_nameCustomer orderPayment method name
order_in_shipping_nameCustomer orderShipping method name
order_in_partnerCustomer orderCustomer partner name
order_in_shipping_addrCustomer orderShipping address
order_in_shipping_userCustomer orderName of the contact at the shipping location
order_in_billing_addrCustomer orderBilling address
product_idProductUnique product identifier
product_group_idProductProduct group identifier
partnumberProductPart number
product_nameProductProduct name
category_idProductProduct category identifier
stockableProductWhether it is stockable (1/0)
order_out_idSupplier orderSupplier order identifier (null if none)
order_out_identifySupplier orderSupplier order number
order_out_date_performSupplier orderSupplier order fulfillment date
order_out_quantitySupplier orderSupplier order quantity
order_out_price_nettoSupplier orderSupplier order net price (HUF)
order_out_price_bruttoSupplier orderSupplier order gross price (HUF)
order_out_partnerSupplier orderSupplier partner name
order_out_status_nameSupplier orderSupplier order status name
dn_idDelivery noteDelivery note identifier (null if none)
dn_identifyDelivery noteDelivery note number
dn_date_performDelivery noteDelivery note fulfillment date
dn_quantityDelivery noteDelivery note quantity
dn_price_nettoDelivery noteDelivery note net price (HUF)
dn_price_bruttoDelivery noteDelivery note gross price (HUF)
dn_partnerDelivery noteDelivery note partner
dn_status_nameDelivery noteDelivery note status name
invoice_idInvoiceInvoice identifier (null if none)
invoice_identifyInvoiceInvoice number
invoice_date_performInvoiceInvoice fulfillment date
invoice_date_payoffInvoicePayment due date
invoice_quantityInvoiceInvoiced quantity
invoice_price_nettoInvoiceInvoice net amount (HUF)
invoice_price_bruttoInvoiceInvoice gross amount (HUF)
invoice_partnerInvoiceInvoice partner (customer name)
invoice_status_nameInvoiceInvoice status name
invoice_paymod_nameInvoiceInvoice payment method name