1. REST API for Oracle Commerce Cloud
  2. Tasks
  3. Store
  4. Products

listProducts

get

/ccstore/v1/products

List Products. Get a list of products. Optionally takes the x-ccasset-language headers to get translated content in another language.Also it can have optional X-CCOrganization header which is a JSON field to specify current Organization id of logged in user. None of the image URLS are encoded.

Request

Supported Media Types
Query Parameters
  • the catalog ID for the site
  • the category ID
  • flag to indicate if invalid products has to be ignored. Default value is false.
  • boolean flag defaults to false, set to true if the sku listing id is required for SKUs in the response
  • flag to include children of categories or not
  • The number of items per block
  • boolean flag defaults to false, set to true if only a price range rather than all prices are required for the response
  • startingIndex the index of the first record to load
  • the list of product IDs
  • A SCIM filter string for selecting a subset of all products. See [https://tools.ietf.org/html/draft-ietf-scim-api-12#section-3.2.2](https://tools.ietf.org/html/draft-ietf-scim-api-12#section-3.2.2)section 3.2.2.2 of the SCIM specification for details on the SCIM filter format. Examples: Get all products whose displayName contains shirt: q=displayName co "shirt" Get all products with an orderLimit between 5 and 10: q=orderLimit gt 5 and orderLimit lt 10 Text, date and time values appearing in SCIM filters should be quoted, with date and time values using ISO-8601 format. Numeric and boolean values should not be quoted. The following base product properties can be used in a q query: * CountryOfOrigin * active * avgCustRating * brand * childSKUs * defaultProductListingSku * derivedDirectCatalogs * description * displayName * height * id * length * longDescription * notForIndividualSale * orderLimit * parentCategories * relatedArticles * relatedMediaContent * type * unitOfMeasure * weight * width Additionally, custom product properties may also be used in a q query.
  • Sort Option id: Sort order
  • the price list group id for which product prices are to be returned
  • flag to include count of total products with listing variant expansion
  • flag to include count of total products without expansion
  • boolean flag defaults to true, set to false if prices are not required in the response
Header Parameters
Back to Top

Response

Supported Media Types

200 Response

Following model is returned when operation succeeds.
Body ()
Root Schema : listProducts_response
Type: object
Show Source
Nested Schema : items
Type: array
Array having various products.
Show Source
Nested Schema : sort
Type: array
Array having the order and property of product.
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : addOnProducts
Type: array
Array of AddOn products.
Show Source
Nested Schema : childSKUs
Type: array
Array having various properties of child SKU.
Show Source
Nested Schema : fullImageURLs
Type: array
Full image URLs of the product.
Show Source
Nested Schema : largeImage
Type: object
Array having repository ID and URL of the large image of SKU.
Show Source
Nested Schema : largeImageURLs
Type: array
Large image URLs of the product.
Show Source
Nested Schema : listPrices
Type: object
Object with price group IDs as keys and list prices as values.
Show Source
Nested Schema : mediumImageURLs
Type: array
Medium image URLs of the product.
Show Source
Nested Schema : productImages
Type: array
Array of product images.
Show Source
Nested Schema : productVariantOptions
Type: array
Objects containing product's variant options details if available for the product.
Show Source
Nested Schema : salePrices
Type: object
Object with price group IDs as keys and sale prices as values.
Show Source
Nested Schema : shippingSurcharges
Type: object
Object with price group IDs as keys and shipping surcharges as values.
Show Source
Nested Schema : smallImage
Type: object
Array having repository ID and URL of small image of the SKU.
Show Source
Nested Schema : sourceImageURLs
Type: array
Source image URLs of the product.
Show Source
Nested Schema : thumbImageURLs
Type: array
Thumb image URLs of the product.
Show Source
Nested Schema : items
Type: object
AddOn product.
Show Source
Nested Schema : configurationOptions
Type: array
Array of configuration options.
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : product
Type: object
Product Details
Show Source
Nested Schema : sku
Type: object
Sku Details
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : configurationMetadata
Type: array
Array of configuration attributes associated with the SKU.
Show Source
Nested Schema : fullImageURLs
Type: array
Full Image URLs of SKU.
Show Source
Nested Schema : largeImageURLs
Type: array
Large Image URLs of SKU.
Show Source
Nested Schema : mediumImageURLs
Type: array
Medium Image URLs SKU.
Show Source
Nested Schema : shippingSurcharges
Type: object
Extra handling costs for shipping the product in respective price list groups
Show Source
  • Extra handling costs for shipping the product in plg1
  • Extra handling costs for shipping the product in plg2
Nested Schema : smallImageURLs
Type: array
Small Image URLs of SKU.
Show Source
Nested Schema : sourceImageURLs
Type: array
Source Image URLs of SKU.
Show Source
Nested Schema : thumbImageURLs
Type: array
Thumb Image URLs of SKU.
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : metadata
Type: object
Seo meta info for product.
Show Source
Nested Schema : tags
Type: array
The array of product image tags
Show Source
Nested Schema : items
Type: object
Show Source
Nested Schema : optionValueMap
Type: object
Additional Properties Allowed
Show Source
mapping of all option values with corresponding option value ids
Show Source
Nested Schema : items
Type: object
Show Source
Example Response (application/json)
{
    "total":92,
    "totalResults":92,
    "totalExpandedResults":92,
    "limit":250,
    "sort":[
        {
            "property":"displayName",
            "order":"asc"
        }
    ],
    "items":[
        {
            "longDescription":"It's Samantha Baker's Sweet Sixteen and no one in her family remembers\n                the important occasion. John Hughes, the writer of National Lampoon's Vacation, shows how coming-of-age\n                can be full of surprises in this warm-hearted teenage comedy starring Molly Ringwald. She's your average\n                teen, enduring creepy freshmen, spoiled siblings, confused parents and the Big Blonde on Campus who\n                stands between her and the boy of her dreams. But wait...the day isn't over yet! This sparkling film\n                features a dynamic score, and outstanding performances by Paul Dooley, Emmy winner Blanche Baker and\n                Oscar nominee Justin Henry.\n            ",
            "primaryThumbImageURL":"/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=100&width=100",
            "largeImage":null,
            "smallImage":null,
            "nonreturnable":false,
            "displayName":"16 Candles",
            "orderLimit":null,
            "description":"A really great movie that you should not miss.",
            "onlineOnly":true,
            "primaryFullImageURL":"/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg",
            "listPrices":null,
            "salePrices":null,
            "productVariantOptions":[
                {
                    "listingVariant":false,
                    "optionValueMap":{
                        "Silver":1,
                        "Neon":2,
                        "Black":0
                    },
                    "variantBasedDisplay":false,
                    "optionId":"color",
                    "mapKeyPropertyAttribute":"sku-camcorder_color",
                    "optionName":"color"
                }
            ],
            "largeImageURLs":[
                "/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=940&width=940"
            ],
            "primaryLargeImageURL":"/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=940&width=940",
            "addOnProducts":[
                {
                    "repositoryId":"cp10003",
                    "addOnOptions":[
                        {
                            "product":{
                                "displayName":"Birthday Gift Wrap",
                                "repositoryId":"BirthdayGiftWrap",
                                "active":true
                            },
                            "repositoryId":"co10005",
                            "sku":{
                                "displayName":"option1",
                                "repositoryId":"option1",
                                "active":true
                            }
                        },
                        {
                            "product":{
                                "displayName":"Birthday Gift Wrap",
                                "repositoryId":"BirthdayGiftWrap",
                                "active":true
                            },
                            "repositoryId":"co10006",
                            "sku":{
                                "displayName":"option2",
                                "repositoryId":"option2",
                                "active":true
                            }
                        }
                    ]
                }
            ],
            "derivedShippingSurchargeFrom":"defaultPriceGroup",
            "smallImageURLs":[
                "/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=300&width=300"
            ],
            "derivedSalePriceFrom":"defaultPriceGroup",
            "shippingSurcharges":null,
            "id":"Product_19Cxy",
            "childSKUs":[
                {
                    "dynamicPropertyMapLong":{
                    },
                    "primaryThumbImageURL":null,
                    "largeImage":null,
                    "smallImage":null,
                    "nonreturnable":false,
                    "listPrices":null,
                    "salePrices":null,
                    "primaryFullImageURL":null,
                    "configurationMetadata":[
                    ],
                    "productListingSku":null,
                    "largeImageURLs":[
                    ],
                    "primaryLargeImageURL":null,
                    "derivedOnlineOnly":true,
                    "derivedShippingSurchargeFrom":"defaultPriceGroup",
                    "smallImageURLs":[
                    ],
                    "derivedSalePriceFrom":"defaultPriceGroup",
                    "shippingSurcharges":{
                        "defaultPriceGroup":null
                    },
                    "thumbnailImage":null,
                    "salePriceEndDate":null,
                    "salePriceStartDate":null,
                    "images":[
                    ],
                    "salePrice":4.99,
                    "primaryMediumImageURL":null,
                    "fullImageURLs":[
                    ],
                    "active":true,
                    "thumbImageURLs":[
                    ],
                    "mediumImageURLs":[
                    ],
                    "derivedListPriceFrom":"defaultPriceGroup",
                    "repositoryId":"Sku_19Dxy",
                    "DynamicSkuProperty2":"value2",
                    "shippingSurcharge":null,
                    "primarySourceImageURL":null,
                    "DynamicSkuProperty1":"value1",
                    "primarySmallImageURL":null,
                    "sourceImageURLs":[
                    ],
                    "listPrice":12.99
                },
                {
                    "dynamicPropertyMapLong":{
                    },
                    "salePriceStartDate":null,
                    "largeImage":null,
                    "smallImage":null,
                    "salePrice":null,
                    "nonreturnable":false,
                    "active":true,
                    "listPrices":null,
                    "salePrices":null,
                    "configurationMetadata":[
                    ],
                    "derivedShippingSurchargeFrom":"defaultPriceGroup",
                    "derivedSalePriceFrom":"defaultPriceGroup",
                    "derivedListPriceFrom":"defaultPriceGroup",
                    "repositoryId":"Sku_19Dxyi",
                    "shippingSurcharges":{
                        "defaultPriceGroup":null
                    },
                    "shippingSurcharge":null,
                    "thumbnailImage":null,
                    "salePriceEndDate":null,
                    "listPrice":null
                },
                {
                    "dynamicPropertyMapLong":{
                    },
                    "salePriceStartDate":null,
                    "largeImage":null,
                    "smallImage":null,
                    "salePrice":8.99,
                    "nonreturnable":false,
                    "active":true,
                    "listPrices":null,
                    "salePrices":null,
                    "configurationMetadata":[
                    ],
                    "derivedShippingSurchargeFrom":"defaultPriceGroup",
                    "derivedSalePriceFrom":"defaultPriceGroup",
                    "derivedListPriceFrom":"defaultPriceGroup",
                    "repositoryId":"Sku_19Dxyii",
                    "shippingSurcharges":{
                        "defaultPriceGroup":null
                    },
                    "shippingSurcharge":null,
                    "thumbnailImage":null,
                    "salePriceEndDate":null,
                    "listPrice":19.99
                }
            ],
            "lastModifiedDate":"2023-01-31T05:10:45.075Z",
            "salePrice":8.99,
            "primaryMediumImageURL":"/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=475&width=475",
            "fullImageURLs":[
                "/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg"
            ],
            "active":true,
            "thumbImageURLs":[
                "/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=100&width=100"
            ],
            "creationDate":"2014-10-27T05:11:57.034Z",
            "variantValuesOrder":{
                "color":[
                    "Spring Green",
                    "Cranberry",
                    "Marigold"
                ],
                "size":[
                    "Small",
                    "Large",
                    "Medium"
                ]
            },
            "route":"/16-candles/product/Product_19Cxy",
            "mediumImageURLs":[
                "/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=475&width=475"
            ],
            "derivedListPriceFrom":"defaultPriceGroup",
            "repositoryId":"Product_19Cxy",
            "primarySourceImageURL":"/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=300&width=300",
            "shippingSurcharge":20,
            "primarySmallImageURL":"/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=300&width=300",
            "sourceImageURLs":[
                "/ccstore/v1/images/?source=http://localhost:8080/file/qaimg/products/sixteen_candles_LARGE.jpg&height=300&width=300"
            ],
            "minOrderLimit":1,
            "avgCustRating":4.5,
            "listPrice":19.99
        }
    ]
}

Default Response

The error response
Body ()
Root Schema : errorModel
Type: object
Show Source
Nested Schema : errors
Type: array
An optional list of errors if multiple errors were encountered
Show Source
Nested Schema : items
Type: object
Show Source
Back to Top