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 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 |
| 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 status of the transaction indicated by the specified transactionId. |
| CheckVendorTransactionStatus | Returns the status of the transaction that you specify. |
| ConfirmDirectFulfillmentShipment | Submits one shipment confirmation for vendor orders. |
| ConfirmDirectFulfillmentShipmentBatch | Submits one or more shipment confirmations for vendor orders. |
| 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 | Creates a shipping label for a purchase order and returns a `transactionId` for reference. |
| SubmitDirectFulfillmentShippingLabelBatch | Creates shipping labels for a purchase order and returns a `transactionId` for reference. |
| 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 inventory updates for the specified warehouse for either a partial or full feed of inventory items. |
| UpdateDirectFulfillmentShipmentStatus | This operation is only to be used by Vendor-Own-Carrier (VOC) vendors to update a shipment status. |
| UpdateDirectFulfillmentShipmentStatusBatch | This operation is only to be used by Vendor-Own-Carrier (VOC) vendors to update multiple shipment statuses in the same operation execution. |