API Catalog

Retrieve Inventory Items By Code

06 Jan 2026
1 Minute to read

Print
Dark
Light

Retrieve Inventory Items By Code

Updated on 06 Jan 2026
1 Minute to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback!

Get

/ci-rest-api/rest/2/ciitem

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

Select by Code
Select by Date
By UUID

Select by Code

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
CompCode	Company Code	001
AuditDate	Audit Date	2016-01-01
ItemCode	Item Code	V243C20A

Select by Date

This is an optional finder for querying Inventory Items by Audit Date, and Item Code.

Parameter	Description	Sample
AuditDate	Audit Date	2016-01-01
ItemCode	Item Code	V243C20A

By UUID

This is an optional finder for querying a specific Inventory Item by row ID.

Parameter	Description	Sample
/VUUID	The VUuid attribute is the Unique row ID	/ci-rest-api/rest/1/ciitem/BEB07FE2D8A0410AE05316821FAC48A5

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectByCode;CompCode=ZZ, AuditDate=2016-12-24, ItemCode=BD538

limit

integer

Example250

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleCiitemVUuid

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [],
  "totalResults": 0,
  "count": 0,
  "hasMore": false,
  "limit": 250,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://solutionsr12mob.cmicpaas.com:80/cmicprod/ci-rest-api/rest/1/ciitem",
      "name": "ciitem",
      "kind": "collection"
    }
  ]
}

object

"{\n    \"items\": [\n        {\n            \"CiitemAdjAccCode\": \"1700.300\",\n            \"CiitemAffilRevAccCode\": \"4000.700\",\n            \"CiitemAllowNegQtyFlag\": \"Y\",\n            \"CiitemAltWmAllowFlag\": \"N\",\n            \"CiitemBbPriceOrPctCode\": \"P\",\n            \"CiitemBuybackPriceAmt\": null,\n            \"CiitemCmpFlag\": \"N\",\n            \"CiitemCompCode\": \"ZZ\",\n            \"CiitemCostMethCode\": \"AVG\",\n            \"CiitemCostUpdateLevelCode\": \"I\",\n            \"CiitemCreditJcCatCode\": null,\n            \"CiitemCustRevAccCode\": \"4000.700\",\n            \"CiitemDefaultItemTypeCode\": null,\n            \"CiitemDefaultLocCode\": null,\n            \"CiitemEmCostComponCode\": null,\n            \"CiitemInvAccCode\": \"1700.100\",\n            \"CiitemInventoryItemCode\": null,\n            \"CiitemItemClassCode\": \"OFFI\",\n            \"CiitemItemCode\": \"BD26\",\n            \"CiitemItemDesc\": null,\n            \"CiitemItemName\": \"Black Desk 2026\",\n            \"CiitemIuCreateDate\": \"2023-10-18T16:49:07-04:00\",\n            \"CiitemIuUpdateDate\": null,\n            \"CiitemMarketPriceAmt\": null,\n            \"CiitemMaxOnhandQty\": null,\n            \"CiitemMaxOrderQty\": null,\n            \"CiitemMinOnhandQty\": null,\n            \"CiitemMinOrderQty\": null,\n            \"CiitemMsAvailableFlag\": \"N\",\n            \"CiitemPartialDasmblFlag\": \"N\",\n            \"CiitemProdFlag\": \"N\",\n            \"CiitemRestockPriceAmt\": null,\n            \"CiitemRevAccCode\": \"4000.700\",\n            \"CiitemRtrnFlag\": \"N\",\n            \"CiitemSalesProductFlag\": \"N\",\n            \"CiitemSalesTax1Code\": \"01\",\n            \"CiitemSalesTax2Code\": null,\n            \"CiitemSalesTax3Code\": null,\n            \"CiitemSellPriceAmt\": null,\n            \"CiitemSellPriceOrPctCode\": \"P\",\n            \"CiitemSerialFlag\": \"N\",\n            \"CiitemSoldAtCostAccCode\": \"4000.701\",\n            \"CiitemStdOnhandQty\": null,\n            \"CiitemStdOrderQty\": null,\n            \"CiitemSuspAccCode\": \"1700.400\",\n            \"CiitemTax1Code\": \"01\",\n            \"CiitemTax2Code\": null,\n            \"CiitemTax3Code\": null,\n            \"CiitemVUuid\": \"0804C54476753541E063AF811DAC8646\",\n            \"CiitemVarAccCode\": \"1700.500\",\n            \"CiitemWmCode\": \"CA\",\n            \"CiitemWriAccCode\": \"1700.200\",\n            \"links\": [\n                {\n                    \"rel\": \"self\",\n                    \"href\": \"https://dev6v12.cmic.ca:9999/cmicdevv12/ci-rest-api/rest/2/ciitem/0804C54476753541E063AF811DAC8646\",\n                    \"name\": \"ciitem\",\n                    \"kind\": \"item\"\n                },\n                {\n                    \"rel\": \"canonical\",\n                    \"href\": \"https://dev6v12.cmic.ca:9999/cmicdevv12/ci-rest-api/rest/2/ciitem/0804C54476753541E063AF811DAC8646\",\n                    \"name\": \"ciitem\",\n                    \"kind\": \"item\"\n                }\n            ]\n        }\n    ],\n    \"totalResults\": 1,\n    \"count\": 1,\n    \"hasMore\": false,\n    \"limit\": 250,\n    \"offset\": 0,\n    \"links\": [\n        {\n            \"rel\": \"self\",\n            \"href\": \"https://dev6v12.cmic.ca:9999/cmicdevv12/ci-rest-api/rest/2/ciitem\",\n            \"name\": \"ciitem\",\n            \"kind\": \"collection\"\n        }\n    ]\n}"

string

What's Next

Update a Specific Inventory Item

Retrieve Inventory Items By Code

Query Standards

Finder

Select by Code

Select by Date

By UUID

What's Next

Contact Us