CategoryTree
Retrieve the complete category tree corresponding to a specified category tree ID, with one row returned for every node in the tree.
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 is required to make a request and the rest of the filter is executed client-side within the connector.
- CategoryTreeId supports the '=' comparison.
SELECT * FROM CategoryTree WHERE CategoryTreeId = 0
Columns
| Name | Type | Description |
| CategoryTreeId [KEY] | String | The unique identifier of the eBay category tree for the specified marketplace. |
| CategoryTreeVersion | String | The version of the category tree identified by categoryTreeId. |
| ApplicableMarketplaceIds | String | A comma-separated list of one or more identifiers of the eBay marketplaces that use this category tree. |
| CategoryId [KEY] | String | The unique identifier of the eBay category within its category tree. |
| CategoryName | String | The name of the category identified by categoryId. |
| CategoryTreeNodeLevel | Integer | The absolute level of the current category tree node in the hierarchy of its category tree. |
| ParentCategoryTreeNodeHref | String | The unique identifier of the parent of the current category tree node, extracted from the href of the getCategorySubtree call that retrieves its subtree. NULL for the root node, which has no parent. |
| LeafCategoryTreeNode | Boolean | A value of true indicates that the current category tree node is a leaf node (it has no child nodes). A value of false indicates that the current node has one or more child nodes. |