SQL Server Requires Chilkat v11.0.0+
SQL Server
PayPal: Find captures for a known order
See more PayPal Examples
Read the known order and visit every purchase unit. Extract its captures with their IDs, statuses and amounts. An empty collection means this order has no such resources yet; it says nothing about other orders.
Chilkat SQL Server Downloads
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
DECLARE @iTmp1 int
DECLARE @sTmp0 nvarchar(4000)
DECLARE @sTmp1 nvarchar(4000)
DECLARE @sTmp2 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
-- See Unlock Chilkat before making requests.
-- For the merchant's internal backoffice application. Load the sandbox token
-- from the merchant's credential store. Keep it out of publicly distributed apps.
-- See Get a PayPal access token.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
EXEC sp_OASetProperty @http, 'AuthToken', 'SANDBOX_ACCESS_TOKEN'
DECLARE @resp int
EXEC @hr = sp_OACreate 'Chilkat.HttpResponse', @resp OUT
EXEC sp_OAMethod @http, 'SetUrlVar', @success OUT, 'id', 'ORDER_ID'
EXEC sp_OAMethod @http, 'HttpNoBody', @success OUT, 'GET', 'https://api-m.sandbox.paypal.com/v2/checkout/orders/{$id}', @resp
IF @success <> 1
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT 'No HTTP response: ' + @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @resp
RETURN
END
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp1 OUT
IF (@iTmp0 < 200) or (@iTmp1 >= 300)
BEGIN
DECLARE @errorInfo int
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @errorInfo OUT
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
EXEC sp_OAMethod @errorInfo, 'Load', @success OUT, @sTmp0
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
EXEC sp_OAMethod @errorInfo, 'StringOf', @sTmp0 OUT, 'name'
EXEC sp_OAMethod @errorInfo, 'StringOf', @sTmp1 OUT, 'details[0].issue'
PRINT 'HTTP ' + @iTmp0 + ' ' + @sTmp0 + ' ' + @sTmp1
EXEC sp_OAMethod @errorInfo, 'StringOf', @sTmp0 OUT, 'debug_id'
PRINT 'PayPal debug ID: ' + @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @errorInfo
RETURN
END
DECLARE @result int
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @result OUT
DECLARE @parsed int
EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
EXEC sp_OAMethod @result, 'Load', @parsed OUT, @sTmp0
IF @parsed <> 1
BEGIN
EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
PRINT 'Expected a JSON response; HTTP ' + @iTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @errorInfo
EXEC @hr = sp_OADestroy @result
RETURN
END
-- A purchase unit may have no captures yet, or more than one.
DECLARE @i int
SELECT @i = 0
EXEC sp_OAMethod @result, 'SizeOfArray', @iTmp0 OUT, 'purchase_units'
WHILE (@i < @iTmp0)
BEGIN
EXEC sp_OASetProperty @result, 'I', @i
DECLARE @j int
SELECT @j = 0
EXEC sp_OAMethod @result, 'SizeOfArray', @iTmp0 OUT, 'purchase_units[i].payments.captures'
WHILE (@j < @iTmp0)
BEGIN
EXEC sp_OASetProperty @result, 'J', @j
EXEC sp_OAMethod @result, 'StringOf', @sTmp0 OUT, 'purchase_units[i].reference_id'
EXEC sp_OAMethod @result, 'StringOf', @sTmp1 OUT, 'purchase_units[i].payments.captures[j].id'
PRINT 'Unit: ' + @sTmp0 + ' capture: ' + @sTmp1
EXEC sp_OAMethod @result, 'StringOf', @sTmp0 OUT, 'purchase_units[i].payments.captures[j].status'
EXEC sp_OAMethod @result, 'StringOf', @sTmp1 OUT, 'purchase_units[i].payments.captures[j].amount.value'
EXEC sp_OAMethod @result, 'StringOf', @sTmp2 OUT, 'purchase_units[i].payments.captures[j].amount.currency_code'
PRINT ' ' + @sTmp0 + ' ' + @sTmp1 + ' ' + @sTmp2
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @errorInfo
EXEC @hr = sp_OADestroy @result
END
GO