Stored Procedures

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

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

CData JDBC Driver for Square Stored Procedures


Name	Description
AddItemImage	Uploads an image file to be represented by a CatalogImage object linked to an existing CatalogObject instance.
CancelInvoice	Cancels an invoice.
CancelSubscription	Schedules a CANCEL action to cancel an active subscription.
CaptureTransaction	Captures a transaction that was created with the Charge stored procedure with a DelayCapture value of true.
Charge	Charges a card represented by a card nonce or a customer's card on file.
CreateCatalogImage	Uploads an image file to be represented by a CatalogImage object linked to an existing CatalogObject instance.
CreateInvoiceAttachment	Uploads a file and attaches it to an invoice.
Createorder	Creates an Order that can then be referenced as OrderId in a request to the Charge endpoint.
DeleteInvoiceAttachment	Removes an attachment from an invoice and permanently deletes the file.
GetOAuthAccessToken	Gets an authentication token from Square.
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.
PublishInvoice	Publishes the specified draft invoice.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with Square.
VoidTransaction	Cancels a transaction that was created with the Charge stored procedure with a DelayCapture value of true.