HighestBidder

Query the Highest Bidder of the eBay users who bid on a specified listing, regardless of whether the listing has ended.

テーブル固有の情報

フィルタがサポートされているカラムはItemId およびListMode です。このビューからデータを取得するには、ItemId を指定する必要があります。

SELECT * FROM HighestBidder WHERE ItemId = '1234567'

SELECT * FROM HighestBidder WHERE ItemId = '1234567' AND ListMode = 'EndedListing'


Name	Type	Description
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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
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. 使用できる値は次のとおりです。EndedListing, SecondChanceEligibleEndedListing, ViewAll