(Excel) PayPal -- Get an OAuth 2.0 Access Token

Demonstrates how to send a request to get a PayPal OAuth2 access token. Sends an HTTP request equivalent to the following:

curl https://api.sandbox.paypal.com/v1/oauth2/token \
  -H "Accept: application/json" \
  -H "Accept-Language: en_US" \
  -u "Client-Id:Secret" \
  -d "grant_type=client_credentials"

Download Excel Class Modules Chilkat Excel Class Modules

' 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.

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' 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.

bAutoReconnect = True

success = rest.Connect("api.sandbox.paypal.com",443,True,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' Duplicate this request:

' 	curl https://api.sandbox.paypal.com/v1/oauth2/token \
' 	  -H "Accept: application/json" \
' 	  -H "Accept-Language: en_US" \
' 	  -u "Client-Id:Secret" \
' 	  -d "grant_type=client_credentials"

success = rest.AddHeader("Accept","application/json")
success = rest.AddHeader("Accept-Language","en_US")

' For additional help on where to find  your client ID and API secret, see PayPal Client_ID and API_Secret
success = rest.SetAuthBasic("PAYPAL_REST_API_CLIENT_ID","PAYPAL_REST_API_SECRET")

success = rest.AddQueryParam("grant_type","client_credentials")


responseStr = rest.FullRequestFormUrlEncoded("POST","/v1/oauth2/token")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Debug.Print rest.LastRequestHeader

' A sample response:

' 	{
' 	  "scope": "https://api.paypal.com/v1/payments/.* https://api.paypal.com/v1/vault/credit-card https://api.paypal.com/v1/vault/credit-card/.*",
' 	  "access_token": "EEwJ6tF9x5WCIZDYzyZGaz6Khbw7raYRIBV_WxVvgmsG",
' 	  "token_type": "Bearer",
' 	  "app_id": "APP-6XR95014BA15863X",
' 	  "expires_in": 28800
' 	}

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.Load(responseStr)
json.EmitCompact = False

' Check the response status code.  A 200 indicates success..
If (rest.ResponseStatusCode <> 200) Then
    Debug.Print json.Emit()
    Debug.Print "Failed."
    Exit Sub
End If

' Given that the access token expires in approx 8 hours,
' let's record the date/time this token was created.
' This will allow us to know beforehand if the token
' is expired (and we can then fetch a new token).
Dim dateTime As Chilkat.CkDateTime
Set dateTime = Chilkat.NewCkDateTime

bLocalTime = False

dtNow = dateTime.GetAsUnixTime(bLocalTime)
success = json.AppendInt("tokenCreateTimeUtc",dtNow)

' Examine the access token and save to a file.
Debug.Print "Access Token: "; json.StringOf("access_token")
Debug.Print "Full JSON Response:"
Debug.Print json.Emit()

Dim sbResponse As Chilkat.StringBuilder
Set sbResponse = Chilkat.NewStringBuilder
success = sbResponse.Append(json.Emit())

bEmitBom = False
success = sbResponse.WriteFile("qa_data/tokens/paypal.json","utf-8",bEmitBom)