Articles in this section

See more

Production API Integration: Product Orders

  • Updated
Follow

L2L makes it easy to add, update, and retrieve the status of Product Orders. This is helpful when integrating Product Orders with other systems, such as an ERP system. Product Orders can be created, defined, and scheduled in an ERP system, then pushed to L2L for execution and to provide visibility to the shop floor.

Here are some common touch points and which L2L APIs to use:

Create a New Order

Objective: Create new order in L2L from order details in ERP
Frequency: Twice per day, On demand
Process Outline:

  1. Query ERP for new orders that haven't been created into L2L
  2. Create new orders in L2L one by one 
    POST https://[customer].leading2lean.com/api/1.0/productorders/sync_ekanban_order/?auth=[api key]
    1. Required POST Parameters: site=[site id]&productcode=[product code]&name=[name]&order_quantity=[order qantity]&card_size=[card size]
      1. This will create an order split up by card_size. card_size is commonly used to split up an order by standard pack size (e.g. 100 parts per pallet). card_size can equal the order_quantity if you do not wish to split the order into multiple parts.
    2. See the official API documentation for a full list of optional fields. It is recommended that you set the L2L Product Order externalid property with the ERP's Order ID.
  3. Update ERP system with L2L product id sent in the return object. This can be used to update the order in the future.

Update an L2L Order with details from ERP

Objective: Update an existing order in L2L from order details in ERP
Frequency: On demand
Process Outline:

  1. Query ERP for orders that have been updated since they were added or updated in L2L
  2. Retrieve the product order from L2L using the L2L Product Order ID that was stored when the order was created 
    GET https://[customer].leading2lean.com/api/1.0/productorders/?auth=[api key]&site=[site id]&id=[product order id]
    1. This will return JSON object with all properties of the Product Order
    2. The L2L Product Order may be looked up using an externalid if stored when creating an order.
  3. Update all properties if the Product Order from order details from the ERP
  4. Update order in L2L 
    POST https://[customer].leading2lean.com/api/1.0/productorders/sync_order/[product order id]/?auth=[api key]
    1. Required POST Parameters: site=[site id]&productcode=[product code]&name=[name]
    2. See the official API documentation for a full list of optional fields

Update an ERP Order with details from L2L

Objective: Keep ERP order details in sync with L2L
Frequency: Once per day to look up order status, On demand
Process Outline:

  1. Query L2L for a list of product orders 
    GET https://[customer].leading2lean.com/api/1.0/productorders/?auth=[api key]&site=[site id]&status__gte=2
    1. See the official API documentation for a list of parameters that can be used to filter this API
  2. Update Order details in ERP using details from the L2L response

Related

Related articles

Comments

0 comments

Please sign in to leave a comment.