ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、Amazon Marketplace の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにAmazon Marketplace から関連するレスポンスデータを返します。

CData Excel Add-In for Amazon Marketplace ストアドプロシージャ


Name	Description
AcknowledgeDirectFulfillmentOrder	Submits an acknowledgement for a purchase order.
AcknowledgeDirectFulfillmentOrderBatch	Submits acknowledgements for one or more purchase orders.
CancelReport	CancelReport operation cancels report request for the given ReportId.
CheckDirectFulfillmentTransaction	Returns the processing status of the transaction for the specified transactionId, including checking the status of shipment confirmations, monitoring bulk operations for completion, and retrieving error details for failed transactions.
CheckVendorTransactionStatus	Returns the status of the transaction that you specify.
ConfirmDirectFulfillmentShipment	Submits a single shipment confirmation to Amazon, notifying them that an order has been dispatched to the customer.
ConfirmDirectFulfillmentShipmentBatch	Enables bulk submission of multiple shipment confirmations in a single API call, improving efficiency when processing high volumes of daily shipments.
CreateDirectFulfillmentContainer	Creates a container (pallet) label for the associated shipment package.
CreateReportSchema	Creates a schema file based on the specified report.
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.
SubmitDirectFulfillmentShippingLabel	Generates and submits shipping label requests for individual direct fulfillment orders, obtaining carrier-specific labels required for package shipping.
SubmitDirectFulfillmentShippingLabelBatch	Enables bulk generation of shipping labels for multiple orders in a single request, streamlining label creation for high-volume fulfillment operations.
SubmitVendorOrderAcknowledgement	Submits acknowledgements for one purchase order.
SubmitVendorPayments	Submit new invoices to Amazon Marketplace for a vendor's direct fulfillment orders.
SubmitVendorShipmentConfirmations	Submits shipment confirmations for vendor orders.
UpdateDirectFulfillmentInventory	Submits real-time inventory updates for the specified warehouse for either a partial or full feed of inventory items.
UpdateDirectFulfillmentShipmentStatus	Updates the status of a previously submitted shipment, allowing vendors to communicate changes such as delivery completion, failed deliveries, or returns.
UpdateDirectFulfillmentShipmentStatusBatch	Enables bulk updates of shipment statuses, allowing vendors to efficiently process status changes for multiple shipments simultaneously.