SubmitSourcingOnDemandFeed

Usage information for the operation SubmitSourcingOnDemandFeed.rsb.

Execute

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

For #TEMP tables

You must include in your query:

INSERT INTO OrderSourcingOnDemandFeedAggregate#TEMP (AmazonOrderID, SKU, EstimatedShipDate) VALUES ('250-4747727-9303810', '15700', '2018-12-08T00:00:00Z');

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

EXEC SubmitSourcingOnDemandFeed OrderSourcingOnDemandFeedAggregate = 'OrderSourcingOnDemandFeedAggregate#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://m.media-amazon.com/images/G/01/rainier/help/xsd/release_4_1/OrderSourcingOnDemand._CB475945388_.xsd):

    <Message>
        <MessageID>1</MessageID>
        <OrderSourcingOnDemand>
            <AmazonOrderID>250-4747727-9303810</AmazonOrderID>
            <SKU>15700</SKU>
            <EstimatedShipDate>2018-12-08T00:00:00Z</EstimatedShipDate>
        </OrderSourcingOnDemand>
      </Message>

EXEC SubmitSourcingOnDemandFeed OrderSourcingOnDemandFeedAggregate = '...(the above XML)...', marketplaceids = 'A1VC38T7YXB528'

Input


Name	Type	Required	Description
AmazonOrderID	String	False	Amazon Order ID.
SKU	Datetime	True	Required. Used to identify an individual product. Each product must have a SKU, and each SKU must be unique.
EstimatedShipDate	String	True	Required. Estimated ship date.
OrderSourcingOnDemandFeedAggregate	String	False	An aggregate representing the feed. Can be in the form of XML or a #TEMP table.
MarketplaceIds	String	True	Required. A list of one or more marketplace IDs for the marketplace that registered the listing account.

Result Set Columns