ItemAspectsForCategory
Retrieve an array of aspects that are appropriate for describing items in a specified category.
Table Specific Information
Select
The add-in 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 add-in.
- CategoryTreeId supports the '=' comparison.
- CategoryId supports the '=' comparison.
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. |