Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Keepa connector and the associated fields and tables.
Schema Information
This subtopic provides a structured reference to assist you in working with Daton's Keepa connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Keepa connector:
- Categories
- Most_Rated_Sellers
- Best_Sellers
- Deals
- Seller_Information
- LightningDeal
- Products
- Product_Details
Categories
Get category objects and (optionally) their parent tree using a category ID. For more information, see Category Lookup.
Fields
Field Name |
Data Type |
---|---|
CatId |
STRING |
Details | RECORD |
Most_Rated_Sellers
Get a Seller ID list of the most rated Amazon marketplace sellers. For more information, see Most Rated Seller List.
Fields
Field Name |
Data Type |
---|---|
sellerIdList | STRING |
Best_Sellers
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.
Fields
Field Name |
Data Type |
---|---|
bestSellersList | RECORD |
Deals
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.
Fields
Field Name |
Data Type |
---|---|
dr |
RECORD |
categoryIds |
STRING |
categoryNames |
STRING |
categoryCount | STRING |
Seller_Information
Retrieves the seller object using the seller ID. For more information, see Request Seller Information.
Fields
Field Name |
Data Type |
---|---|
trackedSince |
NUMERIC |
domainId |
NUMERIC |
sellerId |
STRING |
sellerName |
STRING |
csv |
STRING |
lastUpdate |
NUMERIC |
isScammer |
BOOLEAN |
hasFBA |
BOOLEAN |
sellerCategoryStatistics |
RECORD |
sellerBrandStatistics |
RECORD |
shipsFromChina |
BOOLEAN |
address |
STRING |
recentFeedback |
RECORD |
lastRatingUpdate |
NUMERIC |
neutralRating |
STRING |
negativeRating |
STRING |
positiveRating |
STRING |
ratingCount |
STRING |
businessName |
STRING |
asinList |
STRING |
asinListLastSeen |
STRING |
currentRating |
NUMERIC |
currentRatingCount |
NUMERIC |
ratingsLast30Days | NUMERIC |
LightningDeal
Get the list of all current and upcoming lightning deals. For more information, see Lightning Deals.
Fields
Field Name |
Data Type |
---|---|
domainId |
NUMERIC |
lastUpdate |
NUMERIC |
asin |
STRING |
sellerName |
STRING |
sellerId |
STRING |
dealId |
STRING |
dealPrice |
NUMERIC |
currentPrice |
NUMERIC |
image |
STRING |
isPrimeEligible |
BOOLEAN |
isFulfilledByAmazon |
BOOLEAN |
isMAP |
BOOLEAN |
rating |
NUMERIC |
totalReviews |
NUMERIC |
dealState |
STRING |
startTime |
NUMERIC |
endTime |
NUMERIC |
percentClaimed |
NUMERIC |
variation |
RECORD |
percentOff |
NUMERIC |
title | STRING |
Products
Get the product object for the specified ASIN and domain. For more information, see Product Request.
Fields
Field Name |
Data Type |
---|---|
csv | STRING |
categories |
STRING |
imagesCSV |
STRING |
manufacturer |
STRING |
title |
STRING |
lastUpdate |
NUMERIC |
lastPriceChange |
NUMERIC |
rootCategory |
NUMERIC |
productType |
NUMERIC |
asin |
STRING |
domainId |
NUMERIC |
type |
STRING |
hasReviews |
BOOLEAN |
trackingSince |
NUMERIC |
productGroup |
STRING |
format |
STRING |
packageHeight |
NUMERIC |
packageLength |
NUMERIC |
packageWidth |
NUMERIC |
packageWeight |
NUMERIC |
packageQuantity |
NUMERIC |
isAdultProduct |
BOOLEAN |
isEligibleForTradeIn |
BOOLEAN |
isEligibleForSuperSaverShipping |
BOOLEAN |
buyBoxSellerIdHistory |
STRING |
isRedirectASIN |
BOOLEAN |
isSNS |
BOOLEAN |
author |
STRING |
binding |
STRING |
numberOfItems |
NUMERIC |
numberOfPages |
NUMERIC |
publicationDate |
NUMERIC |
releaseDate |
NUMERIC |
languages |
STRING |
lastRatingUpdate |
NUMERIC |
lastEbayUpdate |
NUMERIC |
newPriceIsMAP |
BOOLEAN |
availabilityAmazon |
NUMERIC |
listedSince |
NUMERIC |
itemHeight |
NUMERIC |
itemLength |
NUMERIC |
itemWidth |
NUMERIC |
itemWeight |
NUMERIC |
salesRankReference |
NUMERIC |
salesRanks |
RECORD |
salesRankReferenceHistory |
STRING |
launchpad |
BOOLEAN |
isB2B |
BOOLEAN |
contributors |
STRING |
stats |
RECORD |
offersSuccessful |
BOOLEAN |
g |
NUMERIC |
categoryTree |
RECORD |
description |
STRING |
edition |
STRING
|
Product_Details
Get the product rating and count of reviews. For more information, see Product Request.
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 |