CategoryProductAssignmentSearch resource (Data API 23.2)

Summary

Http Method Resource Description
POST /catalogs/{catalog_id}/categories/{category_id}/category_product_assignment_search

Searches for category product assignments.

The query attribute specifies a complex query that can be used to narrow down the search. This is the list of searchable attributes:

  • product_id - String
  • product_name - String
  • online_flag - Boolean
  • searchable - Boolean
  • valid_from - DateTime
  • valid_to - DateTime
  • creation_date - DateTime

Sortable Fields:

  • product_id - String
  • product_name - String
  • position - Double
  • creation_date - DateTime

Expansions that can be applied for the search request:

  • product_base - String - This expand will enable retrieval of the following basic Product information:
  • product_images - String - to fetch preview image and image groups specified for the given product
  • product_all_images - String - to fetch preview image and image groups specified for the product plus images for its variants and variation groups
  • product_variations - String to fetch variations related information, version 17.8+
  • product_availability - String to fetch availability related information, version 17.8+
  • product_categories - String to fetch category related information, version 17.8+
  • product_prices - String to fetch prices related information, version 17.8+
  • product_options - String to fetch options related information, version 17.8+
  • product_all - String to fetch all expanded information, version 17.8+

    • brand
    • ean
    • link
    • long_description
    • manufacturer_name
    • manufacturer_sku
    • name
    • page_description
    • page_keywords
    • page_title
    • searchable
    • short_description
    • type
    • unit
    • upc

Search Category Product Assignment

Searches for category product assignments.

The query attribute specifies a complex query that can be used to narrow down the search. This is the list of searchable attributes:

  • product_id - String
  • product_name - String
  • online_flag - Boolean
  • searchable - Boolean
  • valid_from - DateTime
  • valid_to - DateTime
  • creation_date - DateTime

Sortable Fields:

  • product_id - String
  • product_name - String
  • position - Double
  • creation_date - DateTime

Expansions that can be applied for the search request:

  • product_base - String - This expand will enable retrieval of the following basic Product information:
  • product_images - String - to fetch preview image and image groups specified for the given product
  • product_all_images - String - to fetch preview image and image groups specified for the product plus images for its variants and variation groups
  • product_variations - String to fetch variations related information, version 17.8+
  • product_availability - String to fetch availability related information, version 17.8+
  • product_categories - String to fetch category related information, version 17.8+
  • product_prices - String to fetch prices related information, version 17.8+
  • product_options - String to fetch options related information, version 17.8+
  • product_all - String to fetch all expanded information, version 17.8+

    • brand
    • ean
    • link
    • long_description
    • manufacturer_name
    • manufacturer_sku
    • name
    • page_description
    • page_keywords
    • page_title
    • searchable
    • short_description
    • type
    • unit
    • upc

Url

POST https://hostname:port/dw/data/v23_2/catalogs/{catalog_id}/categories/{category_id}/category_product_assignment_search?site_id={String}

Formats

json, xml

Authentication

Name Description
OAuth Authentication via OAuth token.

Request Document

CategoryProductAssignmentSearchRequest

Response Document

CategoryProductAssignmentSearchResult

Path Parameters

Parameter Type Description Constraints
catalog_id String The id of the catalog. minLength=1
category_id String The id of the category. minLength=1

Query Parameters

Parameter Type Description Constraints
site_id String The site context.  

In case of a failure Fault Document is returned.

Faults

Status Type Arguments Description
400 MalformedSearchParameterException   Thrown if the query is ill-formed.
404 CategoryNotFoundException

catalogId (String)

categoryId (String)

Thrown if the category does not exist matching the given catalog_id.
404 CatalogNotFoundException

catalogId (String)

Thrown if the catalog does not exist matching the given category_id.

Sample

REQUEST:
POST /s/-/dw/data/v23_2/catalogs/SampleCatalog/categories/SampleCategory/category_product_assignment_search HTTP/1.1
Host: example.com
Authorization: Bearer a5b6eb0d-8312-41a3-88f3-2c53c4507367
Accept: application/json

{
    "query":
         {"text_query": { "fields": ["product_id"], "search_phrase": "sample_product"} },
           "select": "(**)",
            "expand": ["product_base"]
         },
        "select" : "(**)"
}

