ODBC Driver for eBay

Build 20.0.7587

HighestBidder

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

Table Specific Information

Select

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'

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

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
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.

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