Query the Highest Bidder of the eBay users who bid on a specified listing, regardless of whether the listing has ended.
Table Specific Information
The only supported columns for filtering are ItemId and ListMode. An ItemId must be specified for retrieving data from this view.
Select * FROM HighestBidder WHERE ItemId = '1234567'
Select * FROM HighestBidder WHERE ItemId = '1234567' And ListMode = 'EndedListing'
|ItemId||String||The Id of the item. The bidders who bid on this item are returned.|
|HighBidder||String||eBay user Id for the user with the highest bid (or the earliest timestamp, in the event of a tie); a second chance offer candidate.|
|HighestBid||Decimal||Bid amount offered by the highest bidder.|
|Currency||String||Currency code of the bid.|
|ListingStatus||String||Specifies the status of an active or ended listing in the processing workflow of the eBay system. If a listing ends with a sale (or sales), eBay needs to update the sale details (e.g., total price and buyer/high bidder) and the final value fee. This processing can take several minutes. If you retrieve a sold item and no details about the buyer/high bidder are returned or no final value fee is available, use this listing status information to determine whether eBay has finished processing the listing.|
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.
|ListMode||String||Specifies which bidder information to return. EndedListing returns all nonwinning bidders for ended listings only. It can be used only by a seller. SecondChanceEligibleEndedListing returns all nonwinning bidders for an ended listing who have not yet received a Second Chance Offer and noted interest in receiving a Second Chance Offer. It can be used only by a seller. ViewAll returns all bidders for an ended or still-active listing. It can be used by any user.
The allowed values are EndedListing, SecondChanceEligibleEndedListing, ViewAll.