Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with PayPal.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from PayPal, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for PayPal Stored Procedures
| Name | Description |
| AcceptDisputeOffer | Accepts the offer made by the merchant to resolve a dispute. |
| CancelUnclaimedPayoutItem | Cancels an unclaimed payout item, by ID. If no one claims the unclaimed item within 30 days, the funds are automatically returned to the sender. |
| CreateDraftInvoice | Creates a draft invoice. |
| CreateExchangeRateQuote | Creates an exchange rate quote for one or more currency pairs. |
| CreateOrder | Creates an order. Merchants and partners can add Level 2 and Level 3 data to payments to reduce risk and payment processing costs. |
| CreatePayment | Creates a sale, an authorized payment to be captured later, or an order. |
| CreatePayouts | Creates payouts in PayPal. |
| CreateSubscription | Creates a subscription in PayPal. |
| DeleteInvoice | Deletes a draft or scheduled invoice, by ID. |
| EscalateDispute | Escalates the dispute, for which the customer seeks PayPal intervention, to a PayPal claim. |
| GetOAuthAccessToken | Gets the OAuth access token from PayPal. |
| ProvideDisputeEvidence | Provides evidence for a dispute, in the form of a transaction ID or documents. |
| SendInvoice | Sends an invoice, by Id, to a customer. |
| SettleDispute | Settles a dispute in either the customer or merchant favor. Applicable for disputes with the UNDER_REVIEW status. |
| UpdateDisputeStatus | Updates the status of a dispute, by ID, from UNDER_REVIEW to either WAITING_FOR_BUYER_RESPONSE or WAITING_FOR_SELLER_RESPONSE. |