---
title: "POST /ProductDetailQuery/DropdownProductsWithOnHand"
method: POST
path: "/ProductDetailQuery/DropdownProductsWithOnHand"
tags: ["ProductDetailQuery"]
---

# POST /ProductDetailQuery/DropdownProductsWithOnHand

`POST /ProductDetailQuery/DropdownProductsWithOnHand`

## Request

- Base URL: `https://api.khaasfood.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.khaasfood.com/ProductDetailQuery/DropdownProductsWithOnHand`
- Auth: OAuth 2
  - Authorization code: `https://api.khaasfood.com/connect/authorize`
  - Token URL: `https://api.khaasfood.com/connect/token`

## Request body

- KhaasFoodProductsDTOsProductDetailsProductFilterInputDto
  - `maxResultCount` integer
  - `skipCount` integer
  - `sorting` string, nullable
  - `filter` string, nullable
  - `isProductActive` boolean
  - `warehouseId` string, uuid, nullable
  - `isRawProduct` boolean
  - `orderState` string, nullable
  - `checkedOrderState` boolean, nullable
  - `isIncludeGroup` boolean, nullable
  - `productCategoryId` string, uuid, nullable
  - `unitOfMeasurementId` string, uuid, nullable
  - `brandId` string, uuid, nullable
  - `isInventoryWarehouse` boolean
  - `isStockOut` boolean
  - `isDirectSupply` boolean
  - `isPurchaseOrder` boolean
  - `isOfficeSupply` boolean
  - `type` string, nullable
  - `isFinishedProduct` boolean
  - `productName` string, nullable
  - `requisitionId` string, uuid, nullable
  - `requisitionType` 1 | 2 | 3 | 4
  - `getAll` boolean
  - `checkType` boolean

## Response `200`

Success

- KhaasFoodProductsDTOsProductDetailsDropdownWithPendingProcessingDto[]
  - `id` string, uuid, nullable
  - `text` string, nullable
  - `onHold` number, double
  - `onHand` number, double
  - `isStockOut` boolean
  - `lastTwelveDaysSaleCount` number, double
  - `lastMonthForwardSaleCount` number, double
  - `fortyFiveDayExpectedSale` number, double
  - `lastTwelveDaysFlag` string, nullable
  - `lastMonthForwardFlag` string, nullable

## Other responses

- `400`: Bad Request
- `401`: Unauthorized
- `403`: Forbidden
- `404`: Not Found
- `500`: Server Error
- `501`: Server Error

## Changes

> 11 revisions in range; 1 not diffed.

- **2026-10-20** `20dfdc539d6d`: 12 info
  - added the optional property `items/fortyFiveDayExpectedSale` to the response with the `200` status (media type: text/plain)
  - added the optional property `items/fortyFiveDayExpectedSale` to the response with the `200` status (media type: application/json)
  - added the optional property `items/fortyFiveDayExpectedSale` to the response with the `200` status (media type: text/json)
  - added the optional property `items/lastMonthForwardFlag` to the response with the `200` status (media type: text/plain)
  - …8 more

[Operation history](https://skmtc.dev/khaasfood/apis/khaasfood-api/changes/ProductDetailQuery/DropdownProductsWithOnHand/post.md)

---

[API](https://skmtc.dev/khaasfood/apis/khaasfood-api.md) - [All operations](https://skmtc.dev/khaasfood/apis/khaasfood-api/llms.txt) - [OpenAPI document](https://skmtc.dev/khaasfood/apis/khaasfood-api/revisions/149b6034bea9?raw)
