ODBC Driver for eBay

Build 24.0.9063

CategorySuggestions

Return an array of suggested categories that eBay has determined correspond to keywords that describe an item.

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 Q is required to make a request and the rest of the filter is executed client-side within the 本製品.

  • CategoryTreeId supports the '=' comparison.
  • Q supports the '=' comparison.
For example:
    SELECT * FROM CategorySuggestions WHERE CategoryTreeId = 0 AND Q = 'iphone'
	

Columns

Name Type Description
CategoryTreeId [KEY] String The unique identifier of the eBay category tree from which suggestions are returned.
categoryTreeVersion String The version of the category tree identified by categoryTreeId.
categorySuggestions String Contains details about one or more suggested categories that correspond to the provided keywords.
category String Contains details about the suggested category.
categoryId String The unique identifier of the eBay category within its category tree.
categoryName String The name of the category identified by categoryId.
categoryTreeNodeAncestors String An ordered list of category references that describes the location of the suggested category in the specified category tree.
categoryId String The unique identifier of the eBay ancestor category.
categoryName String The name of the ancestor category identified by categoryId.
categorySubtreeNodeHref String The href portion of the getCategorySubtree call that retrieves the subtree below the ancestor category node.
categoryTreeNodeLevel String The absolute level of the ancestor category node in the hierarchy of its category tree.
categoryTreeNodeLevel Integer The absolute level of the category tree node in the hierarchy of its category tree.
relevancy String This field is reserved for internal or future use.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Q String A quoted string that describes or characterizes the item being offered for sale.

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