HighestBidder
Query the Highest Bidder of the eBay users who bid on a specified listing, regardless of whether the listing has ended.
テーブル固有の情報
Select
フィルタがサポートされているカラムはItemId およびListMode です。このビューからデータを取得するには、ItemId を指定する必要があります。
SELECT * FROM HighestBidder WHERE ItemId = '1234567'
SELECT * FROM HighestBidder WHERE ItemId = '1234567' AND ListMode = 'EndedListing'
Columns
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. |
Pseudo-Columns
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 |