ODBC Driver for eBay

Build 24.0.8963

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963