JDBC Driver for Amazon Marketplace

Build 22.0.8538

SubmitSourcingOnDemandFeed

Usage information for the operation SubmitSourcingOnDemandFeed.rsb.

Execute

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

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'

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

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