List Item Inventory by Quality

Retrieves inventory details for items based on specified quality attributes.

Retrieve inventory data from Xorosoft ERP using the supported query filters. Use this endpoint to synchronize reference or transaction data with external systems while respecting private app permissions.

get

Authorizations

AuthorizationstringRequired

Query parameters

product_idstringOptional

A comma-separated list of product ids.

item_idstringOptional

A comma-separated list of item ids.

base_part_numberstringOptional

A comma-separated list of base part numbers.

item_numberstringOptional

A comma-separated list of item numbers.

quality_codestringOptional

A comma-separated list of quality codes.

quality_namestringOptional

A comma-separated list of quality names.

account3pl_idstringOptional

3PL account identifier.

Responses

200

OK

application/json

IsForwardRequestbooleanOptional

MessagestringOptional

MessageTitlestring · nullableOptional

ResultbooleanOptional

get/api/xerp/inventory/getiteminventorybyquality

GET /api/xerp/inventory/getiteminventorybyquality HTTP/1.1
Host: res.xorosoft.io
Authorization: Basic username:password
Accept: */*

200

OK

{
  "Data": [
    {
      "Account3plCode": "PRA",
      "Account3plName": "PRANA",
      "AlternativeItemNumber1": "1970801-500-L",
      "AlternativeItemNumber2": null,
      "AlternativeItemNumber3": null,
      "AvailableQty": 1,
      "BasePartNumber": "1970801",
      "BrandId": 15,
      "BrandName": "Prana",
      "CategoryId": 37,
      "CategoryName": "Apparel 1 - Light Weight",
      "CustomFieldValue1": "PRA",
      "CustomFieldValue15": "in",
      "Description": "Womens Becksa Short",
      "ItemId": 143053,
      "ItemNumber": "889760998846",
      "ItemUpc": "889760998846",
      "NotAvailableQty": 0,
      "OnHandQty": 1,
      "Option1Code": "500",
      "Option1Name": "Color",
      "Option1Value": "Morning Glory Heather",
      "Option2Code": "L",
      "Option2Name": "Size",
      "Option2Value": "L",
      "Option3Code": null,
      "Option3Name": null,
      "Option3Value": null,
      "ProductCategoryId": null,
      "ProductCategoryName": null,
      "ProductId": 19980,
      "QualityCode": "PRA-FRST",
      "QualityId": 10,
      "QualityName": "PRA - First Quality / New Inventory",
      "StoreName": "HQ1-OLD",
      "SubCategoryId": 20,
      "SubCategoryName": "Shorts"
    }
  ],
  "IsForwardRequest": false,
  "Message": "Inventory data loaded successfully.",
  "MessageTitle": null,
  "Result": true
}