JDBC Driver for Amazon Marketplace

Build 22.0.8538

SubmitRelationshipFeed

The Relationship feed allows you to set up optional relationships between items in your catalog.

Execute

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

You must include in your query:

INSERT INTO RelationAggregate#TEMP (Type,SKU) VALUES ('Variation','99987867')

INSERT INTO RelationAggregate#TEMP (Type,SKU) VALUES ('Variation','99987867')

INSERT INTO RelationshipFeedAggregate#TEMP (ParentSKU,RelationAggregate) VALUES ('15700','RelationAggregate#TEMP')

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

EXEC SubmitRelationshipFeed RelationshipFeedAggregate = 'RelationshipFeedAggregate#TEMP', marketplaceids = 'A1VC38T7YXB528'

Input

Name Type Required Description
ParentSKU String False Required. The master SKU for a product with variations.
OperationType String False Required. Used to specify the type of operation (Update or Delete) to be performed on the data.
Type String False Type of relationship; currently supported are Variation or Accessory.
SKU String False Used to identify an individual product, one (child) variation of the parent SKU.
RelationAggregate String False An aggregate representing the the relation. Can be in the form of XML, JSON or a #TEMP table. Use this field when applying multiple relations
RelationshipFeedAggregate String False An aggregate representing the feed. Can be in the form of XML or #TEMP table.
MarketplaceIds String False Required. A list of one or more marketplace IDs for the marketplace that registered the listing account.

Result Set Columns

Name Type Description
FeedId String A unique identifier for the feed.
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