The Lyftron Provider for eBay offers the most natural way to access eBay data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing eBay data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s eBay data provider and automatically build your data migration pipelines in minutes, not months
The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
- Comprehensive Delta load mechanism.
- Real-time access to eBay.
- Comprehensive full support of ANSI Sql to query data with ease.
- Collaborative query processing.
The user must have credentials for eBay, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron
Establishing a Connection with Lyftron's Quickstart Steps
Create your eBay connection with Lyftron by following the 5 easy steps show below:
Step1. Add your connection
Click on Connect section on the left panel → Click on Add Connection button
Step2. Select your connector
In the connector selection panel, search and click eBay for your connection
Step3. Enter your connection details
In the Connection String section enter the values of the below parameters. The following connection string is required to establish eBay connection with Lyftron."DevID=MyDevID;OAuthClientId=MyAppID;OAuthClientSecret=MyCertID;RuName=MyRuName;SiteID=0;OAuthAccessToken=MyOAuthAccessToken"
|Connection Name||Enter your connection details||Required|
|DevID||Your eBay DevID||Required|
|OAuthClientId||Your eBay OAuthClientId||Required|
|OAuthClientSecret||Your eBay OAuthClientSecret||Required|
|OAuthAccessToken||Your eBay OAuthAccessToken||Required|
|Logfile**||Use the logfile option to debug your job and provide your connection name to generate the log file. [ConnectionConfigurationPath]\Connection_name_log.tx||Optional|
|Verbosity**||Choose verbosity 1-5 based on the severity of debugging||Optional|
** For more information, check the Lyftron logging and debugging section.
If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.
Step4. Test your connection
Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.
Step5. Save your connection
The Lyftron Provider for eBay models entities in the eBay API as tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files.
API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
The Lyftron Provider for eBay models Item Listings in tables so that they can be easily queried, updated, and deleted. You can list items on your eBay store by calling the AddItem stored procedure.
Views are tables that cannot be modified. Typically, read-only data are shown as views.
|ItemListing||Tables||Update, delete, and query Item Listings for sellers.|
|ItemVariations||Tables||Item Variations are multiple similar (but not identical) items in a single fixed-price listing. For example, a T-shirt listing could contain multiple items of the same brand that vary by color and size; each variation would specify a combination of one of these colors and sizes. Each variation can have a different quantity and price. You can buy multiple items from one variation at the same time. (That is, one order line item can contain multiple items from a single variation.)|
|Bidders||Views||Query eBay users that bid on a specified listing, regardless of whether the listing has ended.|
|Categories||Views||Query eBay Categories.|
|CategoryFeatures||Views||Query the settings supported by eBay Categories.|
|CategorySpecifics||Views||Query Item Compatibility List for sellers.|
|Countries||Views||Lists the country code and associated name of the countries supported by the eBay system, regardless of the site specified in the request.|
|Currencies||Views||Query the supported Currencies in eBay.|
|DSRSummary||Views||Query rating information from DSR Summary Reports.|
|HighestBidder||Views||Query the Highest Bidder of the eBay users who bid on a specified listing, regardless of whether the listing has ended.|
|ItemCompatibilityList||Views||Query compatability categories and possible compatability values for a specific item.|
|ItemShipping||Views||Query details pertinent to one or more items for which calculated shipping has been offered by the seller, such as package dimension, weight, and packaging/handling costs.|
|ItemSpecifics||Views||Query item specifics for a specific item.|
|ItemTransactions||Views||Query order line item (transaction) information for a specified listing. For auction listings, order line items are not created until the auction ends with a winning bidder, or if the Buy It Now feature is enabled for the listing and used by the buyer to purchase the item. For fixed-price listings, order line items are created after a buyer has committed to purchase the item(s).|
|MostWatchedItems||Views||Query items with the highest watch counts for the entire site or for a specific category. The top items are determined by the Watch Count totals from the preceding day. Ranking of the Most Watched Items is calculated with the latest Watch Count information.|
|OrderPayments||Views||Query all payments of the orders, in which the authenticated user is either the buyer or seller. By default, only payment details of orders made in the last 90 days are returned. Payment details of orders older than 90 days can be retrieved by specifying OrderId.|
|Orders||Views||Query all orders in which the authenticated user is either the buyer or seller. By default, only orders made in the last 90 days are returned. Orders older than 90 days can be retrieved by specifying OrderId.|
|OrderShipping||Views||Query shipping details of the orders in which the authenticated user is either the buyer or seller. By default, only shipping details of orders made in the last 90 days are returned. Shipping details of orders older than 90 days can be retrieved by specifying OrderId.|
|ShippingCarriers||Views||Query Shipping Carriers supported by the specified site.|
|ShippingCategories||Views||A shipping service category supported for the site.|
|ShippingLocations||Views||Lists the regions and locations supported by eBay's shipping services. Returns all shipping locations supported by eBay, regardless of the site specified in the request.|
|ShippingServices||Views||Query Shipping Services supported by the specified eBay site.|
|Sites||Views||Lists all available eBay sites and their associated SiteID numbers.|
|TopSellingProducts||Views||Query your eBay Top Selling Products.|
|TransactionPayments||Views||Query all payments of the transactions in which the authenticated user is either the buyer or seller. By default, only payments of transactions made in the last 90 days are returned. Payments of the transactions in orders older than 90 days can be retrieved by specifying OrderIds.|
|Transactions||Views||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.|
|TransactionShipping||Views||Query shipping details of the transactions in which the authenticated user is either the buyer or seller. By default, only shipping details of transaction made in the last 90 days are returned. Shipping details of the transactions in orders older than 90 days can be retrieved by specifying OrderIds.|