Stored Procedures

Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with Stripe.

Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Stripe, along with an indication of whether the procedure succeeded or failed.

CData SSIS Components for Stripe Stored Procedures


Name	Description
AcceptQuote	Accepts the quote and generates the invoice for the accepted quote.
ApproveReview	Approves a Review object, closing it and removing it from the list of reviews.
AttachPaymentMethodToCustomer	Attaches a payment method to a customer. This procedure is not applicable for future payments.
CancelClimateOrder	Cancels a Climate order. Only orders with status 'open' can be canceled.
CancelPaymentIntent	Cancels a payment intent. The status of the payment intent to cancel must be one of the following: requires_payment_method, requires_capture, requires_confirmation, requires_action, processing.
CancelQuote	Cancels the drafted quote.
CancelSubscription	Cancels a customer's subscription immediately.
CapturePaymentIntent	Captures the funds of an existing uncaptured payment intent when its status is requires_capture.
ConfirmPaymentIntent	Confirms that the customer intends to pay with the current or provided payment method.
CreateBillingMeterEvent	Creates a billing meter event.
CreateBillingMeterEventAdjustment	Creates a meter event adjustment object to cancel a previously sent meter event. Uses the V2 endpoint.
DeactivateMeter	Deactivates a billing meter. When a meter is deactivated, no more meter events are accepted for this meter.
DeleteCustomerDiscount	Removes the currently applied discount on a customer.
DeleteSubscriptionDiscount	Removes the currently applied discount on a subscription.
DetachPaymentMethodFromCustomer	Detaches a PaymentMethod object from a Customer. After a PaymentMethod is detached, it can no longer be used for a payment or re-attached to a Customer.
DisableEventDestination	Disables an event destination. Uses the V2 endpoint.
DownloadFile	Downloads a file from the Stripe account.
DownloadQuote	Downloads the PDF for a finalized quote.
EnableEventDestination	Enables an event destination.
FinalizeInvoice	Finalizes a draft invoice manually.
FinalizeQuote	Finalizes a draft quote.
GetOAuthAccessToken	Gets the OAuth access token from Stripe.
GetOAuthAuthorizationURL	Gets the Stripe authorization URL. Access the URL returned in the output in an Internet browser. This requests the access token that can be used as part of the connection string to Stripe.
MigrateSubscription	Upgrades the billing_mode of an existing subscription to flexible billing.
PingEventDestination	Sends a ping event to an event destination. Uses the V2 endpoint.
ReactivateMeter	Reactivates a billing meter. When a meter is reactivated, events for this meter can be accepted and you can attach the meter to a price.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with various Stripe services.
ResumeSubscription	Resumes a paused subscription, optionally resetting the billing cycle anchor and creating prorations.
UploadFile	Uploads a file to Stripe.
VoidCreditNotes	Marks the credit note as void.
VoidInvoice	Marks a finalized invoice as void.