ItemAspectsForCategory
Retrieve an array of aspects that are appropriate for describing items in a specified category.
Table Specific Information
Select
The connector 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 connector.
- 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. |