Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT/INSERT/UPDATE/DELETE operations with Shopify.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Shopify, along with an indication of whether the procedure succeeded or failed.
CData JDBC Driver for Shopify Stored Procedures
| Name | Description |
| AcceptCancellationRequest | Accepts a cancellation request sent to a fulfillment service for a fulfillment order. |
| AcceptFulfillmentRequest | Accepts a fulfillment request sent to a fulfillment service for a fulfillment order. |
| ApproveComment | Marks a blog comment as approved, making it publicly visible on the storefront. |
| AssignDefaultAddress | Assigns a customer's selected address as the default shipping and billing address in their profile. |
| CalculateRefund | Calculates refund amounts for order line items and shipping, returning a breakdown of refundable totals. |
| ChangeSpamStatus | Updates a comment's spam status, toggling between spam and non-spam classification. |
| CompleteDraftOrder | Finalizes a draft order and converts it into a completed order ready for checkout and fulfillment. |
| CreateAccountActivationUrl | Generates a secure URL that allows a customer to activate their online store account. |
| GetOAuthAccessToken | Gets an authentication token from Shopify. |
| GetOAuthAuthorizationURL | Gets the authorization URL that must be opened separately by the user to grant access to your application. Only needed when developing Web apps. You will request the OAuthAccessToken from this URL. |
| RejectCancellationRequest | Rejects a cancellation request sent to a fulfillment service for a fulfillment order. |
| RejectFulfillmentRequest | Rejects a fulfillment request sent to a fulfillment service for a fulfillment order. |
| RestoreComment | Restores a comment that was previously deleted or marked as removed. |
| SendCancellationRequest | Sends a cancellation request to the fulfillment service of a fulfillment order. |
| SendFulfillmentRequest | Sends a fulfillment request to the fulfillment service of a fulfillment order. |
| SendInvite | Sends an account invitation email to a customer, with optional custom messaging. |
| SendInvoice | Emails a draft order invoice to a customer, allowing them to complete payment via checkout. |
| UpdateQuantity | Updates available inventory quantities for a specific product variant at a designated location. |