CategorySuggestions
Return an array of suggested categories that eBay has determined correspond to keywords that describe an item.
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 Q is required to make a request and the rest of the filter is executed client-side within the connector.
- CategoryTreeId supports the '=' comparison.
- Q supports the '=' comparison.
SELECT * FROM CategorySuggestions WHERE CategoryTreeId = 0 AND Q = 'iphone'
Columns
| Name | Type | Description |
| CategoryTreeId [KEY] | String | The unique identifier of the eBay category tree from which suggestions are returned. |
| categoryTreeVersion | String | The version of the category tree identified by categoryTreeId. |
| categorySuggestions | String | Contains details about one or more suggested categories that correspond to the provided keywords. |
| category | String | Contains details about the suggested category. |
| categoryId | String | The unique identifier of the eBay category within its category tree. |
| categoryName | String | The name of the category identified by categoryId. |
| categoryTreeNodeAncestors | String | An ordered list of category references that describes the location of the suggested category in the specified category tree. |
| categoryId | String | The unique identifier of the eBay ancestor category. |
| categoryName | String | The name of the ancestor category identified by categoryId. |
| categorySubtreeNodeHref | String | The href portion of the getCategorySubtree call that retrieves the subtree below the ancestor category node. |
| categoryTreeNodeLevel | String | The absolute level of the ancestor category node in the hierarchy of its category tree. |
| categoryTreeNodeLevel | Integer | The absolute level of the category tree node in the hierarchy of its category tree. |
| relevancy | String | This field is reserved for internal or future use. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Q | String | A quoted string that describes or characterizes the item being offered for sale. |