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.