JDBC Driver for Amazon Marketplace

Build 22.0.8538

SubmitImageFeed

The Image feed allows you to upload various images for a product. Amazon can display several images for each product.

Execute

The Driver Uses #TEMP tables as fields for aggregate information entered

You must include in your query:

INSERT INTO ImageFeedAggregate#TEMP (SKU,ImageType,ImageLocation,OperationType) VALUES ('15700','Main','https://www.cdata.com/ui/img/home/adapters.png','Update')

Then you execute the procedure by specifying the value of ImageFeedAggregate with the name of #TEMP table used ImageFeedAggregate#TEMP.

EXEC SubmitImageFeed ProductImageFeedAggregate = 'ImageFeedAggregate#TEMP'

Input

Name Type Required Description
SKU String True Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
ImageType String False Required. Available Values are Main, Swatch, BKLB, PT1, PT2, PT3, PT4, PT5, PT6, PT7, PT8, Search, PM01, MainOfferImage, OfferImage1, OfferImage2, OfferImage3, OfferImage4, OfferImage5, PFEE, PFUK, PFDE, PFFR, PFIT, PFES, EEGL, PT98, PT99, and ELFL.
ImageLocation String False The exact location of the image using a full URL (such as http://mystore.com/images/1234.jpg).
OperationType String True Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
ProductImageFeedAggregate String False An aggregate representing the feed. Can be in the form of XML or a #TEMP table.

Result Set Columns

Name Type Description
FeedSubmissionId String A unique identifier for the feed submission.
FeedType String The type of feed submitted.
SubmittedDate Datetime The date and time when the feed was submitted.
FeedProcessingStatus String The processing status of the feed submission.

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