RESPONSE:
HTTP/1.1 200 OK
Content-Length: 67
Content-Type: application/json; charset=UTF-8
{
  {
   "_v" : "23.2",
   "_type" : "category_product_assignment_search_result",
   "count" : 2,
   "hits" : 
   [
      
      {
         "_type" : "category_product_assignment",
         "_resource_state" : "860cde3040519cce439cd99e209f8a87c3ad0b7e2813edbf6f5501f763b73bd5",
         "catalog_id" : "SampleCatalog",
         "category_id" : "SampleCategory",
         "link" : "https://example.com/s/-/dw/data/v23_2/catalogs/SampleCatalog/category_product_assignments/SampleCategory/sample_product1",
         "owning_catalog_name" : 
         {
            "default" : "Apparel Main Catalog"
         },
         "position" : 1.0,
         "product" : 
         {
            "_type" : "product",
            "id" : "sample_product",
            "link" : "https://example.com/s/-/dw/data/v23_2/products/sample_product1",
            "long_description" : 
            {
               "default" : "We took this classic crew neck and updated it with jewels and embroidery."
            },
            "name" : 
            {
               "default" : "Long Sleeve Appliqued Crew Neck"
            },
            "online" : true,
            "page_description" : 
            {
               "default" : "We took this classic crew neck and updated it with jewels and embroidery."
            },
            "page_title" : 
            {
               "default" : "Long Sleeve Appliqued Crew Neck"
            },
            "searchable" : true,
            "short_description" : 
            {
               "default" : "We took this classic crew neck and updated it with jewels and embroidery."
            },
            "type" : 
            {
               "_type" : "product_type",
               "variant" : true
            },
            "upc" : "701642824237"
         },
         "product_id" : "sample_product1"
      },
      {
         "_type" : "category_product_assignment",
         "_resource_state" : "y4ad025da50d1af6cac62e86de2b13def45ead81ffb01c407dad2dc4bfd438kl",
         "catalog_id" : "SampleCatalog",
         "category_id" : "SampleCategory",
         "link" : "https://example.com/s/-/dw/data/v23_2/catalogs/SampleCatalog/category_product_assignments/SampleCategory/sample_product2",
         "owning_catalog_name" : 
         {
            "default" : "Apparel Main Catalog"
         },
         "position" : 2.0,
         "product" : 
         {
            "_type" : "product",
            "id" : "008884304023",
            "link" : "https://example.com/s/-/dw/data/v23_2/products/sample_product2",
            "long_description" : 
            {
               "default" : "Love our easy care solid shirting? Then give our stripes a try! This subtle blue stripe is a nice option to have in your closet for workplace wear and it even has a bit of stretch for extra comfort."
            },
            "name" : 
            {
               "default" : "Platinum Blue Stripes Easy Care Fitted Shirt "
            },
            "online" : true,
            "page_description" : 
            {
               "default" : "Love our easy care solid shirting? Then give our stripes a try! This subtle blue stripe is a nice option to have in your closet for workplace wear and it even has a bit of stretch for extra comfort."
            },
            "page_title" : 
            {
               "default" : "Platinum Blue Stripes Easy Care Fitted Shirt "
            },
            "searchable" : true,
            "short_description" : 
            {
               "default" : "Love our easy care solid shirting? Then give our stripes a try! This subtle blue stripe is a nice option to have in your closet for workplace wear and it even has a bit of stretch for extra comfort."
            },
            "type" : 
            {
               "_type" : "product_type",
               "variant" : true
            },
            "upc" : "008884304023"
        },
         "product_id" : "sample_product2"
      },
  ],
  "query" : { "text_query": { "fields": ["id"], "search_phrase": "sample_product" } },
  "select": "**",
  "start" : 0,
  "total" : 2
}

# in case of failure:
 
RESPONSE:
HTTP/1.1 404 Not Found
Expires: Thu, 01-Jan-1970 00:00:00 GMT
Content-Type: application/json;charset=UTF-8
Cache-Control: max-age=0,no-cache,no-store,must-revalidate
{
   "_v" : "23.2",
   "fault" : 
   {
      "type" : "CatalogNotFoundException",
      "message" : "No catalog with ID 'SampleCatalog' was found."
   }
}

RESPONSE:
HTTP/1.1 404 Not Found
Expires: Thu, 01-Jan-1970 00:00:00 GMT
Content-Type: application/json;charset=UTF-8
Cache-Control: max-age=0,no-cache,no-store,must-revalidate
{
   "_v" : "23.2",
   "fault" : 
   {
      "type" : "CategoryNotFoundException",
      "message" : "No category with ID 'SampleCategory' for catalog 'SampleCatalog' was found."
   }
}

RESPONSE:
HTTP/1.1 404 Not Found
Expires: Thu, 01-Jan-1970 00:00:00 GMT
Content-Type: application/json;charset=UTF-8
Cache-Control: max-age=0,no-cache,no-store,must-revalidate
{
   "_v" : "23.2",
   "fault" : 
   {
      "type" : "SiteNotFoundException",
      "message" : "No site with ID 'nonexisting' was found."
   }
}
X OCAPI versions 15.x and 16.x will be retired on March 31, 2021. For dates and more information, see the OCAPI versioning and deprecation policy and this Knowledge Article.