JDBC Driver for Amazon Marketplace

Build 22.0.8538

ListingsItemsAttributes

The GetFeedSubmissionList operation returns a list of feed submissions.

The following filters are required:

  • SKU
  • SellerId: You can either specify SellerId as a pseudo-column condition in WHERE filters, or in the connection string.
Some example queries:
SELECT * FROM ListingsItemsAttributes WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'
UPDATE ListingsItemsAttributes SET AttributeValue = 'test_value', ProductType = 'LUGGAGE'
       WHERE SKU = '12345' AND AttributeName = 'item_name_value'
You can also retrieve all SKU fields from another sub-query, for example:
SELECT * FROM ListingsItems WHERE SellerId='XXXXXXXXXXXXXX' AND SKU IN (
        SELECT DISTINCT(SKUIdentifierSellerSKU) FROM CatalogItems WHERE MarketplaceId = 'XXXXXXXXXXXXXX' AND Query = 'test' AND SkuIdentifierSellerSku IS NOT NULL
)

Columns

Name Type ReadOnly References Description
SKU [KEY] String True

A selling partner provided identifier for an Amazon listing.

AttributeName [KEY] String False

The attribute name for the listings item.

AttributeValue String False

The attribute value for the listings item.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ProductType String

The Amazon product type of the listings item. Required for Updating an attribute.

SellerId String

A selling partner identifier, such as a merchant account or vendor code.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8538