ODBC Driver for eBay

Build 20.0.7587

Transactions

Query all transactions in which the authenticated user is either the buyer or seller. By default, only transactions of orders made in the last 90 days are returned. Transactions of orders older than 90 days can be retrieved by specifying OrderId.

View Specific Information

Select

Examples of querying the Transactions view.

Select * FROM Transactions WHERE OrderRole = 'Seller'

Select * FROM Transactions WHERE OrderId = '110276240386-28854859001'

Select * FROM Transactions WHERE CreateTimeFrom = '2/10/2018' And CreateTimeTo = '3/16/2018'

Columns

Name Type Description
TransactionId [KEY] String Unique identifier for an eBay order line item. An order line item is created once there is a commitment from a buyer to purchase an item.
OrderId String The Id that uniquely identifies the item listing. The Id is generated by eBay after an item is listed. You cannot choose or revise this value.
ItemId String The unique identifier of the eBay listing. This identifier is generated by eBay and returned in the response of an Add call if an item is successfully listed.
ItemSite String The name of the site on which the item is listed.
ItemTitle String This field is used to specify the title of the listing.
ActualHandlingCost Decimal The handling cost that the seller has charged for the order line item.
ActualShippingCost Decimal The shipping cost paid by the buyer for the order line item. This field is only returned after checkout is complete.
BuyerEmail String Email address for the user.
BuyerFirstName String The first name of the buyer who purchased the order.
BuyerLastName String The last name of the buyer who purchased the order.
CreatedDate Datetime Indicates the creation time of the order line item.
Price Decimal The price of the order line item.
SiteId String The site upon which the order line item (transaction) was created.
PaidTime Datetime Indicates the time when the order was marked paid.
DigitalRecipientEmail String This field displays the email address of the sender/purchaser of the digital gift card.
DigitalRecipientName String This field displays the actual name (not the eBay user ID) of the sender/purchaser of the digital gift card.
DigitalSenderEmail String This field displays the email address of the sender/purchaser of the digital gift card.
DigitalSenderName String This field displays the actual name (not the eBay user ID) of the sender/purchaser of the digital gift card
DigitalDeliveryMethod String This value indicates the method in which the digital gift card will be delivered to the buyer.
EBayPlusTransaction Boolean If true, this transaction is for an item that was purchased under the eBay Plus program.
ExternalTransactionId String Unique identifier for a PayPal payment of an eBay order.
ExternalTransactionStatus String The current processing status of a PayPal payment for an eBay order.
ExternalTransactionTime Datetime Timestamp for payment transaction.
ExternalFeeOrCreditAmount Decimal Fee Amount is a positive value and Credit Amount is a negative value.
ExternalPaymentOrRefundAmount Decimal If positive, the amount the buyer pays the seller through PayPal on the purchase of items. If negative, the amount refunded the buyer. Default = 0.
FinalValueFee Decimal A Final Value Fee is calculated and charged to a seller's account immediately upon creation of an order line item.
GuaranteedDelivery Boolean This field is returned as true if the order line item is qualified for eBay Guaranteed Delivery, or false if it is not eligible.
GuaranteedShipping Boolean This field is returned as true if the seller chose to use eBay's Guaranteed Shipping feature at listing time.
InvoiceSentTime Datetime This field indicates the date/time that an order invoice was sent from the seller to the buyer.
DigitalStatus String This enumeration value indicates the current state of a purchased digital gift card.
InquiryStatus String This field gives the status of a buyer's Item Not Received (INR) Inquiry.
ReturnStatus String This field gives the status of a buyer's return request.
TotalTaxAmount Decimal This value indicates the total tax amount for the order line item, including the sales tax on the item, the sales tax on shipping and handling, and any electronic waste recycling fee.
UnpaidItemStatus String This field indicates the status of the Unpaid Item case. This field is always returned with the UnpaidItem container.
UnpaidItemType String This field indicates if the Unpaid Item case was opened manually by the customer or opened automatically by eBay's Unpaid Item Assistant feature.

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
CreateTimeFrom Datetime Specifies the start of the date range for which to retrieve transactions of orders created within this date range.
CreateTimeTo Datetime Specifies the end of the date range for which to retrieve transactions of orders created within this date range.
ModTimeFrom Datetime Specifies the start of the date range for which to retrieve transactions of orders modified within this date range. The maximum time range that may be specified is 30 days.
ModTimeTo Datetime Specifies the end of the date range for which to retrieve transactions of orders modified within this date range. The maximum time range that may be specified is 30 days.
NumberOfDays Integer All eBay transactions that were either created or modified within this period are returned in the output. Min: 1. Max: 30.
OrderRole String Filters the returned transactions based on the role of the user. The user's role is either buyer or seller.
OrderStatus String Filters the returned transactions based on the status of the order. Applicable Values: Active, All, Completed, Inactive.

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