ODBC Driver for eBay

Build 24.0.8963

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

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

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