Skip to main content

Search FIFO Layers

POST 
/api/v2/fifo-layers

Returns the same paginated list of FIFO cost layers as the GET version of this endpoint, but accepts filters as a JSON request body instead of the query string. Use this POST variant when the filter set is too large or too complex to fit in a URL.

Required scope: inventory:write

Grant this scope to your token under Settings → Developer → Personal Access Tokens.

Provide advanced filters under filter_groups, a tree of conditions combined with a conjunction of and or or. Each condition names a column, an operator, and a value. A free-text search term matches against layer id, SKU, product name, and warehouse.

Text columns (batch_number, product_name, sku, condition, source_type, link_type) accept: is, is_not, contains, does_not_contain, starts_with, ends_with, is_empty, is_not_empty, is_one_of, is_not_one_of. Numeric and date columns (id, original_quantity, fulfilled_quantity, avg_cost, total_cost, fifo_layer_date, created_at, updated_at, manufacture_date, expiry_date) accept: is, is_not, greater_than, greater_than_or_equal, less_than, less_than_or_equal, between, is_empty, is_not_empty. Additional filters include warehouse, availability, expiring_within_days, and archived.

Sortable columns (via sort, prefix with - for descending): id, fifo_layer_date, original_quantity, fulfilled_quantity, available_quantity, avg_cost, total_cost, condition, batch_number, manufacture_date, expiry_date, created_at, updated_at, warehouse_name, sku, product_name. Results default to -fifo_layer_date.

Request​

Responses​

OK

Response Headers
    Content-Type