ADO.NET Provider for Square

Build 26.0.9770

CompletePayment

Completes (captures) a payment.

Stored Procedure Specific Information

Execute

You need to provide the PaymentId to execute the stored procedure. Optionally, provide the VersionToken to confirm you are completing the payment version you expect; if the server's version differs, the request fails with a VERSION_MISMATCH error.

Example with VersionToken (optional concurrency check):

EXECUTE CompletePayment PaymentId = 'fd9d6200-bb12-43c5-9973-070bfc6f5e05', VersionToken = 'aTkkQ3iBcFR5FrGQOu4Y6towGGkOZzMOn7DAtWTL5rE6o'

You can also complete a payment without VersionToken:

EXECUTE CompletePayment PaymentId = 'fd9d6200-bb12-43c5-9973-070bfc6f5e05'

Input

Name Type Required Description
PaymentId String True The unique ID identifying the payment to be completed.
VersionToken String False An optional token used to ensure idempotency. Identifies the current Payment version that the caller expects. If the server has a different version, the request fails with a VERSION_MISMATCH error.

Result Set Columns

Name Type Description
Success Boolean Whether the operation is successful or not.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770