---
title: "GET /RoutingQuery/GetRouteDetailByProductId"
method: GET
path: "/RoutingQuery/GetRouteDetailByProductId"
tags: ["RoutingQuery"]
---

# GET /RoutingQuery/GetRouteDetailByProductId

`GET /RoutingQuery/GetRouteDetailByProductId`

## 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/RoutingQuery/GetRouteDetailByProductId`
- Auth: OAuth 2
  - Authorization code: `https://api.khaasfood.com/connect/authorize`
  - Token URL: `https://api.khaasfood.com/connect/token`

## Query parameters

- `id` string, uuid

## Response `200`

Success

- KhaasFoodRoutingsDtosRoutingDto
  - `id` string, uuid
  - `creationTime` string, date-time
  - `creatorId` string, uuid, nullable
  - `lastModificationTime` string, date-time, nullable
  - `lastModifierId` string, uuid, nullable
  - `isDeleted` boolean
  - `deleterId` string, uuid, nullable
  - `deletionTime` string, date-time, nullable
  - `number` string, nullable
  - `quantity` number, double
  - `cycleTime` number, double
  - `fixedCost` number, double
  - `variableCost` number, double
  - `description` string, nullable
  - `productDetailId` string, uuid, nullable
  - `productDetail` KhaasFoodProductsDTOsProductDetailsProductDetailDto
    - `id` string, uuid
    - `creationTime` string, date-time
    - `creatorId` string, uuid, nullable
    - `lastModificationTime` string, date-time, nullable
    - `lastModifierId` string, uuid, nullable
    - `isDeleted` boolean
    - `deleterId` string, uuid, nullable
    - `deletionTime` string, date-time, nullable
    - `wcId` integer
    - `wcSku` string, nullable
    - `wcCategoryId` integer
    - `wcType` string, nullable
    - `wcVariationId` integer
    - `wcVariationOption` string, nullable
    - `wcVariationPermalink` string, nullable
    - `shopId` string, nullable
    - `name` string, nullable
    - `parentName` string, nullable
    - `variationName` string, nullable
    - `model` string, nullable
    - `year` string, nullable
    - `barcode` string, nullable
    - `slug` string, nullable
    - `productCode` string, nullable
    - `hasUniqueSerial` boolean
    - `hasWarrenty` boolean
    - `salePrice` number, double
    - `dealerPrice` number, double
    - `nationalDistributionPrice` number, double
    - `costPrice` number, double
    - `dealerCashPrice` number, double
    - `dealerDuePrice` number, double
    - `franchisePrice` number, double
    - `partnershipPrice` number, double
    - `type` string, nullable
    - `color` string, nullable
    - `processingQty` number, double
    - `pendingQty` number, double
    - `minimumStockToNotify` integer
    - `startingInventory` integer
    - `purchased` number, double
    - `sold` number, double
    - `onHand` number, double
    - `homeDeliveryCharge` number, double
    - `courierCharge` number, double
    - `displayOrder` integer
    - `stockIn` number, double
    - `stockOut` number, double
    - `productCategoryId` string, nullable
    - `productName` string, nullable
    - `brandId` string, uuid
    - `brandName` string, nullable
    - `tags` string, nullable
    - `relatedProductNames` string[], nullable
    - `description` string, nullable
    - `shortDescription` string, nullable
    - `additionalDetails` string, nullable
    - `isRawProduct` boolean
    - `damage` number, double
    - `gift` number, double
    - `return` number, double
    - `discountPercent` number, double, nullable
    - `webDiscountPercent` number, double, nullable
    - `bizBookDiscountPercent` number, double, nullable
    - `isStockOut` boolean
    - `isDirectSupply` boolean
    - `isPackagingMaterial` boolean
    - `isShowPackagingProductOnOrder` boolean
    - `isPackagingMaterialExcludedFromBom` boolean
    - `isExcludedFromRequisition` boolean
    - `applyDiscount` boolean
    - `webApplyDiscount` boolean
    - `bizBookApplyDiscount` boolean
    - `isDiscountOnlyForApp` boolean
    - `isShowDiscountAmount` boolean
    - `webIsShowDiscountAmount` boolean
    - `bizBookIsShowDiscountAmount` boolean
    - `discountAmount` number, double
    - `sendToVoucherInventory` boolean
    - `unitOfMeasurementId` string, nullable
    - `unitOfMeasurementName` string, nullable
    - `isActive` boolean
    - `isNationalDistributionSaleProduct` boolean
    - `isRegularSaleProduct` boolean
    - `salePricePerUnitBeforeDiscount` number, double
    - `isBundleProduct` boolean
    - `isPriceEditable` boolean
    - `isPreOrderProduct` boolean
    - `isPreOrderAllowWithRegularProduct` boolean
    - `isShowOnApp` boolean
    - `isShowOnWeb` boolean
    - `isDeliveryChargeMultipliedByQuantity` boolean
    - `isOfficeSupply` boolean
    - `hasSeparateDeliveryCharge` boolean
    - `preOrderDeliveryDate` string, date-time, nullable
    - `estimatedDeliveryFrom` string, date-time, nullable
    - `estimatedDeliveryTo` string, date-time, nullable
    - `productImages` KhaasFoodProductsDTOsProductDetailsProductImageCreateUpdateInputDto[], nullable
      - `id` string, uuid, nullable
      - `image` KhaasFoodProductsDTOsImageDto
        - `url` string, nullable
        - `alt` string, nullable
        - `title` string, nullable
        - `caption` string, nullable
        - `description` string, nullable
      - `name` string, nullable
      - `isPrimary` boolean
      - `displayOrder` integer
    - `packageProductInfos` KhaasFoodProductsDTOsPackageProductInfosPackageProductInfoDto[], nullable
      - `id` string, uuid
      - `packageProductId` string, uuid
      - `productDetailId` string, uuid
      - `quantity` number, double
      - `mrp` number, double
    - `productMappings` KhaasFoodProductsDTOsProductDetailsProductMappingDto[], nullable
      - `id` string, uuid
      - `creationTime` string, date-time
      - `creatorId` string, uuid, nullable
      - `lastModificationTime` string, date-time, nullable
      - `lastModifierId` string, uuid, nullable
      - `isDeleted` boolean
      - `deleterId` string, uuid, nullable
      - `deletionTime` string, date-time, nullable
      - `originalProductId` string, uuid
      - `mappedProductId` string, uuid
      - `mappedProductQuantity` number, double
      - `contributionPercentage` number, double
    - `seoTitle` string, nullable
    - `focusKeyphrase` string, nullable
    - `metaDescription` string, nullable
  - `bomId` string, uuid, nullable
  - `moId` string, uuid, nullable
  - `bom` KhaasFoodBomsDtosBOMDto
    - `id` string, uuid
    - `creationTime` string, date-time
    - `creatorId` string, uuid, nullable
    - `lastModificationTime` string, date-time, nullable
    - `lastModifierId` string, uuid, nullable
    - `name` string, nullable
    - `approximateCost` number, double
    - `productDetailId` string, uuid
    - `productDetailName` string, nullable
    - `bomLineItems` KhaasFoodManufacturingOrdersDtosBomLineItemDto[], nullable
      - `id` string, uuid
      - `productDetailId` string, uuid
      - `productDetailName` string, nullable
      - `quantity` number, double
      - `costPricePerUnit` number, double
      - `costTotal` number, double
    - `routing` KhaasFoodRoutingsDtosRoutingDto (recursive)
  - `manufacturingOrder` KhaasFoodManufacturingOrdersDtosManufacturingOrderDto
    - `id` string, uuid
    - `creationTime` string, date-time
    - `creatorId` string, uuid, nullable
    - `lastModificationTime` string, date-time, nullable
    - `lastModifierId` string, uuid, nullable
    - `isDeleted` boolean
    - `deleterId` string, uuid, nullable
    - `deletionTime` string, date-time, nullable
    - `moProductionQuantity` number, double
    - `number` string, nullable
    - `quantity` number, double
    - `productDetailId` string, uuid, nullable
    - `productDetail` KhaasFoodProductsDTOsProductDetailsProductDetailDto
      - `id` string, uuid
      - `creationTime` string, date-time
      - `creatorId` string, uuid, nullable
      - `lastModificationTime` string, date-time, nullable
      - `lastModifierId` string, uuid, nullable
      - `isDeleted` boolean
      - `deleterId` string, uuid, nullable
      - `deletionTime` string, date-time, nullable
      - `wcId` integer
      - `wcSku` string, nullable
      - `wcCategoryId` integer
      - `wcType` string, nullable
      - `wcVariationId` integer
      - `wcVariationOption` string, nullable
      - `wcVariationPermalink` string, nullable
      - `shopId` string, nullable
      - `name` string, nullable
      - `parentName` string, nullable
      - `variationName` string, nullable
      - `model` string, nullable
      - `year` string, nullable
      - `barcode` string, nullable
      - `slug` string, nullable
      - `productCode` string, nullable
      - `hasUniqueSerial` boolean
      - `hasWarrenty` boolean
      - `salePrice` number, double
      - `dealerPrice` number, double
      - `nationalDistributionPrice` number, double
      - `costPrice` number, double
      - `dealerCashPrice` number, double
      - `dealerDuePrice` number, double
      - `franchisePrice` number, double
      - `partnershipPrice` number, double
      - `type` string, nullable
      - `color` string, nullable
      - `processingQty` number, double
      - `pendingQty` number, double
      - `minimumStockToNotify` integer
      - `startingInventory` integer
      - `purchased` number, double
      - `sold` number, double
      - `onHand` number, double
      - `homeDeliveryCharge` number, double
      - `courierCharge` number, double
      - `displayOrder` integer
      - `stockIn` number, double
      - `stockOut` number, double
      - `productCategoryId` string, nullable
      - `productName` string, nullable
      - `brandId` string, uuid
      - `brandName` string, nullable
      - `tags` string, nullable
      - `relatedProductNames` string[], nullable
      - `description` string, nullable
      - `shortDescription` string, nullable
      - `additionalDetails` string, nullable
      - `isRawProduct` boolean
      - `damage` number, double
      - `gift` number, double
      - `return` number, double
      - `discountPercent` number, double, nullable
      - `webDiscountPercent` number, double, nullable
      - `bizBookDiscountPercent` number, double, nullable
      - `isStockOut` boolean
      - `isDirectSupply` boolean
      - `isPackagingMaterial` boolean
      - `isShowPackagingProductOnOrder` boolean
      - `isPackagingMaterialExcludedFromBom` boolean
      - `isExcludedFromRequisition` boolean
      - `applyDiscount` boolean
      - `webApplyDiscount` boolean
      - `bizBookApplyDiscount` boolean
      - `isDiscountOnlyForApp` boolean
      - `isShowDiscountAmount` boolean
      - `webIsShowDiscountAmount` boolean
      - `bizBookIsShowDiscountAmount` boolean
      - `discountAmount` number, double
      - `sendToVoucherInventory` boolean
      - `unitOfMeasurementId` string, nullable
      - `unitOfMeasurementName` string, nullable
      - `isActive` boolean
      - `isNationalDistributionSaleProduct` boolean
      - `isRegularSaleProduct` boolean
      - `salePricePerUnitBeforeDiscount` number, double
      - `isBundleProduct` boolean
      - `isPriceEditable` boolean
      - `isPreOrderProduct` boolean
      - `isPreOrderAllowWithRegularProduct` boolean
      - `isShowOnApp` boolean
      - `isShowOnWeb` boolean
      - `isDeliveryChargeMultipliedByQuantity` boolean
      - `isOfficeSupply` boolean
      - `hasSeparateDeliveryCharge` boolean
      - `preOrderDeliveryDate` string, date-time, nullable
      - `estimatedDeliveryFrom` string, date-time, nullable
      - `estimatedDeliveryTo` string, date-time, nullable
      - `productImages` KhaasFoodProductsDTOsProductDetailsProductImageCreateUpdateInputDto[], nullable
        - `id` string, uuid, nullable
        - `image` KhaasFoodProductsDTOsImageDto
          - `url` string, nullable
          - `alt` string, nullable
          - `title` string, nullable
          - `caption` string, nullable
          - `description` string, nullable
        - `name` string, nullable
        - `isPrimary` boolean
        - `displayOrder` integer
      - `packageProductInfos` KhaasFoodProductsDTOsPackageProductInfosPackageProductInfoDto[], nullable
        - `id` string, uuid
        - `packageProductId` string, uuid
        - `productDetailId` string, uuid
        - `quantity` number, double
        - `mrp` number, double
      - `productMappings` KhaasFoodProductsDTOsProductDetailsProductMappingDto[], nullable
        - `id` string, uuid
        - `creationTime` string, date-time
        - `creatorId` string, uuid, nullable
        - `lastModificationTime` string, date-time, nullable
        - `lastModifierId` string, uuid, nullable
        - `isDeleted` boolean
        - `deleterId` string, uuid, nullable
        - `deletionTime` string, date-time, nullable
        - `originalProductId` string, uuid
        - `mappedProductId` string, uuid
        - `mappedProductQuantity` number, double
        - `contributionPercentage` number, double
      - `seoTitle` string, nullable
      - `focusKeyphrase` string, nullable
      - `metaDescription` string, nullable
    - `bomId` string, nullable
    - `status` 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
    - `transferQty` number, double
    - `bom` KhaasFoodBomsDtosBOMDto
      - `id` string, uuid
      - `creationTime` string, date-time
      - `creatorId` string, uuid, nullable
      - `lastModificationTime` string, date-time, nullable
      - `lastModifierId` string, uuid, nullable
      - `name` string, nullable
      - `approximateCost` number, double
      - `productDetailId` string, uuid
      - `productDetailName` string, nullable
      - `bomLineItems` KhaasFoodManufacturingOrdersDtosBomLineItemDto[], nullable
        - `id` string, uuid
        - `productDetailId` string, uuid
        - `productDetailName` string, nullable
        - `quantity` number, double
        - `costPricePerUnit` number, double
        - `costTotal` number, double
      - `routing` KhaasFoodRoutingsDtosRoutingDto (recursive)
    - `moQuantity` number, double
    - `productionQuantity` number, double
    - `partialProductionQuantity` number, double
    - `isPartialProduction` boolean
    - `statusName` 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-09-06** `388b452fc6d7`: 6 info
  - added the optional property `manufacturingOrder/productDetail/isExcludedFromRequisition` to the response with the `200` status (media type: text/plain)
  - added the optional property `manufacturingOrder/productDetail/isExcludedFromRequisition` to the response with the `200` status (media type: application/json)
  - added the optional property `manufacturingOrder/productDetail/isExcludedFromRequisition` to the response with the `200` status (media type: text/json)
  - added the optional property `productDetail/isExcludedFromRequisition` to the response with the `200` status (media type: text/plain)
  - …2 more

[Operation history](https://skmtc.dev/khaasfood/apis/khaasfood-api/changes/RoutingQuery/GetRouteDetailByProductId/get.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)
