Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component 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 SSIS Components for Amazon Marketplace Stored Procedures
| Name | Description |
| CancelFeed | The CancelFeed cancels feed submission for the given FeedId |
| CancelFulfillmentOrder | Requests that Amazon stop attempting to fulfill the fulfillment order indicated by the specified order identifier. You cannot cancel a fulfillment order with a status of Processing, Complete, or CompletePartialled. |
| CancelInboundPlan | Cancels an Inbound Plan. |
| CancelReport | CancelReport operation cancels report request for the given ReportId. |
| CancelSelfShipAppointment | Cancels a self-ship appointment slot against a shipment. |
| CancelShipment | Cancels a purchased shipment. |
| ConfirmDeliveryWindowOptions | Confirms the delivery window option for chosen shipment within an inbound plan. |
| ConfirmPackingOption | Confirms the packing option for an inbound plan. |
| ConfirmPlacementOption | Confirms the placement option for an inbound plan. |
| ConfirmShipment | The ConfirmShipment operation updates the shipment confirmation status for a specified order. |
| ConfirmShipmentContentUpdatePreview | Confirm a shipment content update preview and accept the changes in transportation cost. |
| ConfirmTransportationOptions | Confirms all the transportation options for an inbound plan. |
| CreateFulfillmentReturn | Creates a fulfillment return. |
| CreateMarketplaceItemLabels | For a given marketplace - creates labels for a list of mskus. |
| CreateProductReviewAndSellerFeedbackSolicitation | Sends a solicitation to a buyer asking for seller feedback and a product review for the specified order. Send only one productReviewAndSellerFeedback or free form proactive message per order. |
| CreateReportSchema | Creates a schema file based on the specified report. |
| CreateScheduledPackage | Schedules an Easy Ship order |
| CreateScheduledPackageBulk | The ConfirmShipment operation updates the shipment confirmation status for a specified order. |
| CreateSchema | Creates a schema file for the specified table or view. |
| CreateTransportationOption | Create a transportation option. |
| GetAdditionalInputsSchema | Returns the JSON schema to use for providing additional inputs when needed to purchase a shipping offering. |
| GetFeedProcessingReport | Creates and/or returns data for a specific report. |
| GetInboundShipmentBillOfLading | Returns a bill of lading for a Less Than Truckload/Full Truckload (LTL/FTL) shipment. |
| GetInboundShipmentLabel | Returns package/pallet labels for faster and more accurate shipment processing at the Amazon fulfillment center. |
| 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. |
| GetScheduledPackage | Returns information about a package, including dimensions, weight, time slot information for handover, invoice and item information, and status. |
| GetSolicitationActionsForOrder | Returns a list of solicitation types that are available for an order that you specify. |
| ListHandoverSlots | Returns time slots available for Easy Ship orders to be scheduled based on the package weight and dimensions that the seller specifies. |
| PurchaseShipment | Purchases a shipping service and returns purchase related details and documents. |
| RefreshOAuthAccessToken | Exchanges a access token for a new access token. |
| RequestReport | The RequestReport operation creates a report request. |
| ScheduleSelfShipAppointment | Confirms or reschedules a self-ship appointment slot against a shipment. |
| SetPackingInformation | Sets packing information for an inbound plan. |
| SubmitCartonContentFeed | Submits carton content information for FBA inbound shipments. |
| SubmitFulfillmentOrderStatus | Requests that Amazon update the status of an order in the sandbox testing environment. This is a sandbox-only operation and must be directed to a sandbox endpoint. |
| 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. |
| SubmitSourcingOnDemandFeed | Usage information for the operation SubmitSourcingOnDemandFeed.rsb. |
| SubmitVATInvoiceFeed | Submit a VAT invoice against a shipment. The invoice must be a PDF document. Note that UPLOAD_VAT_INVOICE is only available in the EU marketplace (VAT program). The throttling limit for the Invoicing Feed is one invoice upload every three seconds. This type is permitted by the Tax Invoicing (Restricted) role. |
| UpdateScheduledPackages | Updates the time slot for handing over the package indicated by the specified scheduledPackageId. You can get the new slotId value for the time slot by calling the listHandoverSlots operation before making another patch call. |
| UpdateShipmentStatus | Update the shipment status for a specific order. Intended to be used with sellers who are participating in the In-store Pickup program. |
| UpdateShipmentTrackingDetails | Updates a shipment's tracking details. |