Query eBay Categories.
Table Specific Information
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'
|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 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.
|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.|