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.

Field

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.

Field

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