Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the driver 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 ODBC Driver 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.