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

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

Last updated