ODBC Driver for eBay

Build 20.0.7587

Categories

Query eBay Categories.

Table Specific Information

Select

The only columns supported for filtering are CategorySiteId, LevelLimit, and CategoryParentId.

SELECT * FROM Categories.
You can return more information about a specific category and its subcategories with the following query:
SELECT * FROM Categories WHERE LevelLimit = '2' AND CategoryParent = '267'

Columns

Name Type Description
CategoryId [KEY] String This string value is the unique identifier of an eBay category.
AutoPayEnabled Boolean Specifies that the corresponding category supports immediate payment for listings.
B2BVATEnabled Boolean Specifies that the corresponding category supports business-to-business (B2B) VAT listings. This feature is applicable to the eBay Germany (DE), Austria (AT), and Switzerland (CH) sites only.
BestOfferEnabled Boolean Specifies that the corresponding category supports Best Offers.
CategoryLevel Integer This integer value indicates the level where the category fits in the category hierarchy of the eBay site. For example, if this field has a value of 2, then the category is two levels below the root category.
CategoryName String This string value is the display name of the eBay primary category, as it would appear on the eBay website.
CategoryParentId String This string value is the category Id of the parent category of the primary category indicated in the CategoryId field.
Expired Boolean Specifies that the corresponding category is no longer a valid eBay category on the site, and items may not be listed in this category.
LeafCategory Boolean Specifies that the corresponding category is an eBay leaf category, a category in which items may be listed.
LSD Boolean Lot Size Disabled. Specifies that the corresponding category does not support lot listings. A lot listing is a listing that features multiple related items that must be purchased by one buyer in one transaction.
ORPA Boolean Override Reserve Price Allowed: Specifies that the corresponding category is an exception to the standard Reserve Price policy on auction listings for the eBay site.
ORRA Boolean Override Reduce Reserve Allowed: Specifies that the corresponding category is an exception to the standard Reduce Reserve Price (on active auction listing) policy.
Virtual Boolean Specifies that the corresponding category is an eBay virtual category, a category in which items may not be listed.

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
CategorySiteId String The Id of the U.S. eBay site for the category.
LevelLimit String Specifies the maximum depth of the category hierarchy to retrieve, where the top-level categories (metacategories) are at level 1. If not specified, categories are retrieved at all applicable levels.
ViewAllNodes String This value controls whether all eBay categories or only leaf categories that satisfy any WHERE clause restrictions are returned. You can only list items in leaf categories. The default value is true.
DetailLevel String Detail levels are instructions that define subsets of data to return for particular tables. Possible values: ItemReturnAttributes, ItemReturnCategories, ItemReturnDescription, ReturnAll, ReturnHeaders, ReturnMessages, and ReturnSummary.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587