Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Amazon Marketplace.

Stored procedures accept a list of parameters, perform their intended function, and then return, if applicable, any relevant response data from Amazon Marketplace, along with an indication of whether the procedure succeeded or failed.

CData JDBC Driver for Amazon Marketplace Stored Procedures


Name	Description
CancelFeed	The CancelFeed cancels feed submission for the given FeedId
CancelReport	CancelReport operation cancels report request for the given ReportId.
CheckVendorTransactionStatus	Returns the status of the transaction that you specify.
CreateSchema	Creates a schema file for the specified table or view.
DownloadVendorCustomerInvoice	This stored procedure is part of Vendor Direct Fulfillment Shipping API. Returns a customer invoice based on the purchaseOrderNumber that you specify.
DownloadVendorPackingSlip	This stored procedure is part of Vendor Direct Fulfillment Shipping API. Returns a packing slip based on the PurchaseOrderNumber that you specify.
GetOAuthAccessToken	Gets an authentication token from Amazon.
GetOAuthAuthorizationURL	Gets the authorization URL that must be opened separately by the user to grant access to your application. You will request the OAuthAccessToken from this URL.
GetReport	Creates and/or returns data for a specific report.
RefreshOAuthAccessToken	Exchanges a access token for a new access token.
RequestReport	The RequestReport operation creates a report request.
SubmitImageFeed	The Image feed allows you to upload various images for a product. Amazon can display several images for each product.
SubmitInventoryFeed	The Inventory feed allows you to update inventory quantities (stock levels) for your items.
SubmitOrderAcknowledgementFeed	The Order Acknowledgment feed allows you to acknowledge your success or failure with downloading an order.
SubmitOrderAdjustmentFeed	The Order Adjustment feed allows you to issue a refund (adjustment) for an order. You must provide a reason for the adjustment, such as Customer Return, and the adjustment amount, broken down by price component (principle, shipping, tax, and so on).
SubmitOrderFulfillmentFeed	The Order Fulfillment feed allows your system to update Amazon's system with order fulfillment information.
SubmitOverrideFeed	The Override feed allows you to set an exception to your account-level shipping settings for an individual product (SKU).
SubmitPriceFeed	The Price feed allows you to set the current price and sale price (when applicable) for an item.
SubmitProductFeed	The Product feed contains descriptive information about the products in your catalog. This information allows Amazon to build a record and assign a unique identifier known as an ASIN (Amazon Standard Item Number) to each product.
SubmitRelationshipFeed	The Relationship feed allows you to set up optional relationships between items in your catalog.
SubmitSourcingOnDemandFeed	Usage information for the operation SubmitSourcingOnDemandFeed.rsb.
SubmitVendorOrderAcknowledgement	Submits acknowledgements for one purchase order.
SubmitVendorPayments	Submit new invoices to Amazon Marketplace.
SubmitVendorShipmentConfirmations	Submits shipment confirmations for vendor orders.
UpdateShipmentStatus	Update the shipment status for a specific order. Intended to be used with sellers who are participating in the In-store Pickup program.