ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Square の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにSquare から関連するレスポンスデータを返します。
CData ADO.NET Provider for Square ストアドプロシージャ
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. |