Power BI Connector for eBay

Build 24.0.9063

CategoryTree

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

Table Specific Information

Select

The 本製品 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 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063