# Schema Information

## Tables/APIs 

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 |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/ecommerce/keepa/schema-information.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.