Sample code for 30+ languages & platforms
SQL Server Requires Chilkat v11.0.0+

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.

PayPal documentation

Chilkat SQL Server Downloads

SQL Server
--
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