Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in 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 Excel Add-In for Amazon Marketplace Stored Procedures
| Name | Description |
| CancelReport | CancelReport operation cancels report request for the given ReportId. |
| CheckVendorTransactionStatus | Returns the status of the transaction that you specify. |
| 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. |
| SubmitVendorOrderAcknowledgement | Submits acknowledgements for one purchase order. |
| SubmitVendorPayments | Submit new invoices to Amazon Marketplace. |
| SubmitVendorShipmentConfirmations | Submits shipment confirmations for vendor orders. |