expiration_lots

Fetch expiration lots matching the supplied arguments.

Arguments

Argument	Type	Required	Description
`sku`	`String`	No	Filter by SKU. SKU matching is case-insensitive and ignores surrounding whitespace.
`po_id`	`String`	No	Filter by PO ID; pass the public API ID unless the field name says legacy ID.
`analyze`	`Boolean`	No	If true, the query will only be analyzed (cost estimated) without executing it.

Return Type

LotsQueryResult

Query

query expiration_lots(
  $sku: String,
  $po_id: String,
  $analyze: Boolean
) {
  expiration_lots(
    sku: $sku,
    po_id: $po_id,
    analyze: $analyze
  ) {
    request_id
    complexity
    data {
      ...LotConnectionFragment
    
      pageInfo {
        ...PageInfoFragment
      
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      edges {
        ...LotEdgeFragment
      
        node {
          ...LotFragment
        
          id
          legacy_id
          account_id
          po_id
          name
          sku
          created_at
          updated_at
          expires_at
          received_at
          is_active
          locations {
            ...LocationConnectionFragment
          
            pageInfo {
              ...PageInfoFragment
            
              hasNextPage
              hasPreviousPage
              startCursor
              endCursor
            }
            edges {
              ...LocationEdgeFragment
            
              node {
                ...LocationFragment
              
                id
                legacy_id
                account_id
                warehouse_id
                type {
                  ...LocationTypeFragment
                
                  id
                  legacy_id
                  account_id
                  name
                  daily_storage_cost
                  category
                  is_lpn_allowed
                }
                name
                zone
                pickable
                sellable
                staging
                is_cart
                pick_priority
                dimensions {
                  ...DimensionsFragment
                
                  weight
                  height
                  width
                  length
                }
                length
                width
                height
                max_weight
                temperature
                products {
                  ...ProductConnectionFragment
                
                  pageInfo {
                    ...PageInfoFragment
                  
                    hasNextPage
                    hasPreviousPage
                    startCursor
                    endCursor
                  }
                  edges {
                    ...ProductEdgeFragment
                  
                    node {
                      ...ProductFragment
                    }
                    cursor
                  }
                }
                last_counted
                created_at
                expiration_lots {
                  ...LotConnectionFragment
                }
              }
              cursor
            }
          }
          purchase_orders {
            ...PurchaseOrderConnectionFragment
          
            pageInfo {
              ...PageInfoFragment
            
              hasNextPage
              hasPreviousPage
              startCursor
              endCursor
            }
            edges {
              ...PurchaseOrderEdgeFragment
            
              node {
                ...PurchaseOrderFragment
              
                id
                legacy_id
                po_number
                account_id
                warehouse_id
                vendor_id
                created_at
                po_date
                date_closed
                arrived_at
                packing_note
                fulfillment_status
                po_note
                description
                partner_order_number
                subtotal
                discount
                total_price
                tax
                shipping_method
                shipping_carrier
                shipping_name
                shipping_price
                tracking_number
                pdf
                images
                payment_method
                payment_due_by
                payment_note
                locking
                locked_by_user_id
                line_items {
                  ...PurchaseOrderLineItemConnectionFragment
                
                  pageInfo {
                    ...PageInfoFragment
                  
                    hasNextPage
                    hasPreviousPage
                    startCursor
                    endCursor
                  }
                  edges {
                    ...PurchaseOrderLineItemEdgeFragment
                  
                    node {
                      ...PurchaseOrderLineItemFragment
                    }
                    cursor
                  }
                }
                attachments {
                  ...PurchaseOrderAttachmentConnectionFragment
                
                  pageInfo {
                    ...PageInfoFragment
                  
                    hasNextPage
                    hasPreviousPage
                    startCursor
                    endCursor
                  }
                  edges {
                    ...PurchaseOrderAttachmentEdgeFragment
                  
                    node {
                      ...PurchaseOrderAttachmentFragment
                    }
                    cursor
                  }
                }
                vendor {
                  ...VendorFragment
                
                  id
                  legacy_id
                  name
                  email
                  account_number
                  account_id
                  address {
                    ...AddressFragment
                  
                    name
                    address1
                    address2
                    city
                    state
                    country
                    zip
                    phone
                  }
                  currency
                  internal_note
                  default_po_note
                  logo
                  partner_vendor_id
                  created_at
                }
                warehouse {
                  ...WarehouseFragment
                
                  id
                  legacy_id
                  account_id
                  identifier
                  dynamic_slotting
                  invoice_email
                  phone_number
                  profile
                  address {
                    ...AddressFragment
                  
                    name
                    address1
                    address2
                    city
                    state
                    country
                    zip
                    phone
                  }
                  return_address {
                    ...AddressFragment
                  
                    name
                    address1
                    address2
                    city
                    state
                    country
                    zip
                    phone
                  }
                  company_name
                  company_alias
                  active
                  products {
                    ...ProductConnectionFragment
                  
                    pageInfo {
                      ...PageInfoFragment
                    }
                    edges {
                      ...ProductEdgeFragment
                    }
                  }
                }
                origin_of_shipment
                tracking_numbers {
                  ...PurchaseOrderTrackingNumberConnectionFragment
                
                  pageInfo {
                    ...PageInfoFragment
                  
                    hasNextPage
                    hasPreviousPage
                    startCursor
                    endCursor
                  }
                  edges {
                    ...PurchaseOrderTrackingNumberEdgeFragment
                  
                    node {
                      ...PurchaseOrderTrackingNumberFragment
                    }
                    cursor
                  }
                }
                ship_date
              }
              cursor
            }
          }
        }
        cursor
      }
    }
  }
}

Variables

{
  "sku": "BLUE-TEE-M",
  "po_id": "UHVyY2hhc2VPcmRlcjoxMjM0",
  "analyze": true
}

Response

{
  "data": {
    "expiration_lots": {
      "request_id": "UmVjb3JkOjEyMzQ=",
      "complexity": 100,
      "data": [{id: "TG90OjEyMzQ="}]
    }
  }
}