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
Get category objects and (optionally) their parent tree using a category ID. For more information, see Category Lookup.
Fields
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
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
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
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
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
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
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
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
Last updated