JDBC Driver for Amazon Marketplace

Build 22.0.8538

ListingsItems

Returns details about a listings item for a selling partner.

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 ListingsItems WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'

INSERT INTO ListingsItems(ProductType, Requirements, Attributes, SKU, SellerId)
VALUES ('product_type', 'LISTING', '{\"AttributeName\": \"test_attribute\", \"AttributeValue\": \"value\"}', '12345', 'XXXXXXXXXXXXXX')

DELETE FROM ListingsItems WHERE SKU = '12345' AND SellerId='XXXXXXXXXXXXXX'
When inserting, you can also use temp tables in order to insert multiple attributes, as shown in the example below:
INSERT INTO Attributes#temp(AttributeName, AttributeValue) VALUES ('attr1','val1')
INSERT INTO Attributes#temp(AttributeName, AttributeValue) VALUES ('attr2','val2')
INSERT INTO Attributes#temp(AttributeName, AttributeValue) VALUES ('attr3','val3')

INSERT INTO ListingsItems(ProductType, Requirements, Attributes, SKU, SellerId)
VALUES ('product_type', 'LISTING', 'Attributes#temp', '12345', 'XXXXXXXXXXXXXX')

Columns

Name Type ReadOnly References Description
SKU [KEY] String True

A selling partner provided identifier for an Amazon listing.

FulfillmentAvailability String False

Fulfillment availability for the listings item.

ProcurementCostCurrency String True

The price (ISO4217 currency code) that you want Amazon to pay you for this product.

ProcurementCostAmount String True

The price (numeric value) that you want Amazon to pay you for this product.

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
Attributes String

This field is required for INSERT statements. Aggregate field containing structured 'AttributeName' and 'AttributeValue' fields.

SellerId String

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

Requirements String

This field can be specified for INSERT statements.

The allowed values are LISTING, LISTING_PRODUCT_ONLY, LISTING_OFFER_ONLY.

ProductType String

This field is required for INSERT statements.

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