CData BizTalk Adapter for Amazon Marketplace 2019 - Online Help
Questions / Feedback?

SubmitOrderAcknowledgementFeed

CData BizTalk Adapter for Amazon Marketplace 2019 - Build 19.0.7354

The Order Acknowledgment feed allows you to acknowledge your success or failure with downloading an order.

Execute

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

You must include in your query :

INSERT INTO OrderAcknowledgementFeedAggregate#TEMP(AmazonOrderId,StatusCode,AmazonOrderItemCode,CancelReason) VALUES ('249-6070298-2783041','Failure','25959136016214','NoInventory')

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

EXEC SubmitOrderAcknowledgementFeed OrderAcknowledgementFeedAggregate='OrderAcknowledgementFeedAggregate#TEMP'

The aggregate information can be entered by specifying it in this XML format

<Row>
	<AmazonOrderId>249-6070298-2783041</AmazonOrderId>
	<StatusCode>Failure</StatusCode>
	<AmazonOrderItemCode>25959136016214</AmazonOrderItemCode>
	<CancelReason>NoInventory</CancelReason>
</Row>

EXEC SubmitOrderAcknowledgementFeed OrderAcknowledgementFeedAggregate='<Row>
	<AmazonOrderId>249-6070298-2783041</AmazonOrderId>
	<StatusCode>Failure</StatusCode>
	<AmazonOrderItemCode>25959136016214</AmazonOrderItemCode>
	<CancelReason>NoInventory</CancelReason>
</Row>'

Input

Name Type Required Description
AmazonOrderID String False Amazon's unique identifier for an order, which identifies the entire order, regardless of the number of individual items in the order.
MerchantOrderID String False Optional seller-supplied order ID. Amazon will map the MerchantOrderID to the AmazonOrderID, and you can then use your own order ID (MerchantOrderID) for subsequent feeds relating to the order.
StatusCode String False Allows you to acknowledge your success or failure with downloading an order. StatusCode can be either Success or Failure.
AmazonOrderItemCode String False Amazon's unique identifier for an item in an order.
MerchantOrderItemID String False Optional seller-supplied ID for an item in an order. If the MerchantOrderItemID is specified with the AmazonOrderItemCode, Amazon will map the two IDs and you can then use your own order item ID for subsequent feeds relating to that order item.
CancelReason String False Used only when sending a StatusCode of Failure.
ItemAggregate String False An aggregate representing an order Item. Can be in the form of XML or a #TEMP table. Use this field when multiple items in the order need to be acknowledged.
OrderAcknowledgementFeedAggregate String False An aggregate representing the feed. Can be in the form of XML, JSON 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) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0