SubmitRelationshipFeed

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

Execute

The stored procedure accepts two aggregated formats: #TEMP tables and XML aggregate

For #TEMP tables

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'

*The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.

For XML aggregate

The XML aggregate must follow the API structure (https://images-na.ssl-images-amazon.com/images/G/01/rainier/help/xsd/release_4_1/Relationship.xsd):

    <Message>
        <MessageID>1</MessageID>
        <Relationship>
          <ParentSKU>15700</ParentSKU>
          <Relation>
            <SKU>99987867</SKU>
            <Type>Variation</Type>
          </Relation>
          <Relation>
            <SKU>99987867</SKU>
            <Type>Variation</Type>
          </Relation>
        </Relationship>
      </Message>

EXEC SubmitRelationshipFeed RelationshipFeedAggregate = '...(the above XML)...', 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