CategoryTree

Retrieve the complete category tree corresponding to a specified category tree ID.

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.

For example:

    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 list of one or more identifiers of the eBay marketplaces that use this category tree.
rootCategoryNode	String	Contains details of all nodes of the category tree hierarchy, starting with the root node and down to the leaf nodes.
category	String	Contains details about the current category tree node.
categoryId	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.
childCategoryTreeNodes	String	An array of one or more category tree nodes that are the immediate children of the current category tree node, as well as their children, recursively down to the leaf nodes.
category	String	Contains details about the current category tree node.
categoryId	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.
childCategoryTreeNodes	String	An array of one or more category tree nodes that are the immediate children of the current category tree node, as well as their children, recursively down to the leaf nodes.
category	String	Contains details about the current category tree node.
categoryId	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.
childCategoryTreeNodes	String	An array of one or more category tree nodes that are the immediate children of the current category tree node, as well as their children, recursively down to the leaf nodes.
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, which are identified by the childCategoryTreeNodes array.
parentCategoryTreeNodeHref	String	The href portion of the getCategorySubtree call that retrieves the subtree below the parent of this category tree node.
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, which are identified by the childCategoryTreeNodes array.
parentCategoryTreeNodeHref	String	The href portion of the getCategorySubtree call that retrieves the subtree below the parent of this category tree node.
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, which are identified by the childCategoryTreeNodes array.
parentCategoryTreeNodeHref	String	The href portion of the getCategorySubtree call that retrieves the subtree below the parent of this category tree node.

Power BI Connector for eBay

CategoryTree

Table Specific Information

Select

Columns