CategorySubtree

Retrieve all nodes of the category tree hierarchy (the subtree) below a specified category in a specified category 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 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.

For example:

    SELECT * FROM CategorySubtree WHERE CategoryTreeId = 0 AND CategoryId = 11450

Columns


Name	Type	Description
CategoryTreeId [KEY]	String	The unique identifier of the eBay category tree to which this subtree belongs.
categoryTreeVersion	String	The version of the category tree identified by categoryTreeId.
categorySubtreeNode	String	Contains details of all nodes of the category subtree hierarchy below a specified node. This is a recursive structure.
category	String	Contains details about the current category tree node.
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.
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.
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.
CategoryId	String	The unique identifier of the category at the top of the subtree being requested.

Power BI Connector for eBay

CategorySubtree

Table Specific Information

Select

Columns