CData ODBC Driver for Amazon Marketplace 2019 - Online Help
Questions / Feedback?

Products

CData ODBC Driver for Amazon Marketplace 2019 - Build 19.0.7354

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

Select

The driver 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 driver. 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.

Columns

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.

The allowed values are ASIN, GCID, SellerSKU, UPC, EAN, ISBN, JAN.

IdList String The product id.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0