JDBC Driver for eBay

Build 22.0.8462

ItemAspectsForCategory

Retrieve an array of aspects that are appropriate for describing items in a specified category.

Table Specific Information

Select

The driver will use the eBay API to process WHERE clause conditions built with the following column and operator. The CategoryTreeId and CategoryId is required to make a request and the rest of the filter is executed client-side within the driver.

  • CategoryTreeId supports the '=' comparison.
  • CategoryId supports the '=' comparison.
For example:
    SELECT * FROM ItemAspectsForCategory WHERE CategoryTreeId=101 AND CategoryId=67726

Columns

Name Type Description
CategoryTreeId [KEY] String The unique identifier of the eBay category tree from which the specified category's aspects are being requested.
aspects String A list of item aspects (for example, color) that are appropriate or necessary for accurately describing items in a particular leaf category.
aspectConstraint String Information about the formatting, occurrence, and support of this aspect.
aspectApplicableTo String This value indicate if the aspect identified by the aspects.localizedAspectName field is a product aspect or an item/instance aspect.
aspectDataType String The data type of this aspect.
aspectEnabledForVariations Boolean A value of true indicates that this aspect can be used to help identify item variations.
aspectFormat String Returned only if the value of aspectDataType identifies a data type that requires specific formatting.
aspectMaxLength Integer The maximum length of the item/instance aspect's value.
aspectMode String The manner in which values of this aspect must be specified by the seller (as free text or by selecting from available options).
aspectRequired Boolean A value of true indicates that this aspect is required when offering items in the specified category.
aspectUsage String The enumeration value returned in this field will indicate if the corresponding aspect is recommended or optional.
expectedRequiredByDate String The expected date after which the aspect will be required.
itemToAspectCardinality String Indicates whether this aspect can accept single or multiple values for items in the specified category.
aspectValues String A list of valid values for this aspect (for example: Red, Green, and Blue), along with any constraints on those values.
localizedValue String The localized value of this aspect.
valueConstraints String Not returned if the value of the localizedValue field can always be selected for this aspect of the specified category.
applicableForLocalizedAspectName String The name of the control aspect on which the current aspect value depends.
applicableForLocalizedAspectValues String Contains a list of the values of the control aspect on which this aspect's value depends.
localizedAspectName String The localized name of this aspect (for example: Colour on the eBay UK site).
relevanceIndicator String The relevance of this aspect. This field is returned if eBay has data on how many searches have been performed for listings in the category using this item aspect.
searchCount Integer The number of recent searches (based on 30 days of data) for the aspect.
CategoryId String The unique identifier of an eBay category.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462