![]() |
Chilkat HOME Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi DLL Go Java Node.js Objective-C PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(SQL Server) PayPal - Create Direct Credit Card PaymentSee more PayPal ExamplesCreates a direct credit card payment where your application passes the credit card, shipping, and payment information to PayPal.Note: For sandbox calls, you can use the credit card numbers provided in your sandbox test accounts. Note: This is an example where you handle the card data directly, and therefore you would need to ensure you are PCI compliant. There are other ways to create a payment where your application does NOT handle the credit card data directly.
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls. -- CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @iTmp0 int -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) -- Note: Requires Chilkat v9.5.0.64 or greater. -- This requires the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. -- Load our previously obtained access token. (see PayPal OAuth2 Access Token) DECLARE @jsonToken int EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jsonToken OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @success int EXEC sp_OAMethod @jsonToken, 'LoadFile', @success OUT, 'qa_data/tokens/paypal.json' -- Build the Authorization request header field value. DECLARE @sbAuth int EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbAuth OUT -- token_type should be "Bearer" EXEC sp_OAMethod @jsonToken, 'StringOf', @sTmp0 OUT, 'token_type' EXEC sp_OAMethod @sbAuth, 'Append', @success OUT, @sTmp0 EXEC sp_OAMethod @sbAuth, 'Append', @success OUT, ' ' EXEC sp_OAMethod @jsonToken, 'StringOf', @sTmp0 OUT, 'access_token' EXEC sp_OAMethod @sbAuth, 'Append', @success OUT, @sTmp0 -- Make the initial connection. -- A single REST object, once connected, can be used for many PayPal REST API calls. -- The auto-reconnect indicates that if the already-established HTTPS connection is closed, -- then it will be automatically re-established as needed. DECLARE @rest int EXEC @hr = sp_OACreate 'Chilkat.Rest', @rest OUT DECLARE @bAutoReconnect int SELECT @bAutoReconnect = 1 DECLARE @success int EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'api.sandbox.paypal.com', 443, 1, @bAutoReconnect IF @success <> 1 BEGIN EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @jsonToken EXEC @hr = sp_OADestroy @sbAuth EXEC @hr = sp_OADestroy @rest RETURN END -- ---------------------------------------------------------------------------------------------- -- The code above this comment could be placed inside a function/subroutine within the application -- because the connection does not need to be made for every request. Once the connection is made -- the app may send many requests.. -- ---------------------------------------------------------------------------------------------- -- Build the JSON containing the credit card data and transaction information. DECLARE @json int EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT EXEC sp_OASetProperty @json, 'EmitCompact', 0 EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'intent', 'sale' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payer.payment_method', 'credit_card' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payer.funding_instruments[0].credit_card.number', '4032034813337237' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payer.funding_instruments[0].credit_card.type', 'visa' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payer.funding_instruments[0].credit_card.expire_month', '9' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payer.funding_instruments[0].credit_card.expire_year', '2028' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'payer.funding_instruments[0].credit_card.cvv2', '123' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transactions[0].amount.total', '10.00' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transactions[0].amount.currency', 'USD' EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'transactions[0].payee.email', 'payee@example.com' -- Use a sandbox CC number for testing: -- |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.