ODBC Driver for eBay

Build 20.0.7587

MostWatchedItems

Query items with the highest watch counts for the entire site or for a specific category. The top items are determined by the Watch Count totals from the preceding day. Ranking of the Most Watched Items is calculated with the latest Watch Count information.

Table Specific Information

Select

The only columns that can be used to filter are CategoryId, AffiliateCustomId, AffiliateNetworkId, and AffiliateTrackingId. These filters are optional.

SELECT * FROM MostWatchedItems

SELECT * FROM MostWatchedItems WHERE CategoryId = '277' 

Columns

Name Type Description
ItemId [KEY] String The Id that uniquely identifies the item listing. The Id is generated by eBay after an item is listed.
Title String Name of the item as it appears in the listing or search results.
Subtitle String Subtitle of the item. Only returned if the seller included a subtitle for the listing.
WatchCount Integer The number of watches placed on this item from the My eBay accounts of the buyers.
BidCount Integer The number of bids that have been placed on the item.
BuyItNowPrice Decimal The Buy It Now Price of the item (if any), in the currency of the site on which the item was listed.
Currency String The 3-digit ISO 4217 currency codes for the currency used by the site.
OriginalRetailPrice Decimal The actual retail price set by the manufacturer (OEM).
PricingTreatment String Using OriginalRetailPrice, MinimumAdvertisedPrice, and StartPrice values, eBay identifies whether the listing falls under MAP or STP (aka OriginalRetailPrice).
SoldOffEbay Boolean Used by the eBay UK and eBay Germany (DE) sites, this flag indicates that the discount price (specified as StartPrice) is the price for which the seller offered the same (or similar) item for sale on a Web site or offline store other than eBay in the previous 30 days. The discount price is always in reference to the price for the item set by the seller.
SoldOnEbay Boolean Used by the eBay UK and eBay Germany (DE) sites, this flag indicates that the discount price (specified as StartPrice) is the price for which the seller offered the same (or similar) item for sale on eBay in the previous 30 days. The discount price is always in reference to the price for the item set by the seller.
GlobalId String The site upon which the item is listed. Returns a Global Id, which is a unique identifier for combinations of site, language, and territory.
ImageURL String URL for a picture used as the Gallery thumbnail, if any. The image uses one of the following graphics formats: JPEG, BMP, TIF, or GIF. Only returned if the seller chose to show a gallery image.
OriginalPrice Decimal Original price of an item whose price a seller has reduced with the Promotional Price Display feature. Only returned if the price has been revised.
PrimaryCategoryId String Numeric Id of the first (or only) category in which the item is listed. (Listings can appear in more than one category.)
PrimaryCategoryName String Display name of the first (or only) category in which the item is listed. This is a fully qualified category breadcrumb (e.g., Computers & Networking:Laptops, Notebooks).
ShippingCost Decimal The shipping cost associated with the first shipping service. Only returned when ShippingType is flat.
ShippingType String The shipping cost model offered by the seller.
TimeLeft String Time left before the item listing ends. The duration is represented in the ISO 8601 duration format (PnDTnHnMnS). For ended listings, the time left is P0DT0H0M0S (zero days, zero hours, zero minutes, and zero seconds).
ViewItemURL String The URL of the Web page where a user can view the listing. On the U.S. site, this is called the View Item page. If you enabled affiliate tracking in the call, ViewItemURL contains a string that includes affiliate tracking information (see the eBay Partner Network).

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
CategoryId String Specifies the category from which to retrieve item listings.
AffiliateCustomId String Need not be specified. You can define an AffiliateCustomId to better monitor your marketing efforts. If you are using the eBay Partner Network, and you provide an AffiliateCustomId, the tracking URL returned by the eBay Partner Network will contain the AffiliateUserId.
AffiliateNetworkId String Specifies your tracking partner for affiliate commissions.
AffiliateTrackingId String The value you specify is obtained from your tracking partner.

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