# Schema Information

## Tables/APIs&#x20;

The following is the list of tables or APIs associated with the Keepa connector:

* [Categories](#categories)
* [Most\_Rated\_Sellers](#most_rated_sellers)
* [Best\_Sellers](#best_sellers)
* [Deals](#deals)
* [Seller\_Information](#seller_information)
* [LightningDeal](#lightningdeal)
* [Products](#products)
* [Product\_Details](#product_details)

#### Categories

Get category objects and (optionally) their parent tree using a category ID. For more information, see [Category Lookup](https://keepa.com/#!discuss/t/category-lookup/113).

**Fields**

<table><thead><tr><th width="142">Field Name</th><th width="111">Data Type</th></tr></thead><tbody><tr><td>CatId</td><td>STRING</td></tr><tr><td>Details</td><td>RECORD</td></tr></tbody></table>

#### Most\_Rated\_Sellers&#x20;

Get a Seller ID list of the most rated Amazon marketplace sellers. For more information, see [Most Rated Seller List](https://keepa.com/#!discuss/t/most-rated-sellers/3725).

**Field**

<table><thead><tr><th width="142">Field Name</th><th width="111">Data Type</th></tr></thead><tbody><tr><td>sellerIdList</td><td>STRING</td></tr></tbody></table>

#### Best\_Sellers&#x20;

Get an ASIN list of the most popular products based on sales in a specific category or product group. For more information, see [Request Best Sellers](https://keepa.com/#!discuss/t/request-best-sellers/1298).

**Field**

<table><thead><tr><th width="142">Field Name</th><th width="111">Data Type</th></tr></thead><tbody><tr><td>bestSellersList</td><td>RECORD</td></tr></tbody></table>

#### Deals&#x20;

Get the list of deals based on category. Deals help you find recently changed products and match your search criteria. For more information, see [Browsing Deals](https://keepa.com/#!discuss/t/browsing-deals/338).

**Fields**

<table><thead><tr><th width="142">Field Name</th><th width="111">Data Type</th></tr></thead><tbody><tr><td>dr</td><td>RECORD</td></tr><tr><td>categoryIds</td><td>STRING</td></tr><tr><td>categoryNames</td><td>STRING</td></tr><tr><td>categoryCount</td><td>STRING</td></tr></tbody></table>

#### Seller\_Information&#x20;

Retrieves the seller object using the seller ID. For more information, see [Request Seller Information](https://keepa.com/#!discuss/t/request-seller-information/790).

**Fields**

<table><thead><tr><th width="142">Field Name</th><th width="111">Data Type</th></tr></thead><tbody><tr><td>trackedSince</td><td>NUMERIC</td></tr><tr><td>domainId</td><td>NUMERIC</td></tr><tr><td>sellerId</td><td>STRING</td></tr><tr><td>sellerName</td><td>STRING</td></tr><tr><td>csv</td><td>STRING</td></tr><tr><td>lastUpdate</td><td>NUMERIC</td></tr><tr><td>isScammer</td><td>BOOLEAN</td></tr><tr><td>hasFBA</td><td>BOOLEAN</td></tr><tr><td>sellerCategoryStatistics</td><td>RECORD</td></tr><tr><td>sellerBrandStatistics</td><td>RECORD</td></tr><tr><td>shipsFromChina</td><td>BOOLEAN</td></tr><tr><td>address</td><td>STRING</td></tr><tr><td>recentFeedback</td><td>RECORD</td></tr><tr><td>lastRatingUpdate</td><td>NUMERIC</td></tr><tr><td>neutralRating</td><td>STRING</td></tr><tr><td>negativeRating</td><td>STRING</td></tr><tr><td>positiveRating</td><td>STRING</td></tr><tr><td>ratingCount</td><td>STRING</td></tr><tr><td>businessName</td><td>STRING</td></tr><tr><td>asinList</td><td>STRING</td></tr><tr><td>asinListLastSeen</td><td>STRING</td></tr><tr><td>currentRating</td><td>NUMERIC</td></tr><tr><td>currentRatingCount</td><td>NUMERIC</td></tr><tr><td>ratingsLast30Days</td><td>NUMERIC</td></tr></tbody></table>

#### LightningDeal&#x20;

Get the list of all current and upcoming lightning deals. For more information, see [Lightning Deals](https://keepa.com/#!discuss/t/lightning-deals-request/9708).

**Fields**

<table><thead><tr><th width="142">Field Name</th><th width="111">Data Type</th></tr></thead><tbody><tr><td>domainId</td><td>NUMERIC</td></tr><tr><td>lastUpdate</td><td>NUMERIC</td></tr><tr><td>asin</td><td>STRING</td></tr><tr><td>sellerName</td><td>STRING</td></tr><tr><td>sellerId</td><td>STRING</td></tr><tr><td>dealId</td><td>STRING</td></tr><tr><td>dealPrice</td><td>NUMERIC</td></tr><tr><td>currentPrice</td><td>NUMERIC</td></tr><tr><td>image</td><td>STRING</td></tr><tr><td>isPrimeEligible</td><td>BOOLEAN</td></tr><tr><td>isFulfilledByAmazon</td><td>BOOLEAN</td></tr><tr><td>isMAP</td><td>BOOLEAN</td></tr><tr><td>rating</td><td>NUMERIC</td></tr><tr><td>totalReviews</td><td>NUMERIC</td></tr><tr><td>dealState</td><td>STRING</td></tr><tr><td>startTime</td><td>NUMERIC</td></tr><tr><td>endTime</td><td>NUMERIC</td></tr><tr><td>percentClaimed</td><td>NUMERIC</td></tr><tr><td>variation</td><td>RECORD</td></tr><tr><td>percentOff</td><td>NUMERIC</td></tr><tr><td>title</td><td>STRING</td></tr></tbody></table>

#### Products&#x20;

Get the product object for the specified ASIN and domain. For more information, see [Product Request](https://keepa.com/#!discuss/t/request-products/110).

**Fields**

<table><thead><tr><th width="142">Field Name</th><th width="111">Data Type</th></tr></thead><tbody><tr><td>csv</td><td>STRING</td></tr><tr><td>categories</td><td>STRING</td></tr><tr><td>imagesCSV</td><td>STRING</td></tr><tr><td>manufacturer</td><td>STRING</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>lastUpdate</td><td>NUMERIC</td></tr><tr><td>lastPriceChange</td><td>NUMERIC</td></tr><tr><td>rootCategory</td><td>NUMERIC</td></tr><tr><td>productType</td><td>NUMERIC</td></tr><tr><td>asin</td><td>STRING</td></tr><tr><td>domainId</td><td>NUMERIC</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>hasReviews</td><td>BOOLEAN</td></tr><tr><td>trackingSince</td><td>NUMERIC</td></tr><tr><td>productGroup</td><td>STRING</td></tr><tr><td>format</td><td>STRING</td></tr><tr><td>packageHeight</td><td>NUMERIC</td></tr><tr><td>packageLength</td><td>NUMERIC</td></tr><tr><td>packageWidth</td><td>NUMERIC</td></tr><tr><td>packageWeight</td><td>NUMERIC</td></tr><tr><td>packageQuantity</td><td>NUMERIC</td></tr><tr><td>isAdultProduct</td><td>BOOLEAN</td></tr><tr><td>isEligibleForTradeIn</td><td>BOOLEAN</td></tr><tr><td>isEligibleForSuperSaverShipping</td><td>BOOLEAN</td></tr><tr><td>buyBoxSellerIdHistory</td><td>STRING</td></tr><tr><td>isRedirectASIN</td><td>BOOLEAN</td></tr><tr><td>isSNS</td><td>BOOLEAN</td></tr><tr><td>author</td><td>STRING</td></tr><tr><td>binding</td><td>STRING</td></tr><tr><td>numberOfItems</td><td>NUMERIC</td></tr><tr><td>numberOfPages</td><td>NUMERIC</td></tr><tr><td>publicationDate</td><td>NUMERIC</td></tr><tr><td>releaseDate</td><td>NUMERIC</td></tr><tr><td>languages</td><td>STRING</td></tr><tr><td>lastRatingUpdate</td><td>NUMERIC</td></tr><tr><td>lastEbayUpdate</td><td>NUMERIC</td></tr><tr><td>newPriceIsMAP</td><td>BOOLEAN</td></tr><tr><td>availabilityAmazon</td><td>NUMERIC</td></tr><tr><td>listedSince</td><td>NUMERIC</td></tr><tr><td>itemHeight</td><td>NUMERIC</td></tr><tr><td>itemLength</td><td>NUMERIC</td></tr><tr><td>itemWidth</td><td>NUMERIC</td></tr><tr><td>itemWeight</td><td>NUMERIC</td></tr><tr><td>salesRankReference</td><td>NUMERIC</td></tr><tr><td>salesRanks</td><td>RECORD</td></tr><tr><td>salesRankReferenceHistory</td><td>STRING</td></tr><tr><td>launchpad</td><td>BOOLEAN</td></tr><tr><td>isB2B</td><td>BOOLEAN</td></tr><tr><td>contributors</td><td>STRING</td></tr><tr><td>stats</td><td>RECORD</td></tr><tr><td>offersSuccessful</td><td>BOOLEAN</td></tr><tr><td>g</td><td>NUMERIC</td></tr><tr><td>categoryTree</td><td>RECORD</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>edition</td><td>STRING</td></tr></tbody></table>

#### Product\_Details

Get the product rating and count of reviews. For more information, see [Product Request](https://keepa.com/#!discuss/t/request-products/110).

**Fields**

| fullname                 | type    |
| ------------------------ | ------- |
| Rating                   | RECORD  |
| Count\_Reviews           | RECORD  |
| \_daton\_user\_id        | NUMERIC |
| \_daton\_batch\_runtime  | NUMERIC |
| \_daton\_batch\_id       | NUMERIC |
| asin                     | STRING  |
| Rating.timestamp         | NUMERIC |
| Rating.value             | NUMERIC |
| Count\_Reviews.timestamp | NUMERIC |
| Count\_Reviews.value     | NUMERIC |
