JDBC Driver for Amazon Marketplace

Build 20.0.7695


The Products Table helps you get information to match your products to existing product listings on Amazon Marketplace websites.


The 本製品 will use the Amazon Marketplace API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品. For example, the following query is processed server side:

SELECT * FROM Products WHERE SearchTerms = '249-7638334-8161403'

SELECT * FROM Products WHERE idType='SellerSKU' AND idlist='{SellerSku code}'

SELECT * FROM Products WHERE idType='ASIN' AND idlist='{ASIN code}'

SELECT * FROM Products WHERE idType='GCID' AND idlist='{GCID code}'

SELECT * FROM Products WHERE idType='UPC' AND idlist='{UPC code}'

SELECT * FROM Products WHERE idType='EAN' AND idlist='{EAN code}'

SELECT * FROM Products WHERE idType='ISBN' AND idlist='{ISBN code}'

SELECT * FROM Products WHERE idType='JAN' AND idlist='{JAN code}'

SELECT * FROM Products WHERE idType='JAN' AND idlist IN ('{JAN code}', '{ISBN code}', '{GCID code}')
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.


Name Type References Description
MarketplaceASIN [KEY] String The Marketplace ASIN.
MarketplaceASINMarketplaceId String The MarketplaceId of Marketplace ASIN.
SKUIdentifierMarketplaceId String The SKUIdentifier of MarketplaceId.
SKUIdentifierSelerId String The MarketplaceId of SellerId.
SKUIdentifierSellerSKU String The MarketplaceId of SellerSKU.
AttributeSets String The product attributes.
Relationships String The product relationships.
SalesRankings String The product sales rankings.
SearchTerms String
IdType String The product id type.

使用できる値は次のとおりです。ASIN, GCID, SellerSKU, UPC, EAN, ISBN, JAN

IdList String The product id.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695