JDBC Driver for eBay

Build 22.0.8462

CategorySuggestions

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

Table Specific Information

Select

The driver 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 driver.

  • 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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462