listInventories
get
/ccadmin/v1/inventories
Lists the inventories. Optionally takes the X-CCAsset-Language header to get translated content in another language.
Request
Supported Media Types
- application/json
Query Parameters
-
includeDefaultLocationInventory(optional): string
include non-geographic based inventory record in result, boolean true or false; default false
-
limit(optional): integer
This field determines the number of records to be fetched per REST call.
-
locationIds(optional): string
comma separated list of location ids to retrieve inventories for
-
offset(optional): integer
This field determines the offset/starting index from which data to be fetched.
-
productIds(optional): string
comma separated list of product ids for which to retrive inventories, valid only when type = product
-
q(optional): string
Query string built as per the SCIM standards that helps to search entered string across inventory properties like product's ???displayName??? and the childSku properties
-
showTranslations(optional): string
show translations, boolean true or false; default false
-
totalResults(optional): boolean
This field determines if the total count should be returned or not.
-
type(optional): string
inventory type, either variant or product. Defaults to variant
Header Parameters
-
X-CCAsset-Language(optional): string
asset language of the request
Response
Supported Media Types
- application/json
200 Response
When locationIds query parameter is not passed, inventory info within each childSku will appear in a flat structure.
When locationIds query parameter is passed, inventory info will appear within a 'locationInventoryInfo' JSON object within each childSku.
Root Schema : listInventories_response
Type:
Show Source
object-
example with locationIds(optional):
object example with locationIds
Result object with locationIds.
-
example without locationIds(optional):
object example without locationIds
Result object without locationIds.
Nested Schema : example with locationIds
Type:
objectResult object with locationIds.
Show Source
-
If the selected case was a product.(optional):
object If the selected case was a product.
Result object if type is product.
-
If the selected case was a variant.(optional):
object If the selected case was a variant.
Result object if type is variant.
Nested Schema : example without locationIds
Type:
objectResult object without locationIds.
Show Source
-
If the selected case was a product.(optional):
object If the selected case was a product.
Result object if type is product.
-
If the selected case was a variant.(optional):
object If the selected case was a variant.
Result object if type is variant.
Nested Schema : If the selected case was a product.
Type:
objectResult object if type is product.
Show Source
-
childSKUs(optional):
array childSKUs
List of SKU's for the product.
-
id(optional):
string
The ID of the product.
-
stockStatus(optional):
string
The current stock status of the product (inStock or outOfStock).
-
totalStockLevel(optional):
integer
The total stock level of the product.
Nested Schema : If the selected case was a variant.
Type:
objectResult object if type is variant.
Show Source
-
displayName(optional):
string
The display name of the SKU.
-
locationInventoryInfo(optional):
array locationInventoryInfo
Location specific inventory information
-
skuId(optional):
string
The SKU ID of the SKU.
-
skuNumber(optional):
string
The SKU number of the SKU.
Nested Schema : items
Type:
Show Source
object-
displayName(optional):
string
The display name of the SKU.
-
locationInventoryInfo(optional):
array locationInventoryInfo
Location specific inventory information
-
skuId(optional):
string
The SKU ID of the SKU.
-
skuNumber(optional):
string
The SKU number of the SKU.
Nested Schema : locationInventoryInfo
Type:
arrayLocation specific inventory information
Show Source
Nested Schema : items
Type:
Show Source
object-
availabilityDate(optional):
string
The date when the SKU will be available.
-
availabilityStatus(optional):
integer
The availability status of the child SKU.
-
availabilityStatusMsg(optional):
string
The current availability status of the child SKU.
-
availableToPromise(optional):
string
The available to promise of the child SKU.
-
backorderLevel(optional):
integer
The back-order level of the child SKU.
-
backorderThreshold(optional):
integer
The back-order threshold of the child SKU.
-
inventoryId(optional):
string
The inventory ID of the SKU.
-
locationId(optional):
string
The location ID of the child SKU.
-
preorderLevel(optional):
integer
The pre-order level of the child SKU.
-
preorderThreshold(optional):
integer
The pre-order threshold of the child SKU.
-
stockLevel(optional):
integer
The stock level of the SKU.
-
stockThreshold(optional):
integer
The stock threshold of the child SKU.
Nested Schema : locationInventoryInfo
Type:
arrayLocation specific inventory information
Show Source
Nested Schema : items
Type:
Show Source
object-
availabilityDate(optional):
string
The date when the SKU will be available.
-
availabilityStatus(optional):
integer
The availability status of the child SKU.
-
availabilityStatusMsg(optional):
string
The current availability status of the child SKU.
-
availableToPromise(optional):
string
The available to promise of the child SKU.
-
backorderLevel(optional):
integer
The back-order level of the child SKU.
-
backorderThreshold(optional):
integer
The back-order threshold of the child SKU.
-
inventoryId(optional):
string
The inventory ID of the SKU.
-
locationId(optional):
string
The location ID of the child SKU.
-
preorderLevel(optional):
integer
The pre-order level of the child SKU.
-
preorderThreshold(optional):
integer
The pre-order threshold of the child SKU.
-
stockLevel(optional):
integer
The stock level of the SKU.
-
stockThreshold(optional):
integer
The stock threshold of the child SKU.
Nested Schema : If the selected case was a product.
Type:
objectResult object if type is product.
Show Source
-
childSKUs(optional):
array childSKUs
List of SKU's for the product.
-
id(optional):
string
The ID of the product.
-
stockStatus(optional):
string
The current stock status of the product (inStock or outOfStock).
-
totalStockLevel(optional):
integer
The total stock level of the product.
Nested Schema : If the selected case was a variant.
Type:
objectResult object if type is variant.
Show Source
-
availabilityDate(optional):
string
The date when the SKU will be available.
-
availabilityStatus(optional):
integer
The availability status of the child SKU.
-
availabilityStatusMsg(optional):
string
The current availability status of the child SKU.
-
availableToPromise(optional):
string
The available to promise of the child SKU.
-
backorderLevel(optional):
integer
The back-order level of the child SKU.
-
backorderThreshold(optional):
integer
The back-order threshold of the child SKU.
-
displayName(optional):
string
The display name of the SKU.
-
inventoryId(optional):
string
The inventory ID of the SKU.
-
locationId(optional):
string
The location ID of the child SKU.
-
preorderLevel(optional):
integer
The pre-order level of the child SKU.
-
preorderThreshold(optional):
integer
The pre-order threshold of the child SKU.
-
skuId(optional):
string
The SKU ID of the SKU.
-
skuNumber(optional):
string
The SKU number of the SKU.
-
stockLevel(optional):
integer
The stock level of the SKU.
-
stockThreshold(optional):
integer
The stock threshold of the child SKU.
Nested Schema : items
Type:
Show Source
object-
availabilityDate(optional):
string
The date when the SKU will be available.
-
availabilityStatus(optional):
integer
The availability status of the child SKU.
-
availabilityStatusMsg(optional):
string
The current availability status of the child SKU.
-
availableToPromise(optional):
string
The available to promise of the child SKU.
-
backorderLevel(optional):
integer
The back-order level of the child SKU.
-
backorderThreshold(optional):
integer
The back-order threshold of the child SKU.
-
displayName(optional):
string
The display name of the SKU.
-
inventoryId(optional):
string
The inventory ID of the SKU.
-
locationId(optional):
string
The location ID of the child SKU.
-
preorderLevel(optional):
integer
The pre-order level of the child SKU.
-
preorderThreshold(optional):
integer
The pre-order threshold of the child SKU.
-
skuId(optional):
string
The SKU ID of the SKU.
-
skuNumber(optional):
string
The SKU number of the SKU.
-
stockLevel(optional):
integer
The stock level of the SKU.
-
stockThreshold(optional):
integer
The stock threshold of the child SKU.
Example Response (application/json)
{
"totalResults":251,
"offset":0,
"limit":250,
"links":[
{
"rel":"self",
"href":"http://www.example.com/v1/inventories?type=product&includeDefaultLocationInventory=false"
},
{
"rel":"next",
"href":"http://www.example.com/v1/inventories?type=product&includeDefaultLocationInventory=false&offset=250&limit=1"
}
],
"sort":[
{
"property":"translations.1.displayName",
"order":"asc"
}
],
"items":[
{
"childSKUs":[
{
"skuNumber":"xsku2535_1",
"displayName":"A-Line Skirt",
"locationInventoryInfo":[
{
"preorderThreshold":0,
"backorderLevel":0,
"displayName":null,
"availabilityDate":null,
"availabilityStatusMsg":"inStock",
"stockThreshold":10,
"stockLevel":120,
"availableToPromise":null,
"skuNumber":null,
"preorderLevel":0,
"locationId":"loc1",
"translations":null,
"inventoryId":null,
"backorderThreshold":0,
"availabilityStatus":1000
}
],
"skuId":"xsku2535_1"
}
],
"totalStockLevel":600,
"id":"xprod2535"
}
]
}Example Response (description)
Example response when locationIds parameter is passed in request.Default Response
The error response.
The following are the internal error codes thrown by this API when the request processing fails in Oracle Commerce Cloud:
Error Code / Description
------------------ ------------------
25100 / Internal inventory error
25101 / Missing product id
25134 / Inventory operation not supported for type
25135 / Invalid type
51003 / Invalid location id
85000 / Invalid query expression.
Root Schema : errorModel
Type:
Show Source
object-
devMessage(optional):
string
An optional non-localized message containing technical information for developers
-
errorCode(optional):
string
The numerical code identifying the error
-
errors(optional):
array errors
An optional list of errors if multiple errors were encountered
-
message(optional):
string
The localized message describing the error
-
moreInfo(optional):
string
An optional non-localized message with more information
-
o:errorPath(optional):
string
An optional machine readable description of where the error occurred
-
status(optional):
string
The HTTP status code
-
type(optional):
string
The URI to the HTTP state code definition
Nested Schema : errors
Type:
arrayAn optional list of errors if multiple errors were encountered
Show Source
Nested Schema : items
Type:
Show Source
object-
devMessage(optional):
string
An optional non-localized message containing technical information for developers
-
errorCode(optional):
string
The numerical code identifying the error
-
message(optional):
string
The localized message describing the error
-
moreInfo(optional):
string
An optional non-localized message with more information
-
o:errorPath(optional):
string
An optional machine readable description of where the error occurred
-
status(optional):
string
The HTTP status code