SQL Server Stripe: Retrieve a Token

Back to Index

Retrieves the token with the given ID.

Documentation: https://stripe.com/docs/api/curl#retrieve_token

CURL Command

curl https://api.stripe.com/v1/tokens/tok_1BnETKGswQrCoh0XcX6WAG5q \
   -u STRIPE_SECRET_KEY:

SQL Server Example

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @rest int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Rest', @rest OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    --  URL: https://api.stripe.com/v1/tokens/tok_1BnETKGswQrCoh0XcX6WAG5q
    DECLARE @bTls int
    SELECT @bTls = 1
    DECLARE @port int
    SELECT @port = 443
    DECLARE @bAutoReconnect int
    SELECT @bAutoReconnect = 1
    EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'api.stripe.com', STR(@port), STR(@bTls), STR(@bAutoReconnect)
    IF STR(@success) <> 1
      BEGIN

        EXEC sp_OAGetProperty @rest, 'ConnectFailReason', @iTmp0 OUT
        PRINT 'ConnectFailReason: ' + @iTmp0
        EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @rest
        RETURN
      END

    EXEC sp_OAMethod @rest, 'SetAuthBasic', @success OUT, 'STRIPE_SECRET_KEY', ''

    DECLARE @sbResponseBody int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT

    EXEC sp_OAMethod @rest, 'FullRequestNoBodySb', @success OUT, 'GET', '/v1/tokens/tok_1BnETKGswQrCoh0XcX6WAG5q', STR(@sbResponseBody)
    IF STR(@success) <> 1
      BEGIN
        EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @sbResponseBody
        RETURN
      END

    DECLARE @jsonResponse int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jsonResponse OUT

    EXEC sp_OAMethod @jsonResponse, 'LoadSb', @success OUT, STR(@sbResponseBody)

    DECLARE @id nvarchar(4000)

    DECLARE @object nvarchar(4000)

    DECLARE @cardId nvarchar(4000)

    DECLARE @cardObject nvarchar(4000)

    DECLARE @cardAddress_city int

    DECLARE @cardAddress_country int

    DECLARE @cardAddress_line1 int

    DECLARE @cardAddress_line1_check int

    DECLARE @cardAddress_line2 int

    DECLARE @cardAddress_state int

    DECLARE @cardAddress_zip int

    DECLARE @cardAddress_zip_check int

    DECLARE @cardBrand nvarchar(4000)

    DECLARE @cardCountry nvarchar(4000)

    DECLARE @cardCvc_check int

    DECLARE @cardDynamic_last4 int

    DECLARE @cardExp_month int

    DECLARE @cardExp_year int

    DECLARE @cardFingerprint nvarchar(4000)

    DECLARE @cardFunding nvarchar(4000)

    DECLARE @cardLast4 nvarchar(4000)

    DECLARE @cardName int

    DECLARE @cardTokenization_method int

    DECLARE @client_ip int

    DECLARE @created int

    DECLARE @livemode int

    DECLARE @type nvarchar(4000)

    DECLARE @used int

    EXEC sp_OAMethod @jsonResponse, 'StringOf', @id OUT, 'id'
    EXEC sp_OAMethod @jsonResponse, 'StringOf', @object OUT, 'object'
    EXEC sp_OAMethod @jsonResponse, 'StringOf', @cardId OUT, 'card.id'
    EXEC sp_OAMethod @jsonResponse, 'StringOf', @cardObject OUT, 'card.object'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardAddress_city OUT, 'card.address_city'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardAddress_country OUT, 'card.address_country'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardAddress_line1 OUT, 'card.address_line1'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardAddress_line1_check OUT, 'card.address_line1_check'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardAddress_line2 OUT, 'card.address_line2'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardAddress_state OUT, 'card.address_state'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardAddress_zip OUT, 'card.address_zip'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardAddress_zip_check OUT, 'card.address_zip_check'
    EXEC sp_OAMethod @jsonResponse, 'StringOf', @cardBrand OUT, 'card.brand'
    EXEC sp_OAMethod @jsonResponse, 'StringOf', @cardCountry OUT, 'card.country'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardCvc_check OUT, 'card.cvc_check'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardDynamic_last4 OUT, 'card.dynamic_last4'
    EXEC sp_OAMethod @jsonResponse, 'IntOf', @cardExp_month OUT, 'card.exp_month'
    EXEC sp_OAMethod @jsonResponse, 'IntOf', @cardExp_year OUT, 'card.exp_year'
    EXEC sp_OAMethod @jsonResponse, 'StringOf', @cardFingerprint OUT, 'card.fingerprint'
    EXEC sp_OAMethod @jsonResponse, 'StringOf', @cardFunding OUT, 'card.funding'
    EXEC sp_OAMethod @jsonResponse, 'StringOf', @cardLast4 OUT, 'card.last4'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardName OUT, 'card.name'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @cardTokenization_method OUT, 'card.tokenization_method'
    EXEC sp_OAMethod @jsonResponse, 'IsNullOf', @client_ip OUT, 'client_ip'
    EXEC sp_OAMethod @jsonResponse, 'IntOf', @created OUT, 'created'
    EXEC sp_OAMethod @jsonResponse, 'BoolOf', @livemode OUT, 'livemode'
    EXEC sp_OAMethod @jsonResponse, 'StringOf', @type OUT, 'type'
    EXEC sp_OAMethod @jsonResponse, 'BoolOf', @used OUT, 'used'

    EXEC @hr = sp_OADestroy @rest
    EXEC @hr = sp_OADestroy @sbResponseBody
    EXEC @hr = sp_OADestroy @jsonResponse


END
GO

Sample JSON Response Body

{
  "id": "tok_1BnETKGswQrCoh0XcX6WAG5q",
  "object": "token",
  "card": {
    "id": "card_1BnETKGswQrCoh0Xa7UvZihk",
    "object": "card",
    "address_city": null,
    "address_country": null,
    "address_line1": null,
    "address_line1_check": null,
    "address_line2": null,
    "address_state": null,
    "address_zip": null,
    "address_zip_check": null,
    "brand": "Visa",
    "country": "US",
    "cvc_check": null,
    "dynamic_last4": null,
    "exp_month": 8,
    "exp_year": 2019,
    "fingerprint": "F9mANtIt1TaukpRJ",
    "funding": "credit",
    "last4": "4242",
    "metadata": {},
    "name": null,
    "tokenization_method": null
  },
  "client_ip": null,
  "created": 1516662782,
  "livemode": false,
  "type": "card",
  "used": false
}